Deleting multiple rows from a table

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?

Updated on 28-Sep-2013

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();
}

forum

Deleting multiple rows from a table

Aaron Douglas

1 Answers

Liked By