一个DataSet里面有多张DataTable表 一个DataTable里有多个列
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ConfigFile
{
class Program
{
static void Main(string[] args)
{
//获取配置文件
//Console.WriteLine(ConfigurationManager.AppSettings["Version"]);
//Console.WriteLine(ConfigurationManager.AppSettings["SqlConn"]);
//Console.WriteLine(ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString);
//Console.WriteLine(ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString);
//创建一个内存数据集
DataSet da = new DataSet("hello");
DataTable del = new DataTable("dt1");//创建一张内存表
da.Tables.Add(del);
//给表定义列
DataColumn dcName = new DataColumn("Name",typeof(string));
DataColumn dcAge = new DataColumn("Age", typeof(int));
DataColumn dcId = new DataColumn("Id",typeof(int));
//把列放到表中去
del.Columns.AddRange(new DataColumn[] {dcId, dcName,dcAge});
//批量选择 alt+鼠标左击
del.Rows.Add(1, "小李", 18);
del.Rows.Add(2, "李小龙", 18);
del.Rows.Add(3, "赵武", 18);
del.Rows.Add(4, "张三", 18);
//遍历dataset中的表
foreach (DataTable item in da.Tables)
{
//遍历每张表中的列
foreach (DataRow dataRow in item.Rows)
{
Console.WriteLine(dataRow[0]+" "+dataRow[1]+" "+dataRow[2]);
}
}
Console.ReadKey();
}
}
}