Delete a record from a datagridview in Winform

kevin

12y1.8k

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

6 Replies

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

Ramesh Maruthi12y ago
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);
}
}
0
Munesh Sharma12y ago
http://aspforums.net/Threads/169354/How-to-delete-row-in-DataGridView-in-Windows-Forms-WinForms-application-using-C-and-VB-Net/
0
kevin12y ago

Yes I'm selecting a row to delete but nothing is happening,I'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 properties,because I tried to
a button,letter I removed that button click
0
Ramesh Maruthi12y ago
Hi Kevin,

Are you selecting some rows or not from a gridview while deleting ?
0
kevin12y ago

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;

}

}

0
Ramesh Maruthi12y ago
Hi Kevin,

Look at this link

http://www.dotnetcurry.com/showarticle.aspx?ID=132
0