how to bind dynamic gridview i.e AutoGenerateColumns=true

Question

i have a sp,which return dyanimic columns name ,and i want bind it in gridview,how please help me as soon as possible

Sachin Singh · Answer

until you specify the column names in GridView explicitly, the GridView is dynamic anyway. So, just call your SP and bind the result to GridView. public void BindGrid() { using (SqlConnection con = new SqlConnection( "Data Source=SACHIN-PC\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True" )) { SqlDataAdapter da = new SqlDataAdapter( "spGetEmployee" , con); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); dataAdapter.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); } Note:- As a best practise, Always stored connection string in config file and retrieve from there // considering your connection string is stored in config file string cs=ConfigurationManager.ConnectionStrings[ "Constr" ].ConnectionString;

Arnab Mukherjee · Answer

Hi, If you have the datatable, simply bind it with gridview. GridView1.DataSource = datatable; GridView1.DataBind();

Sandeep Kumar · Answer

i have datatable ,how to bind it in dynamic gridview

Arnab Mukherjee · Answer

protected void ExecuteButton_Click(object sender, EventArgs e) { SqlDataSource1.SelectCommand = SqlQueryTextBox.Text; GridView1.DataBind(); }

how to bind dynamic gridview i.e AutoGenerateColumns=true

Answers (4)