View Single Post
  #1 (permalink)  
Old January 15th, 2009, 06:05 AM
Rohit Kapoor Rohit Kapoor is offline
Registered User
 
Join Date: Jan 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Post how to update data source using data adapter

i have created a table TBL in my dataset DS, and loaded TBL with a query which accesses data from 5 tables in Main Data Source. Now This Table is linked to data grid view i.e DG as data source.

now if i edit in DG, i use DS.acceptChanges() to update my Dataset with the updations.

my dataset is updated.

now i want to update my data source with this DS.

I m using DA (Data adapter)'s Upadte function with Argument DS.

But its asking for the table and not updating my data source at sql server.

what should i do now?