How to update datagrid by commandbuilder?

[goharulislam]

Hi

Plz help me, I want to know about editing and updating in datagrid. I am using vb.net and dataset in asp.net pages. I think problem is I am using CommandBuilder to update data source directly.

take care

thanks bye

[Puiu]

You cannot update multiple tables using a commandbuilder. Your query must not contain a join for the commandbuilder to work!

 

The code is something like this:

Dim cb As New SqlCommandBuilder(DataAdapter)

 

DataAdapter.Update(DataSet)

dataset.AcceptChanges

 

you must supply a valid dataadapter that fills a dataset using a query that selects data only from one table and it is not using a join to retrieve the data.

 

Maybe you could show us some code and maybe someone will figure out what your problem is

Cheers

[goharulislam]

OK

Can you please tell me any url which has solution of my problem i.e. edit in data grid. Using dataset because as you are saying that commandbuilder cannot update multiple table at the same time. I am working in VB.NET.

Thanks alot for taking so much interest in my problem.

Take care

Bye