How to bind all the tables in dataset to a single gridview with expand and collapse for all the six tables in dataset

Question

0.00/5 (No votes)

See more:

I am getting 6 table into my dataset with each table having different different columns that means my first table in dataset has 4 columns second table in dataset has 6 columns third table has 10 columns in this way all the six tables in dataset has different columns i need to bind all those tables to a single gridview in a treeview structure that is first table in dataset with + and - to expand and collapse ,second table in dataset with + and - to expand and collapse,third table in dataset with + and - to expand and collapse,fourth table in dataset with + and - to expand and collapse for all the six tables but i am able to bind only first table in dataset to gridview

private void BindGrid()
       {
            
           DataSet ds = new DataSet();
           DataTable dt = new DataTable();
           ds.ReadXml(Server.MapPath("~/Sample.xml"));
 
           GridView gvEmployee = new GridView();
           gvEmployee.AutoGenerateColumns = false;
 
           if (ds != null && ds.HasChanges())
           {
               dt = ds.Tables[0];
               for (int i = 0; i < dt.Columns.Count; i++)
               {
                   BoundField boundfield = new BoundField();
                   boundfield.DataField = dt.Columns[i].ColumnName.ToString();
                   boundfield.HeaderText = dt.Columns[i].ColumnName.ToString();
                   gvEmployee.Columns.Add(boundfield);
               }
 
               gvEmployee.DataSource = dt;
               gvEmployee.DataBind();
               gvEmployee.Width = 600;
               gvEmployee.HeaderStyle.CssClass = "header";
               gvEmployee.RowStyle.CssClass = "rowstyle";
 
               Panel1.Controls.Add(gvEmployee);
           }
       }

above is my code which creates 6 tables in dataset but only one table is getting binded to gridview at the end but i need to bind all those tables to a gridview with expand and collapse for each table in dataset

What I have tried:

i need to bind all the tables in dataset to a single gridview that means i have 6 tables in my dataset those 6 tables have different different columns all these tables should be binded to single gridview with expand and collapse for those six tables which we are getting in dataset

Posted 23-May-17 4:55am

Member 12324523

Updated 25-May-17 0:23am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bhola Ram Sahu · Answer 1 · 2017-05-25T00:23:00

It is not possible to bind same gridview with multiple tables.

For this purpose, DataRepeater is best idea.

<asp:Repeater ID="Repeater1" runat="server">
        <HeaderTemplate>
             Your Header
        </HeaderTemplate>
        <ItemTemplate>
        <asp:GridView runat="server" ID="grd" AutoGenerateColumns="false">
            <Columns>
                //Your GridView Attributes
            </Columns>
        </asp:GridView>
        </ItemTemplate>
</asp:Repeater>

Use Bootstrap Accodion for Collapse and expand in ItemTemplate and put the Grid in Accordion.

In Repeater data bound event, find the grid control using FindControl method and bind the data to grid view.

GridView grid = e.Item.FindControl("grd") as GridView;
grid.DataSource = dataTable;
grid.DataBind();