deleting a row from datagridview in window application using access database c#

• • Reply

  10 years ago

  by ramcdac.ravi

  ram kumar

  delhi, India

  Joined 10 years ago

  i want to delete a selected row from datagridview i nmy window application and the changes should reflect in the database . i use the code below

  OleDbConnection connString = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Database1.accdb"); connString.Open(); string query = "SELECT * FROM emp_info"; OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString); OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter); DataTable dTable = new DataTable(); dAdapter.Fill(dTable);

          BindingSource bSource = new BindingSource();
          bSource.DataSource = dTable;
          dataGridView1.DataSource = bSource;
          DataGridViewRow removingRow = new DataGridViewRow();
          dataGridView1.Rows.Remove(removingRow);
          //dgView.Rows.Remove(removingRow);
          dAdapter.Update(dTable);
          connString.Close();
  

  but at dataGridView1.Rows.Remove(removingRow); it gives exception saying

  argument exception was unhandled Row provided does not belong to this DataGridView control. Parameter name: dataGridViewRow

  please help me.

  Report abuse