How to bind multiple resultset to a Gridview ? [Resolved]

Hello!

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[0] and it cannot find my other columns. How to overcome this issue? If we do use xml how to use it here?

Please suggest.

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();
           da.Fill(ds);
           GridView1.DataSource = ds;        // This returns only my Table[0] columns which in incorrect, i need to assign datasource which should contain columns from all the 4 tables.
           GridView1.DataBind();

Thanks in advance!
Rohan Laghate

Best Regards,
Rohan Laghate [Resolved]