I am relaively new to VB.NET and very new to Database type programming. I have a very simple problem that I can't find a SIMPLE solution to. Maybe there isn't one...

I have a DataGrid on a form that I have had no problem populating using an existing MDB file. I am using an OleDbDataApapter, an OleDbDataConnection as well as a DataSet.

I have the DataGrid being populated when the form loads. At this point, I can edit the entries in the DataBase. When I exit the form, the changes are not saved.

Is there a simple property or line or two of code that automatically saves ALL changes made to the DataBase? My apologies for my ignorance, and my thanks for any help!

I assume you used the DataGrid properties to add an edit capability. To save the data you need to add an an event handler. Then, when the grid row is in edit mode, the leftmost column contains an update link. When the user clicks the update link it raises an UpdateCommand event. Write the code in that handler.
1. Click the events button at the top of the properties window.
2. Double-click the update command. A DataGrid1_Update1Command handler is added. Add code there.

HtH


Sandra MacGregor

Thanks Sandra,

I have ended up using XML. The database is quite small so I can do away with it. It leaves me options for exchanging the data between a couple of applications too.

Probably sac religious in programming circles but...
:-)