How to bind multiple tables to single Gridview?

Why 5 buttons? These tables must be related in some way through primary keys and foreign keys otherwise there is no meaning or purpose to put them all in one gridview. Once you have established the relationship in these table, use the appropriate SQL JOIN[^] to select data from related rows of these table, then use one of these [^] to populate the gridview.

Hi,

ASPX File

<div>
            <asp:Button Text="Table 1" runat="server" ID="btnTable1" OnClick="btnTable1_Click" /><br />
            <asp:Button Text="Table 2" runat="server" ID="btnTable2" OnClick="btnTable2_Click" /><br />
            <asp:Button Text="Table 3" runat="server" ID="btnTable3" OnClick="btnTable3_Click" /><br />
            <asp:Button Text="Table 4" runat="server" ID="btnTable4" OnClick="btnTable4_Click" /><br />
            <asp:Button Text="Table 5" runat="server" ID="btnTable5" OnClick="btnTable5_Click" /><br />

        </div>
        <div>
            <asp:GridView runat="server" ID="gridDisplay" AutoGenerateColumns="true"></asp:GridView>
        </div>

CS File

protected void btnTable1_Click(object sender, EventArgs e)
        {
            DataTable dtTable = new DataTable();

            dtTable = DBHelper.GetDataTable("Table1");

            gridDisplay.DataSource = dtTable;
            gridDisplay.DataBind();

        }

        protected void btnTable2_Click(object sender, EventArgs e)
        {
            DataTable dtTable = new DataTable();

            dtTable = DBHelper.GetDataTable("Table2");

            gridDisplay.DataSource = dtTable;
            gridDisplay.DataBind();

        }

        protected void btnTable3_Click(object sender, EventArgs e)
        {
            DataTable dtTable = new DataTable();

            dtTable = DBHelper.GetDataTable("Table3");

            gridDisplay.DataSource = dtTable;
            gridDisplay.DataBind();

        }

        protected void btnTable3_Click(object sender, EventArgs e)
        {
            DataTable dtTable = new DataTable();

            dtTable = DBHelper.GetDataTable("Table3");

            gridDisplay.DataSource = dtTable;
            gridDisplay.DataBind();

        }

        protected void btnTable4_Click(object sender, EventArgs e)
        {
            DataTable dtTable = new DataTable();

            dtTable = DBHelper.GetDataTable("Table4");

            gridDisplay.DataSource = dtTable;
            gridDisplay.DataBind();

        }

        protected void btnTable5_Click(object sender, EventArgs e)
        {
            DataTable dtTable = new DataTable();

            dtTable = DBHelper.GetDataTable("Table5");

            gridDisplay.DataSource = dtTable;
            gridDisplay.DataBind();

        }

Above code will help you.