DataTable OptimalTable = tbl_Optimized_Schedule1.Tables["tbl_Optimized_Schedule"];
DataRow myNewDataRow = OptimalTable.NewRow(); OptimalTable.Rows.Add(myNewDataRow);
我用OptimalTable.Rows.Add(myNewDataRow);将数据插入OptimalTable表中,,然后用下面两句将OptimalTable更新,
OptimalTable.AcceptChanges();
adapter1.Update(OptimalTable);我想问得是,,怎么把OptimalTable 中的数据插入到tbl_Optimized_Schedule的数据库表中。 请指点,,谢谢!
DataRow myNewDataRow = OptimalTable.NewRow(); OptimalTable.Rows.Add(myNewDataRow);
我用OptimalTable.Rows.Add(myNewDataRow);将数据插入OptimalTable表中,,然后用下面两句将OptimalTable更新,
OptimalTable.AcceptChanges();
adapter1.Update(OptimalTable);我想问得是,,怎么把OptimalTable 中的数据插入到tbl_Optimized_Schedule的数据库表中。 请指点,,谢谢!
解决方案 »
- 解析html网页
- 关于 switch 的小小问题。谢谢。
- 图片验证在第一次登陆的时候,明明输入正确,却还提示验证码错误,在第二次输入就没有这个问题了
- 请大家帮忙看看,关于在ASP。NET中使用JavaScript的问题!
- petshop4.0中IDAL层中方法的继承重写的探讨
- MySQL+PHP服务器上能运行asp.net吗?
- 超郁闷的问题!高手请进...
- asp.net 生产安装包后,更新问题。
- duwamish7安装问题
- DropDownList联动的问题(超难度)
- 在程序中创建SQL存储过程的问题?大哥们请来帮帮啊!@#$%^&
- 在ASP.NET中如何实现类似功能,登陆某个页面先验证是否是非法登录??
===========================================
当有一个新的数据行时 DbDataAdapter需要提供正确的insertcommand
SqlCommandBuilder cbUpdate = new SqlCommandBuilder(adapter1);//更新数据库
adapter1.Update(OptimalTable);
//Add your other codeadapter1.InsertCommand=cmdInsert;
adapter1.Update(OptimalTable);
======================
adapter1.insertCommand = new SqlCommand("insert 语句" ,new SqlConnection (strcon ));
this.adapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.conn = new System.Data.OleDb.OleDbConnection();
this.adapter1.InsertCommand = this.OleDbInsertCommand1;
this.OleDbInsertCommand1.CommandText = "INSERT INTO nqry_Optimized_Schedule(PART_NO, SHOP_NO, OP_NO, MACH_NO, LABOR, STAR" +
"T, STOP, DUE_DATE, QTY, DEPT_NO) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.OleDbInsertCommand1.Connection = this.conn;
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("PART_NO", System.Data.OleDb.OleDbType.VarChar, 50, "PART_NO"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("SHOP_NO", System.Data.OleDb.OleDbType.VarChar, 50, "SHOP_NO"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OP_NO", System.Data.OleDb.OleDbType.VarChar, 50, "OP_NO"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("MACH_NO", System.Data.OleDb.OleDbType.VarChar, 50, "MACH_NO"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("LABOR", System.Data.OleDb.OleDbType.VarChar, 50, "LABOR"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("START", System.Data.OleDb.OleDbType.Date, 0, "START"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("STOP", System.Data.OleDb.OleDbType.Date, 0, "STOP"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DUE_DATE", System.Data.OleDb.OleDbType.Date, 0, "DUE_DATE"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("QTY", System.Data.OleDb.OleDbType.Integer, 0, "QTY"));
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DEPT_NO", System.Data.OleDb.OleDbType.SmallInt, 0, "DEPT_NO"));
}
catch (Exception e)
{
Response.Write(e.ToString());
}
this.OleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("PART_NO", System.Data.OleDb.OleDbType.VarChar, 50, "PART_NO"));
"T, STOP, DUE_DATE, QTY, DEPT_NO) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";语法对嘛,values后边是参数名,用“?”不行
这样子后边的this.OleDbInsertCommand1.Parameters.Add添加的是那个参数,程序不知道,肯定要错
DataSet myDataSet;
myDataSet = new DataSet(); // Not shown: methods to fill the DataSet with data.
DataTable t;
t = myDataSet.Tables["Suppliers"]; // Add a DataRow to a table.
DataRow myRow;
myRow = t.NewRow();
myRow["CompanyID"] = "NWTRADECO";
myRow["CompanyName"] = "NortWest Trade Company"; // Add the row.
t.Rows.Add( myRow ); // Calling AcceptChanges on the DataSet causes AcceptChanges to be
// called on all subordinate objects.
myDataSet.AcceptChanges();