S
Sameer Motwani
Hi,
Is there a way to add, delete, select and update multiple DataTables in a
Dataset using a Single SQL String and a single DataAdapter object.
I read somewhere that we could fill multiple tables in a dataset by
sepearting the two queries by a ;
like SELECT * FROM TABLE1 ; SELECT * FROM TABLE2 and using this query
statement with a DataAdapter objects. But this works only with
SQL Server, but I am using Access 97 database and so whenever I run the
above query I get an exception.
Any help or suggestions will be highly appreciated.
Regards
Sameer
Is there a way to add, delete, select and update multiple DataTables in a
Dataset using a Single SQL String and a single DataAdapter object.
I read somewhere that we could fill multiple tables in a dataset by
sepearting the two queries by a ;
like SELECT * FROM TABLE1 ; SELECT * FROM TABLE2 and using this query
statement with a DataAdapter objects. But this works only with
SQL Server, but I am using Access 97 database and so whenever I run the
above query I get an exception.
Any help or suggestions will be highly appreciated.
Regards
Sameer