Link to home
Start Free TrialLog in
Avatar of eternal_21
eternal_21

asked on

SQL Server/ ADO Multiple Tables

Can I have a SQL stored procedure (or some equivalent) that fills multiple tables through a single DataAdapter?  Or do I have to have seperate DataAdapters for every table in my database that I want to retrieve data (and seperate DataAdapater.Fill operations)?
ASKER CERTIFIED SOLUTION
Avatar of gregoryyoung
gregoryyoung
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of eternal_21
eternal_21

ASKER

Thanks gregoryyoung, that looks like it will do what I want.  Can this be used for updating the SQL database as well?
I will post another question to get some more details for that second question later - You have given me enough to get the first part working.

Thanks again,
  - eternal
no problem ... I may be around later to help ya out with the updates ...