Updating a database from a datagrid
Posted on 2007-08-06
I am using VB.NET (VS 2003), with SQL Server 2000.
I have a datagrid which is populated through a dataset with information from a SQL Server table. The user is to be able to add rows to the existing data and also change some of the data that has already been pulled out of SQL Server.
My question is, what is the best way to go about updating the database with all changes? When should the update occur? What code should I use?
Any comments would be great.