DataSet手写

最新推荐文章于 2024-01-08 15:20:55 发布

转载最新推荐文章于 2024-01-08 15:20:55 发布 · 476 阅读

随笔专栏收录该内容

9 篇文章

订阅专栏

 //内存里的数据库
            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"]);
            }