I have a S.P. which returns 4 tables in its result set. On my aspx page i have gridview control wherein i need to bind data to the columns from each of these 4 tables. However the problem is i am able to get the columns only in my Table and it cannot find my other columns. How to overcome this issue? If we do use xml how to use it here?
Here is my sample code :
SqlConnection con = new SqlConnection(" xyz");
string str = "exec spname parameter";
SqlDataAdapter da = new SqlDataAdapter(str,con);
DataSet ds = new DataSet();
GridView1.DataSource = ds; // This returns only my Table columns which in incorrect, i need to assign datasource which should contain columns from all the 4 tables.
Thanks in advance!