How to bind Multiple tables to a single GridView?

Kanaparthi Sureshma Reddy

11y1.7k.NET

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 is,the boundfields are different for all tables.

I am using ASP.NET,C# and SQL Server.

Is it possible to bind multiple tables to the Single GridView?If possible please tell me the Solution..

Thanks in advance...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kanaparthi Sureshma Reddy11y ago
Hai Mr.Pankaj Kumar,I 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 Choudhary11y ago

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();           }