DataGridView动态生成

 1 DataSet ds = new DataSet();
 2         SqlDataAdapter apter;
 3  private void Form2_Load(object sender, EventArgs e)
 4         {
 5             try
 6             {
 7                 string sql = "SELECT * FROM dbo.UserInfo ";
 8                 apter = new SqlDataAdapter(sql,SQLHelper.con);
 9                 apter.Fill(ds, "UserInfo");
10                 for (int i = 0; i < ds.Tables["UserInfo"].Columns.Count; i++)
11                 {
12                     ColumnHeader ch = new ColumnHeader();
13                     ch.Width = 60;
14                     ch.TextAlign = HorizontalAlignment.Center;
15                     ch.Text = ds.Tables["UserInfo"].Columns[i].ToString();
16                 }
17                 dgvInfo.DataSource = ds.Tables["UserInfo"];
18             }
19             catch (Exception ex)
20             {
21                 
22                 MessageBox.Show(ex.Message);
23             }
24         }
25 就不用再在编辑列,绑定名称和页眉文本了,是不是很省事。。。。。。。。。

 

posted @ 2013-05-27 14:39  宁静思远  阅读(276)  评论(0编辑  收藏  举报