المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Stored Procedure Question



C# Programming
07-06-2010, 02:40 PM
Create Procedure MultiTable
AsBegin Select Name, Email from A
Select X,Y from B
Select J, K from C
End
When We call this Sp return result set in tables as table, table1, table2.
Can we give these table name what we want?
I mean instead of table, table1 it should give A,B..

SqlConnection conn = new SqlConnection("Con String");
SqlDataAdapter da = new SqlDataAdapter("MultiTable",conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;

DataSet ds = new DataSet();
da.Fill(ds);