c# 当传递具有新行的 DataRow 集合时，更新要求有效的 InsertCommand
本帖最后由 ygy597441072 于 2013-03-07 13:29:07 编辑

public void DataBaseInSertFromOperateDataSet(string DataTableName, string ValueOfFieldString)
        {
            
            if (this.OleDbCommandString != null && this.ConnectionString != null)
            {
                this._ConnectionString = ConnectionString;
                this._OleDbCommandString = OleDbCommandString;
                MyConnection = new OleDbConnection(_ConnectionString);
                MyDataAdapter = new OleDbDataAdapter(_OleDbCommandString, MyConnection);

                MyDataSet = new DataSet();
                MyDataAdapter.Fill(MyDataSet, DataTableName);
                
                MyDataTable = MyDataSet.Tables[DataTableName];
                string[] ColumnName = new string[MyDataTable.Columns.Count];
                int i = 0;
                foreach (DataColumn Dc in MyDataTable.Columns)
                {
                    ColumnName[i] = Dc.ColumnName;
                    i++;

                }
                string[] ValueOfField = ValueOfFieldString.Split(new char[] { ',' });
                if (ValueOfField.Length != ColumnName.Length)
                {
                    MessageBox.Show("您输入的字段个数与数据库不匹配");

                }
                else
                {
                    for (int j = 0; j < ValueOfField.Length; j++) 
 
                    {
                        DataRow Dr = MyDataTable.NewRow();
                        Dr[j] = ValueOfField[j];
                        MyDataTable.Rows.Add(Dr);
                        
                    }
                }
                
                MyDataAdapter.Update(MyDataSet, DataTableName);

            }
            else
            {
                MessageBox.Show("您没有设置OleDbCommandString和ConnectionString属性", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
    

        }

运行，提示“当传递具有新行的 DataRow 集合时，更新要求有效的 InsertCommand”异常，求助啊
c# dataset
[解决办法]
你没有 InsertCommand用来对新加的row做处理
[解决办法]
MyDataAdapter?.InsertCommand=new 一下，传入相关插入sql语句