C# 给GRIDVIEW增加行（虚拟table建立）

//给GridView增加一行
            DataTable dt = new DataTable();

            dt.Columns.Add("OA_INSTRUMENT_NAME_ID");
            dt.Columns.Add("NAME");
            DataRow dr = dt.NewRow();
            dr["OA_INSTRUMENT_NAME_ID"] = "111";
            dr["NAME"] = "1name";
            dt.Rows.Add(dr); dr = dt.NewRow();
            dr["OA_INSTRUMENT_NAME_ID"] = "22";
            dr["NAME"] = "2name";
            dt.Rows.Add(dr);

            //this.gridView.DataSource = dt;
            //this.gridView.DataBind();
            this.gridOA_INSTRUMENT_NAME.DataSource = dt;
            dt.Dispose();

 

 

在不改变数据源的情况下之方法：

this.gridView.AddNewRow();
            DataRowView aDataRowView = this.bindingSource.Current as DataRowView;
            if (aDataRowView == null)
                return;

            aDataRowView["OA_INSTRUMENT_NAME_ID"] = 11;

            this.bindingSource.CurrencyManager.EndCurrentEdit();
            this.gridView.RefreshData();

 

控制数据类型示例：

方法一、dt.Columns["ISEXIT"].DataType = System.Type.GetType("System.Decimal");

方法二、DataTable dwxz = new DataTable();
            DataColumn col = new DataColumn("id", typeof(Int32));
            dwxz.Columns.Add(col);
            col = new DataColumn("dwxz", typeof(string));
            dwxz.Columns.Add(col);
            DataRow row = null;

 

 

自定义DataSet（含字段类型、长度、约束等）：

 //创建数据库
            DataSet G2T22 = new DataSet("G2T22");
            //创建表
            DataTable stus = new DataTable("stus");
            //创建列

            DataColumn id = new DataColumn("id",typeof(int));
            //自动增长类型
            id.AutoIncrement = true;
            //标识增长1，2
            id.AutoIncrementSeed = 1;
            id.AutoIncrementStep = 2;
            //不允许为空
            id.AllowDBNull = false;

            DataColumn stuId = new DataColumn("stuId",typeof(string));
            //长度为6
            stuId.MaxLength = 6;
            //不允许为空
            stuId.AllowDBNull = false;
            //设置主键
            stus.PrimaryKey = new DataColumn[]
            {
                stus.Columns["stuId"]
            };

            DataColumn stuName = new DataColumn("stuName", typeof(string));
            //长度为20
            stuName.MaxLength = 20;
            //不允许为空
            stuName.AllowDBNull = false;

            DataColumn stuPwd = new DataColumn("stuPwd", typeof(string));
            //长度为20
            stuPwd.MaxLength = 20;
            //不允许为空
            stuPwd.AllowDBNull = false;

            DataColumn stuSex = new DataColumn("stuSex", typeof(string));
            stuSex.DefaultValue = "男";

            DataColumn stuPhone = new DataColumn("stuPhone", typeof(string));
            //长度为11
            stuPhone.MaxLength = 11;
            //不允许为空
            stuPhone.AllowDBNull = false;

            DataColumn stuAddress = new DataColumn("stuAddress", typeof(string));
            stuAddress.DefaultValue = "地址不详细";

            //列添加完成
            stus.Columns.AddRange(new DataColumn[]{id,stuId,stuName,stuPwd,stuSex,stuPhone,stuAddress});

            //添加行，既数据
            DataRow dr = stus.NewRow();
            dr[1] = "1001";
            dr[2] = "高兰";
            dr[3] = "123456";
            dr[4] = "女";
            dr[5] = "13900293912";
            dr[6] = "湖北宜昌";
            //添加行到数据库
            stus.Rows.Add(dr);

            //将DataTable添加到DataSet中
            G2T22.Tables.Add(stus);