Compare Database with Database in Data Grid View

[Wiz Kid]

Hello VBDotNETForums.

I am new to ADO.NET.

I have an Access (2003) database that I've got binded to a data grid view. What I need to do is compare the data in the data grid view to the actual database. Then, if there are changes, I will save the changes.

What exactly do I need to be comparing?

Thanks!

 

[Wiz Kid]

Resolved. I have decided just to use the CellBeginEdit event to perform a check.

Thanks anyways!

 

[Paszt]

What you should be doing is using the power of databinding. Bind the dataGridView to a dataset, then you can check the HasChanges property of the dataset to see if it has changes. If it does, use a DataAdapter to update the changes (usually the same DataAdapter used to fill the dataset).
This is the basic idea of ADO.NET, a disconnected architecture utilized to limit communication with the database and therefore improve performance.
Check out msdn2.microsoft.com for many articles on ADO.NET.

 

[Arg81]

As Paszt has suggested, this is the standard ideas behind ADO.NET

There are a number of walkthroughs on MSDN, a good starting point to then follow through from would be
http://msdn2.microsoft.com/en-us/library/ms171893(VS.80).aspx