How To Delete Multiple Selected Rows of Datagridview ?

Ajit N

Hi, I want to delete selected rows of datagridview and from database also.

So, I tried following code, but only one row are deleted at one time in datagridview and also selected row are not delete from database.

so, plz help me..

This is my code..

SqlCommand delcmd = new SqlCommand();
if (dataGridView1.Rows.Count > 1 && dataGridView1.SelectedRows[0].Index != dataGridView1.Rows.Count - 1)
{
delcmd.CommandText = "DELETE FROM StudentRegistration WHERE Rollno=" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString() + "";
//con.Open();
delcmd.Connection = con;
delcmd.ExecuteNonQuery();
//con.Close();
dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[0].Index);
MessageBox.Show("Row has been Deleted");
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava9y ago
Please refer this link
http://www.c-sharpcorner.com/UploadFile/1e050f/insert-update-and-delete-record-in-datagridview-C-Sharp/
0
Chetan Ranpariya9y ago
Hi Ajit,

In "StudentRegistraion" table there can be multiple rows with the same Rollno?

If NO, then how can you expect multiple rows to be deleted?

And as per your code you are calling RemoveAt method only once in your code. How will it remove multiple rows from the gridview?
IF dataGridView1.SelectedRows have more than one value then RemoveAt method should be called for all the values.

let me know if my understanding is correct.

thanks and regards,
Chetan Ranpariya
0
Amit Kumar Singh9y ago
hello

refer this link for ur reference

1.http://www.c-sharpcorner.com/uploadfile/33b051/delete-multiple-record-from-a-datagridview-using-checkbox-i/
2.http://stackoverflow.com/questions/13369273/removing-selected-rows-in-datagridview
3.http://stackoverflow.com/questions/6903393/delete-multiple-rows-in-datagridview
0