Link to home
Start Free TrialLog in
Avatar of MadIce
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.
Avatar of RonaldBiemans
RonaldBiemans

Use a dataadapter and a dataset, it will read in all the tables that come from the stored procedure automatically

ASKER CERTIFIED SOLUTION
Avatar of RonaldBiemans
RonaldBiemans

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 MadIce

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