Delete row from database using C# in ASP.Net

micah says:

if (!string.IsNullOrEmpty(txtfrom.Text) && !string.IsNullOrEmpty(txtTo.Text))

{

    for (int i = Convert.ToInt32(txtfrom.Text); i <= Convert.ToInt32(txtTo.Text); i++)

    {

        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString))

        {

            using (SqlCommand cmd = new SqlCommand("DELETE FROM Range WHERE Numbers = @Numbers ", con))

            {

 

                cmd.CommandType = CommandType.Text;

            cmd.Parameters.AddWithValue("@Numbers", i);

            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))

                {

                    using (DataTable dt = new DataTable())

                    {

                        sda.Fill(dt);

                        GridView1.DataSource = dt;

                        GridView1.DataBind();

                    }

Use below.

        if (!string.IsNullOrEmpty(txtfrom.Text) && !string.IsNullOrEmpty(txtTo.Text))
        {
            for (int i = Convert.ToInt32(txtfrom.Text); i <= Convert.ToInt32(txtTo.Text); i++)
            {
                using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString))
                {
                    using (SqlCommand cmd = new SqlCommand("DELETE FROM Range WHERE Numbers = @Numbers ", con))
                    {

                        cmd.CommandType = CommandType.Text;
                        cmd.Parameters.AddWithValue("@Numbers", i);
                        con.Open();
                        cmd.ExecuteNonQuery();
                        con.Close();
                    }
                }
            }
        }