DataGridView and Access Database?

lbs yin

Dear Friends,

I want to direct manipulation of the Access database by this DataGridView control, how to Insert,delete,update,select?

synchronization update?

thanks!

3 Replies

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

Shweta Lodha12y ago
Accepted 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
lbs yin12y ago
Hi Shweta, do i need to use "private void dataGridView2_CellValueChanged(object sender, DataGridViewCellEventArgs e)" ?
Shweta Lodha12y ago
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();
}