Displayin two datsets one below the other in a gridview

Question

Hi  Could anyone tell me how to display two datasets one below the other in a gridview. The columns of the two datasets are the same but the values are retrieved using different stored procedures. How do i put the datasource and bind it. Gridv1.DataSource = ds1; Gridv1.DataSource = ds2; Gridv1.DataBind(); It doesnt work. Please help me

Nithz · Answer

I am using VS 2005. See suppose i have datasets as ds1 and ds2 which contains ds1 ds2 Vegetables Cost Fruit COst Carrot 20 Apple 20 Tomato 10 Grapes 10 Then i want my output to be displayed as Carrot 20 Tomato 10 Apple 20 Grapes 10 Please help me as to how it should be done. The two datasets cannot be placed as a single one as my code for one dataset itself contains many tables.

Sreekanth · Answer

R u trying two disply with + or - signs: then there is anned of javasript; if(ur in vs. 2003)

Nithz · Answer

Hi  could you please give me an sample code plz ..it will help me understanding much better .. Thanks in advance

Prashant · Answer

Add the rows of ds1 & then of ds2 in the databound event of gridview.