How to bind Multiple tables to a single GridView?

Question

Hi I have 5 tables in my database and columns are different for each table.I have GridView in my frontend and I want to bind those tables to the GridView by clicking 5 buttons(For each table one buttonclick). Here my problem isthe boundfields are different for all tables. I am using ASP.NETC# and SQL Server. Is it possible to bind multiple tables to the Single GridView?If possible please tell me the Solution.. Thanks in advance...

Kanaparthi Sureshma Reddy · Answer

Hai Mr.Pankaj KumarI am getting error(DBHelper doesn't exist in the current context) while writting DBHelper.. What is DBHelper and why should we write it and where we have to write it? Can you please Tell me..

Pankaj Kumar Choudhary · Answer

hello @Sureshma it is possible you can bind your gridview in such a away 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(); }