Asp.net: Multiple Dataset
Hello,How to work with Multiple data set returned from database?
Can anybody workout this for me then do the needful.
Thank you in advance
create procedure ProcName
As
begin
select * from table1
select * from table2
end
SqlConnection con=new SqlConnection("your Connectionstring")l;
SqlCommand cmd=new SqlCommand("ProcName", con);
cmd.CommandType=CommandType.StoredProcedure;
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds);