Delete a record from a datagridview in Winform

Question

I want to delete records from database in datagridview on window form app.

here is my code

System.Data.SqlClient.SqlCommandBuilder cb2;

cb2 = new System.Data.SqlClient.SqlCommandBuilder(da);

DataTable dt2 = ds.Tables["Employee"];

dt.PrimaryKey = new DataColumn[] { dt.Columns["EmpID"] };

dtDelete.Delete();

da.Update(ds, "Employee");

MessageBox.Show("Record Deleted");

I get this exception error with the above code, Object reference not set to an instance of an object.

Then I tried using the following code.

int inc = 0;

int maxRow = 0;

maxRow = ds.Tables["tblImpi"].Rows.Count;

ds.Tables["tblImpi"].Rows[inc].Delete();

Update();

maxRow = ds.Tables["tblImpi"].Rows.Count;

inc--;

// NavigateRecords();

MessageBox.Show("Record Deleted");

This one works but only delete records from the first row only

Ramesh Maruthi · Answer

yes Kevin Its a button click  once look at this below link and point me the exception line if you face a problem this links updates even in the database : http://www.codeproject.com/Questions/454755/Csharp-Datagridview-update-and-delete if you just want to delete on the front end you can do in this way private void btnDelete_Click(object sender EventArgs e) { foreach (DataGridViewRow item in this.dataGridView1.SelectedRows) { dataGridView1.Rows.RemoveAt(item.Index); } }

Munesh Sharma · Answer

http://aspforums.net/Threads/169354/How-to-delete-row-in-DataGridView-in-Windows-Forms-WinForms-application-using-C-and-VB-Net/

kevin · Answer

Yes I'm selecting a row to delete but nothing is happeningI'm struggling to understand this part of code private void dgv_UserDeletingRow( object sender DataGridViewRowCancelEventArgs e) (object sender DataGridViewRowCancelEventArgs e) I'm not sure whether is a button click event or where to look for it in the propertiesbecause I tried to a buttonletter I removed that button click

Ramesh Maruthi · Answer

Hi Kevin Are you selecting some rows or not from a gridview while deleting ?

kevin · Answer

H Ramesh I went to the link that you recommend I must check and I used the following code and I still the an exception error private void btnDel_Click( object sender EventArgs e) { if (!e.Row.IsNewRow) { DialogResult res = MessageBox .Show( Are you sure you want to delete this row?  Delete confirmation  MessageBoxButtons .YesNo MessageBoxIcon .Question); if (res == DialogResult .No) e.Cancel = true ; } }

Ramesh Maruthi · Answer

Hi Kevin Look at this link http://www.dotnetcurry.com/showarticle.aspx?ID=132