public int UpdateUserList(DataSet UserList)
{
}传入一个ds怎样实现更新数据库啊
这是填充datagridview的数据集,修改后,怎样再更新回去啊
public DataSet GetUserList()
{
Database db = DatabaseFactory.CreateDatabase("WLSqlConnection");
string sqlCommand = "select * from 操作员表";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
DataSet czyDataSet = null;
czyDataSet = db.ExecuteDataSet(dbCommand);
return czyDataSet; }
{
}传入一个ds怎样实现更新数据库啊
这是填充datagridview的数据集,修改后,怎样再更新回去啊
public DataSet GetUserList()
{
Database db = DatabaseFactory.CreateDatabase("WLSqlConnection");
string sqlCommand = "select * from 操作员表";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
DataSet czyDataSet = null;
czyDataSet = db.ExecuteDataSet(dbCommand);
return czyDataSet; }
DataAdapter.Update 方法
从名为“Table”的 DataTable 为指定的 DataSet 中每个已插入、已更新或已删除的行调用相应的 INSERT、UPDATE 或 DELETE 语句。
MSDN例子
[C#]
public DataSet CreateCmdsAndUpdate(DataSet myDataSet,string myConnection,string mySelectQuery,string myTableName)
{
OleDbConnection myConn = new OleDbConnection(myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter); myConn.Open(); DataSet custDS = new DataSet();
myDataAdapter.Fill(custDS); //code to modify data in dataset here //Without the OleDbCommandBuilder this line would fail
myDataAdapter.Update(custDS); myConn.Close(); return custDS;
}