Hi Friends,

 In VB.NET windows application, I want to update my database using datagrid.
means whenever a user enters the data in the datagrid, it should be updated in the database also.

I m using disconnected archi. means with SqlDataAdapter. If possible then pls give necessary details.

Hi,

Create a table structure and instantiate the Datatable. Add column to the data table structure.

you bin this table to a datagrid.

After you accept the data, You can update the database using update method of the DataAdapter. This method is responsible for examining the RowState property of each of the DataRow objects in the Rows collection. The RowsCollection is a member of each of the DataTable objects contained in the Tables collection of the dataset.

Ex: myAdapter.Update(myDataSet.GetChanges,"Table1")

You can refer this Title: Database programming using VB.net and Sql server 2000"

Regards
bhar