在数据库中添加字段时动态增加网格视图列. [英] Dynamically Increment grid-view columns when field adding in database.

问题描述

我是Ramesh.

我有类似
的数据库
Eno代码
1次访问
2 Ptp

这是我的桌子.代码插入前端.我将网格视图自动生成的列设置为false.该代码可以正常工作.

当我在数据库列的网格视图中插入新代码时，自动绑定数据.

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.

推荐答案

希望对您有帮助.

Hi ,
Hope it help you .

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

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

最好的问候
M.Mitwalli

Best Regards
M.Mitwalli

查询数据库时，可以在数据表中获取结果.该数据表可以作为您的gridview数据源.因此，gridview将动态接收数据表中的所有列

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

这篇关于在数据库中添加字段时动态增加网格视图列.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！