資料庫有一列是自增列
SqlDataAdapter adapter = new SqlDataAdapter(); //創建配接器
adapter.SelectCommand = new SqlCommand("select * from table_1", connection);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
connection.Open();
DataRow row = testDataSet.Tables["table_1"].NewRow();
row[1] = "老習";
row[2] = "男";
row[3] = 70;
testDataSet.Tables["table_1"].Rows.Add(row);
builder.GetUpdateCommand();
adapter.Update(testDataSet, "table_1");
報錯 row[0] 不能為null
SqlDataAdapter adapter = new SqlDataAdapter(); //創建配接器
adapter.SelectCommand = new SqlCommand("select * from table_1", connection);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
connection.Open();
DataRow row = testDataSet.Tables["table_1"].NewRow();
row[0] = testDataSet.Tables["table_1"].Rows.Count + 1;
row[1] = "老習";
row[2] = "男";
row[3] = 70;
testDataSet.Tables["table_1"].Rows.Add(row);
builder.GetUpdateCommand();
adapter.Update(testDataSet, "table_1"); //這里報錯
System.InvalidOperationException: 對于不回傳任何鍵列資訊的 SelectCommand，不支持 UpdateCommand 的動態 SQL 生成。
uj5u.com熱心網友回復：
在資料庫表中對自增列設定主鍵uj5u.com熱心網友回復：
設定主鍵以后 給row[0] 賦值以后 在adapter.Update(testDataSet,"table_1"); 這里報錯不給row[0]賦值, 報錯: row[0] 值不能為null
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/17969.html
標籤：C#