How to update datagrid by commandbuilder?

G

goharulislam

Member
Joined
Dec 11, 2003
Messages
6
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
 
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
 
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
 
Back
Top