Asp.net: Multiple DatasetHello,
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
select * from table1
select * from table2
SqlConnection con=new SqlConnection("your Connectionstring")l;
SqlCommand cmd=new SqlCommand("ProcName", con);
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();