binding database all tables to grid view

Question

hai I want bind gridview  to all my database table name i having database name Authoriz and table name xyz......i want to bind all table names dynamically in run timeto my gridview. iam using c#.net 2008sql 2008 web application pls give c# coding urgent pls....

Mayur Gujrathi · Answer

before doing that do this an d let me know it works or not string sConn = Data Source=(local);Network Library=DBMSSOCN;Initial Catalog=Northwind;User ID=sa;Password=stefan;; string sSQL = select * from table1;select * from table2; DataSet ds = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(sConn CommandType.Text sSQL);

Mayur Gujrathi · Answer

i think you should do like this in dataset there can be more than one table so you can do this i am not sure and also i havnt done this before GridView1.DataSource = ds.Tables(0) GridView1.DataBind() GridView1.DataSource = ds.Tables(1) GridView1.DataBind() GridView1.DataSource = ds.Tables(2) GridView1.DataBind() and make proper arrangement of columns using template fields or as per your need