Deleting multiple rows from a table

Aaron Douglas 1982 28 Sep 2013

I have a table and I want to delete all rows with a specific card serial . There are multiple rows with the same card serial .So I wrote this code but it seems that's not working:

try

{

using (SqlConnection con = new SqlConnection(WF_AbsPres.Properties.Settings.Default.DbConnectionString))

{

   con.Open();

   SqlCommand command2 = new SqlCommand("DELETE  FORM DevInOut where Cardserial='" + textBox5.Text + "'", con);

   command2.ExecuteNonQuery();

   con.Close();

}

}

   catch (SqlException ex)

{

}

how can assure all the rows will be deleted . Should I use procedure? How do I use procedure?

Ask by Aaron Douglas

Updated 28 Sep 2013

1 Answers

Madam Walker 28 Sep 2013

Hey Aaron!

Change your FORM to FROM.

using (SqlConnection con = new SqlConnection(WF_AbsPres.Properties.Settings.Default.DbConnectionString))

{

   con.Open();

   SqlCommand command2 = new SqlCommand("DELETE FROM DevInOut where Cardserial=@Cardserial", con);

   commdand2.Parameters.AddWithValue("@Cardserial", textBox5.Text);

   command2.ExecuteNonQuery();

   con.Close();

}

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Deleting multiple rows from a table

Can you answer this question?

1 Answers