新建DataSet和DataTable，并从中提取数据到文本

来源：互联网发布：肇庆市网络问政编辑：程序博客网时间：2024/05/19 19:44

DataTable dt = new DataTable();DataRow dr;dt.Columns.Add(new DataColumn("整数值 ", typeof(Int32)));dt.Columns.Add(new DataColumn("字符串值 ", typeof(string)));dt.Columns.Add(new DataColumn("日期时间值 ", typeof(DateTime)));dt.Columns.Add(new DataColumn("布尔值 ", typeof(bool)));for (int i = 1; i <= 9; i++){dr = dt.NewRow();dr[0] = i;dr[1] = "项" + i.ToString();dr[2] = DateTime.Now;dr[3] = (i % 2 != 0) ? true : false;dt.Rows.Add(dr);}DataTable dt2 = new DataTable();dt2.Columns.Add(new DataColumn("整数值 ", typeof(Int32)));dt2.Columns.Add(new DataColumn("字符串值 ", typeof(string)));dt2.Columns.Add(new DataColumn("日期时间值 ", typeof(DateTime)));dt2.Columns.Add(new DataColumn("布尔值 ", typeof(bool)));for (int i = 1; i <= 9; i++){dr = dt2.NewRow();dr[0] = i;dr[1] = "项" + i.ToString();dr[2] = DateTime.Now;dr[3] = (i % 2 != 0) ? true : false;dt2.Rows.Add(dr);}DataSet ds = new DataSet();ds.Tables.Add(dt);ds.Tables.Add(dt2);foreach (DataTable datatable in ds.Tables)  {foreach (DataRow datarow in dt.Rows)   {foreach (DataColumn datacolumn in dt.Columns)   {writer.WriteLine("D:\\_DataSet.txt", datatable.TableName + " " + datacolumn.ColumnName + " " + datarow[datacolumn]); // 表名+列名+内容}}}

阅读全文

0 0