表格增删查改

 

 DataTable table1 = new DataTable();
        DataColumn dc1 = new DataColumn("id",Type.GetType("System.Int32"));

        dc1.AutoIncrement = true;//自动增长列
        dc1.AutoIncrementSeed = 10000;//从10000开始增长
        dc1.AutoIncrementStep = 1;//每次自动长1

        table1.Columns.Add(dc1);
        //两种写法
        DataColumn dc2 = new DataColumn();

        dc2.AllowDBNull = false;//这列不能为空
        dc2.MaxLength = 10;//最大长度
        dc2.Unique = true;//name列数据不能重复
       
        dc2.ColumnName = "name";
        dc2.DataType=typeof(string);
        table1.Columns.Add(dc2);

        table1.PrimaryKey = new DataColumn[] { dc1};//表的主键是id列

        DataTable table2 = table1.Clone();//克隆表结构
        DataTable table3 = table1.Copy();//完整拷贝，包括表结构和数据

        Response.Write(table1.Columns.Count.ToString());//取出列
        Response.Write("<br/>"+table1.Columns["id"].ColumnName+";"+ table1.Columns[0].DataType.ToString());//取出第一列名称
        Response.Write("<br/>" + table1.Columns[1].ColumnName + ";" + table1.Columns[1].DataType.ToString());//取出第二列名称
        //------------------------------------------------------------------------------------------------------------------------
        DataRow row = table1.NewRow();//根据当前table1的表结构，生产行
        row["name"] = "张三";//
        table1.Rows.Add(row);//把这行添加到表里面去

        DataRow row1 = table1.NewRow();//根据当前table1的表结构，生产行
        row1["name"] = "李四";//
        table1.Rows.Add(row1);//把这行添加到表里面去

        object[] objs = new object[] { null, "王五" };//另一种装载数据行的方法
        table1.LoadDataRow(objs, true);
           
        //this.GridView1.DataSource = table1;//用gridview显示一下数据
        //this.GridView1.DataBind();//绑定        DataRow row = table1.NewRow();//根据当前table1的表结构，生产行

        //table1.Rows[1]["name"] = "关羽";

        //table1.Rows[2].Delete();//逻辑删除王五行
        //table1.Rows.RemoveAt(2);//物理删除王五行
        //table1.Clear();//清楚表数据
        //this.GridView1.DataSource = table1;
        //this.GridView1.DataBind();
        //-----------------------------------------------------------------------------------------------
        table1.Rows[1]["name"] = "关羽";
        Response.Write("<br/>"+table1.Rows[0].RowState.ToString());
        table1.AcceptChanges();
        Response.Write("br/"+table1.Rows[0].RowState.ToString());//表的状态
        table1.Rows[0].Delete();
        table1.RejectChanges();//回滚这个更改
        this.GridView1.DataSource = table1;//用gridview显示一下数据
        this.GridView1.DataBind();//绑定