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?