Bind a gridview through Multiple dataset's table in asp.net

Posted by Dn2010 under ASP.NET on 2/23/2011 | Points: 10 | Views : 7403 | Status : [Member] | Replies : 5
Hi friends,

I have a grid view in my page..
And in database i have 3 tables for this Gridview.
Then i had use Dataset ..But How can i bind a gridview through Multiple dataset's table. ?

Suppose I have 3 Query :
i) Select Name from tblEmployee
ii) Select Dept from tblDept
iii) select salary from tblsalary

There is no any relation in all these Tables.
Now i want to Bind these all tables into A Single Grid View.....

please give the solution.

thanks.




Responses

Posted by: Karthikanbarasan on: 2/23/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi,

First of all you need to know on which relation you need to show the details in the grid view... then only we can suggest a way to binding ina single grid view

Thanks
Karthik
www.f5Debug.net

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Madhu.b.rokkam on: 2/23/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
When there is no relation between your tables then can you please let us know any specific reason for showing them in single gridview ????



Thanks and Regards
Madhu

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prabhakar on: 2/24/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hi Dn2010 ,

i think without relationship between tables you don't join all tables in one Dataset

Best Regard's
Prabhakar

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: kmk008-12044 on: 9/28/2011 [Member] Starter | Points: 25

Up
0
Down
There are two tables
Expenses table and income table
I want to show those two tables in gridview one by one with footer template seperately for each one(i.e for Grand total for each income and expenses seperately). This is my requirement
Please give me suggestion if there is any possibility.....



Thanks and Regards,
Murali


Murali Krishna

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: kmk008-12044 on: 9/28/2011 [Member] Starter | Points: 25

Up
0
Down
There are two tables
Expenses table and income table
I want to show those two tables in gridview one by one with footer template seperately for each one(i.e for Grand total for each income and expenses seperately). This is my requirement
Please give me suggestion if there is any possibility.....


Thanks and Regards,
Murali

Murali Krishna

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response