How to delete rows in a datagridview and database

Satbr Brsat

I am developing an application in C # with access to a database created in MS Access 2007. I have a WindowsForm to delete records from the database, but I'm only able to delete rows in the datagriedview (except the first) and the database is not being updated.

I get this error when I try to delete a row:

System.Data.OleDbException (0x80040E10): There was provided no value to one or more required parameters.

Here is my code:

private void btn_remover_Click(object sender, EventArgs e) { using (OleDbConnection oleConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Stock_Material.accdb")) { try {                    oleConn.Open(); if (MessageBox.Show("Tem a certeza que pretende remover este registo(s)", " Confirmação", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == System.Windows.Forms.DialogResult.Yes) foreach (DataGridViewRow row in dataGridView_remover.SelectedRows) { int rowId = Convert.ToInt32(row.Cells[0].Value); if (rowId > 0) {                               dataGridView_remover.Rows.RemoveAt(row.Index); OleDbCommand delcmd = new OleDbCommand("Delete from product where id_Produto= " + rowId + "");                            delcmd.Connection = oleConn;                            delcmd.ExecuteNonQuery(); } } } catch (Exception ex ) { MessageBox.Show(ex.ToString()); }                oleConn.Close(); } }

How can I solve these problems:

The database is not updated when i delete a record in the datagriedview.
Don't let me delete the first line in datagriedview

Thanks in advance

6 Replies

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

Madhanmohan Devarajan10y ago
Accepted answer
OleDbCommand delcmd = new OleDbCommand("Delete from product where id_Produto='" + rowId + "', oleConn);
This is what your are missing "+" (highlighted in yellow) just before "".

Roshan Guragain10y ago

if only one selection is allowed in the DataGridView, we can use this :

if (BooksGrid.SelectedRows.Count > 0)
{
int selectedIndex = BooksGrid.SelectedRows[0].Index;

// gets the RowID from the first column in the grid
int rowID = int.Parse(BooksGrid[0, selectedIndex].Value.ToString());

string sql = "DELETE FROM Table1 WHERE RowID = @RowID";

// your code for deleting it from the database

// then your code for refreshing the DataGridView
}

Satbr Brsat10y ago
Madhanmohan Devarajanthanks,
but i'm getting an error in this line:
OleDbCommand delcmd = new OleDbCommand("Delete from product where id_Produto='" + rowId"', oleConn);
Maybe some ' or " missing???
Madhanmohan Devarajan10y ago
Satbr,
Please try this.
if(!row.IsNewRow)
{
dataGridView_remover.Rows.Remove(row);
OleDbCommand delcmd = new OleDbCommand("Delete from product where id_Produto=" + rowId , oleConn);

delcmd.ExecuteNonQuery();
}
Md Ghouse10y ago
private void Binddata(){
var x=from n in db.Employees
select n;
return x.Tolist();
}
now u will use Binddata(); methode wer u want to bind Here Employees my table name
Bikesh Srivastava10y ago
Hi,
Visit here
http://csharp.net-informations.com/datagridview/deletegridview.htm

How to delete rows in a datagridview and database

Madhanmohan Devarajanthanks,