datatable与dataview的转换（笔记）

原创于 2024-11-24 17:53:39 发布 · 443 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#笔记 #java #开发语言

DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int)); System.Type.GetType("System.Int32");
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Age", typeof(int));
dt.Columns.Add("Address", typeof(string));
{
DataRow dr = dt.NewRow();
dr["Id"] = 1;
dr["Name"] = "张三";
dr["Age"] = "13";
dr["Address"] = "杭州";
dt.Rows.Add(dr);
}
{
DataRow dr = dt.NewRow();
dr["Id"] = 2;
dr["Name"] = "李四";
dr["Age"] = "20";
dr["Address"] = "杭州";
dt.Rows.Add(dr);
}
{
DataRow dr = dt.NewRow();
dr["Id"] = 3;
dr["Name"] = "王五";
dr["Age"] = "60";
dr["Address"] = "杭州";
dt.Rows.Add(dr);
}

{
DataRow dr = dt.NewRow();
dr["Id"] = 4;
dr["Name"] = "赵六1";
dr["Age"] = "37";
dr["Address"] = "杭州";
dt.Rows.Add(dr);
}
//dataTable 转dataView的集中方式
//DataView dv1 = new DataView(dt);
//DataView dv1 = dt.AsDataView();
//DataView dv1 = new DataView(); dv1.Table = dt;
DataView dv = dt.DefaultView;