DataGridView and Access Database?

Question

Dear Friends I want to direct manipulation of the Access database by this DataGridView control how to Insertdeleteupdateselect? synchronization update? thanks!

Shweta Lodha · Answer

You can use that if you want to save data whenever any of the cell value is changed. But as a good practice we don't do this. You might need to save/insert/delete data on particular button click or on some event instead of hitting DB on every cell change

Shweta Lodha · Answer

Please see this sample code: using (OleDbConnection dbConn = new OleDbConnection(@Provider=Microsoft.Jet.OleDb.4.0;Data Source=..\..\..\Scanner.mdb)) { OleDbCommand cmd2 = dbConn.CreateCommand(); cmd2.CommandText = update Code set ProcessedCode=?BarCode=? where ID=?; cmd2.Parameters.AddWithValue(ProcessedCodeValue txtScannedValue.Text); cmd2.Parameters.AddWithValue(BarCodeValue DBNull.Value); cmd2.Parameters.AddWithValue(IDValue rowID); cmd2.ExecuteNonQuery(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); ds.Tables.Add(dt); OleDbDataAdapter dd = new OleDbDataAdapter(); dd = new OleDbDataAdapter(Select * From Code dbConn); dd.Fill(dt); dataGridView1.DataSource = dt.DefaultView; dbConn.Close(); }

lbs yin · Answer

Hi Shweta do i need to use private void dataGridView2_CellValueChanged(object sender DataGridViewCellEventArgs e) ?