c# DataTable关联dataGridView创建和修改数据

c# DataTable关联dataGridView1创建修改数据

gridControl1.DataSource = dataTable; //关联DataSource，数据改变自动更新到表格（数据网格视图）

1.  
   DataTable dt2;
2.  
   dt2 = new DataTable();
3.  
   dt2.Columns.Add("姓名",typeof(string));
4.  
   dt2.Columns.Add("工号", typeof(string));
5.  
   dt2.Columns.Add("地址", typeof(string));
6.  
   dt2.Rows.Add(new object[] {"王白","L123","北京" });
7.  
   dt2.Rows.Add(new object[] { "王六", "L456", "首都" });
8.  
   dt2.Rows.Add(new object[] { "王旧", "L987", "大地" });
9.  
    
10.  
    List<string> results = dt2.AsEnumerable().Select(x => x.Field<string>("工号")).ToList();
11.  
     
12.  
     
13.  
    foreach (var i in results)
14.  
    {
15.  
    Console.WriteLine(i);
16.  
    }
17.  
    dataGridView1.DataSource = dt2;
18.  
    Console.WriteLine("dt3 data");
19.  
    DataTable dt3;
20.  
    dt3 = (DataTable)dataGridView1.DataSource;
21.  
    for(int i=0;i<dt3.Columns.Count; i)
22.  
    {
23.  
    Console.Write(dt3.Columns[i] " "); //输出不换行
24.  
    }
25.  
    Console.WriteLine("");
26.  
    //Console.WriteLine("换行");
27.  
     
28.  
     
29.  
    for (int j=0;j<dt3.Rows.Count; j)
30.  
    {
31.  
     
32.  
     
33.  
    // Console.Write(dataRow["姓名"].ToString());
34.  
    }
35.  
    foreach(DataRow dataRow in dt3.Rows)
36.  
    {
37.  
    string aa = dataRow["姓名"].ToString();
38.  
    string aa2 = dataRow["工号"].ToString();
39.  
    string aa3 = dataRow["地址"].ToString();
40.  
    Console.WriteLine(aa " " aa2 " " aa3);
41.  
    }
42.  
    dt3.Rows[0]["姓名"] = "力工";
43.  
    dt3.Rows[0]["工号"] = "M888";
44.  
    dt3.Rows[0]["地址"] = "柳树";
45.  
    Console.WriteLine("");
46.  
    Console.WriteLine("修改第一行数据后");
47.  
    Console.WriteLine("");
48.  
    foreach (DataRow dataRow in dt3.Rows)
49.  
    {
50.  
    string aa = dataRow["姓名"].ToString();
51.  
    string aa2 = dataRow["工号"].ToString();
52.  
    string aa3 = dataRow["地址"].ToString();
53.  
    Console.WriteLine(aa " " aa2 " " aa3);
54.  
    }

这篇好文章是转载于：学新通技术网