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
You must Sign In to post a response.
Category: ASP.NET
How to work with Multiple data set returned from database?
Can anybody workout this for me then do the needful.
Thank you in advance
#767828
what is your requirement ? how you have return multiple dataset ? I doubt you can return multiple dataset in one call, do you have return multiple datatable in single dataset or what ?
Please elaborate your requirement so that we can help you better in order to resolve your issue
Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]
Please elaborate your requirement so that we can help you better in order to resolve your issue
Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]
#767839
Hello,
I was facing the same problem, I also tried to resolve this by myself but unable to do so. However, this company MSP IT Concepts www (dot) mspconcepts (dot) com resolved this for me. They have excellent ASP.NET development team which helped me fix this and many other bugs in my ASP.NET related stuff. you may want to get in touch with brijesh.l at mspconcepts (dot) com I'm sure they would be able to help. They are professionals & quick to provide accurate solution for your web development projects.
Thanks
I was facing the same problem, I also tried to resolve this by myself but unable to do so. However, this company MSP IT Concepts www (dot) mspconcepts (dot) com resolved this for me. They have excellent ASP.NET development team which helped me fix this and many other bugs in my ASP.NET related stuff. you may want to get in touch with brijesh.l at mspconcepts (dot) com I'm sure they would be able to help. They are professionals & quick to provide accurate solution for your web development projects.
Thanks
#767841
Hi,
You want to get multiple tables from database or what?
You have explore it clearly, I suspect that you want to get multiple tables from your database to your DataSet.
If that is your requirement then wrote a StoredProcedure with multiple select queries and then get the data into dataset refer below sample
and now call that procedure in your code side.
now you will get the multiple table result from database to your dataset.
Hope this helps you...
--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.
N@veen
Blog : http://naveens-dotnet.blogspot.in/
You want to get multiple tables from database or what?
You have explore it clearly, I suspect that you want to get multiple tables from your database to your DataSet.
If that is your requirement then wrote a StoredProcedure with multiple select queries and then get the data into dataset refer below sample
create procedure ProcName
As
begin
select * from table1
select * from table2
end
and now call that procedure in your code side.
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);
now you will get the multiple table result from database to your dataset.
Hope this helps you...
--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.
N@veen
Blog : http://naveens-dotnet.blogspot.in/
Return to Return to Discussion Forum
