Link to home
Start Free TrialLog in
Avatar of CipherIS
CipherISFlag for United States of America

asked on

C# Store SPROC data in DataTable

I am calling a sproc which is returning three tables.  How do I store each in a datatable?
ASKER CERTIFIED SOLUTION
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America 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 CipherIS

ASKER

Figured it out

protected DataSet myData = new DataSet();

myAdapter.Fill(myData);
myData.Tables[0].TableName = "T1";
myData.Tables[1].TableName = "T2";

Open in new window

I've requested that this question be closed as follows:

Accepted answer: 0 points for CipherIS's comment #a39574601

for the following reason:

figured it out
This is exactly what my answer aluded to.
CipherIS figured it out 3 hours after ged 325 gave the answer?

ged325 should have the points.
2nd time user is trying to close the question.  Please accept the solution.
Thanks all.