MadIce
asked on
read stored procedure results into datagrids
I have strored procedures that have multiple select statements. I need to be able to run the store procedure and take the result set and add each to their own datagrid. I wont know how many select statements are in the store procedure until it is ran. What would be the best way to go about this and how? Datareader? DataAdapter? any examples? Thanks in advance.
Use a dataadapter and a dataset, it will read in all the tables that come from the stored procedure automatically
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry it took so long to respond...My server went down and had to fix it before I could try this out. This Should workout. Thanks alot