Click here to Skip to main content
15,914,642 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi This is Ramesh.

I have database like

Eno Code
1 visit
2 Ptp

this is my table. code is inserted in front end. I am putting the grid-view auto generated columns false. This code is working fine.

When i am inserted new code in database column grid-view automatic bind the data.

how to implement.
Posted

Hi ,
Hope it help you .
C#
protected void Page_Load(object sender, EventArgs e)
  {
      SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=test;Integrated Security=True");
      string statment = "select * from Items ";
      SqlDataAdapter da = new SqlDataAdapter(statment, con);
      DataTable dt = new DataTable();
      da.Fill(dt);
      GridView1.DataSource = dt;
      int ColNumber = dt.Columns.Count;
      for (int i = 0; i < ColNumber; i++)
      {
          BoundField bu = new BoundField();
          string col_name = dt.Columns[i].ColumnName;
          bu.HeaderText = col_name;
          bu.DataField = col_name;
          GridView1.Columns.Add(bu);
      }
      GridView1.DataBind();
  }

ASP.NET
<div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
    </asp:GridView>
</div>

Best Regards
M.Mitwalli
 
Share this answer
 
When query database you can get the result in datatable. This datatable can be made as your gridview datasource. So gridview will dynamically receive all the columns from your datatable
 
Share this answer
 
Comments
Mohamed Mitwalli 2-Apr-12 2:37am    
Hi ,
Your solution will be right if (auto generated columns true) , but he asked auto generated columns false now Grid wont be able to create Columns , you can check my solution
Best Regards
M.Mitwalli

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900