DataSet手写

 //内存里的数据库            DataSet ds = new DataSet();            DataTable dt = new DataTable("Student");            //创建列            DataColumn dc = new DataColumn();            dc.ColumnName="sId";            dc.AutoIncrement = true;            dc.AutoIncrementSeed = 1;            dc.AutoIncrementStep = 1;            //把列添加到表中            dt.Columns.Add(dc);            dc = new DataColumn();            dc.ColumnName = "sName";            dt.Columns.Add(dc);            dc = new DataColumn();            dc.ColumnName = "sAge";            dt.Columns.Add(dc);            //创建行            DataRow dr = dt.NewRow();            dr["sName"] = "张三";            dr["sAge"] = 18;            dt.Rows.Add(dr);            dr = dt.NewRow();            dr["sName"] = "李四";            dr["sAge"] = 19;            dt.Rows.Add(dr);            dr = dt.NewRow();            dr["sName"] = "王五";            dr["sAge"] = 20;            dt.Rows.Add(dr);            //            ds.Tables.Add(dt);            foreach (DataRow item in ds.Tables[0].Rows)            {                Console.WriteLine(item["sId"]);                Console.WriteLine(item["sName"]);                Console.WriteLine(item["sAge"]);            }