Have a writable datagrid using an mdb

[Gian]

Hello, i'm trying to connect a DataGrid with a query that read a table of an MDB Access database. I've used OleDbConnection, OleDbDataAdapter and DataSet to access via the OLEDB 4.0 Provider the file. After that i can see the records. The code, used in Form Load is: connection1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Temp\\Brick1.MDB"); dataadapter1 = new OleDbDataAdapter("SELECT * FROM [Articles];", connection1); dataset1 = new DataSet("DataSetTest"); dataadapter1.Fill(dataset1, "articles"); dataGrid1.DataSource = dataset1.Tables["articles"]; The problem is that if i change some cell value, than i close the window and reopen, i cant see any change of mine. Is there a simple way to update the data at every cell change or when selection is moved on a new row? i cant see any update events on the DataGrid component. I've searched for tutorials about this but i cant find anything about "forcing data update" from the grid.

[Mazdak]

Gian wrote: there a simple way to update the data at every cell change or when selection is moved on a new row? i cant see any update events on the DataGrid component. CurrenCellChaneged event. Mazy "I think that only daring speculation can lead us further and not accumulation of facts." - Albert Einstein

[Heath Stewart]

The DataGrid is only a view on the data. The CurrentCellChanged event isn't really the place to update the database with your changes, which you must do manually. Changing values in the DataGrid will change your DataSet, but you must update the database with those changes using OleDbDataAdapter.Update, which requires that you assign the necessary properties like InsertCommand, UpdateCommand, and DeleteCommand, besides the required SelectCommand. If you don't update the database, then when you re-get your DataSet it won't have any changes. This is not automatic. Again, the CurrentCellChanged is fired too often and should not be used to update your database. Instead, do that when the form is closed or use a button who's Click event handler updates the database. See the OleDbDataAdapter class documentation for more information.

Microsoft MVP, Visual C# My Articles