怎样将newRow更新到服务器端,代码如下: SqlDataAdapter dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = conn.CreateCommand();
dataAdapter.SelectCommand.CommandText = "SELECT * FROM tbl_In_asnmaster";
// 建立 DataSet
DataSet dataSet = new DataSet(); // 用 DataAdapter 填充 DataSet
dataAdapter.Fill(dataSet,"tbl_In_asnmaster"); // Get object reference of the first Row for simplified use
DataTable dataTable = dataSet.Tables[0]; // Add a row by Creating a new DataRow
DataRow newRow = dataTable.NewRow();
newRow["AsnSysNbr"] = textBox1.Text;
dataTable.Rows.Add(newRow);运行后老是只在客户端这边添加了,数据库服务器上没有新记录添加,请问怎么才能真正提交上去呢。
如果再增加一条dataAdapter.Update(dataSet);就会报错“Update requires a valid InsertCommand when passed DataRow...”先谢过了
dataAdapter.SelectCommand = conn.CreateCommand();
dataAdapter.SelectCommand.CommandText = "SELECT * FROM tbl_In_asnmaster";
// 建立 DataSet
DataSet dataSet = new DataSet(); // 用 DataAdapter 填充 DataSet
dataAdapter.Fill(dataSet,"tbl_In_asnmaster"); // Get object reference of the first Row for simplified use
DataTable dataTable = dataSet.Tables[0]; // Add a row by Creating a new DataRow
DataRow newRow = dataTable.NewRow();
newRow["AsnSysNbr"] = textBox1.Text;
dataTable.Rows.Add(newRow);运行后老是只在客户端这边添加了,数据库服务器上没有新记录添加,请问怎么才能真正提交上去呢。
如果再增加一条dataAdapter.Update(dataSet);就会报错“Update requires a valid InsertCommand when passed DataRow...”先谢过了
SqlCommandBuilder sb = new SqlCommandBuilder(dataAdapter);