Database.UpdateDataSet

刚开始时尝试用以下代码来更新DataSet：

Database db = DatabaseFactory.CreateDatabase();

string strSql = "Select ProductID, ProductName, CategoryID, UnitPrice, LastUpdate From Products";
DbCommand command = db.GetSqlStringCommand(strSql);
DataSet ds = db.ExecuteDataSet(command);


DbCommand insertCommand = db.GetStoredProcCommand("AddProduct");
db.AddInParameter(insertCommand, "ProductName", DbType.String, DataRowVersion.Current);
db.AddInParameter(insertCommand, "CategoryID", DbType.Int32, DataRowVersion.Current);
db.AddInParameter(insertCommand, "UnitPrice", DbType.Currency, DataRowVersion.Current);

DbCommand deleteCommand = db.GetStoredProcCommand("DeleteProduct");
db.AddInParameter(deleteCommand, "ProductID", DbType.Int32, DataRowVersion.Current);

DbCommand updateCommand = db.GetStoredProcCommand("UpdateProduct");
db.AddInParameter(updateCommand, "ProductID", DbType.Int32, DataRowVersion.Current);
db.AddInParameter(updateCommand, "ProductName", DbType.String, DataRowVersion.Current);
db.AddInParameter(updateCommand, "LastUpdate", DbType.DateTime, DataRowVersion.Current);

ds.Tables[0].Rows.Add(new object[] { DBNull.Value, "Added from program", 13, 26 });
db.UpdateDataSet(ds, ds.Tables[0].TableName, insertCommand, updateCommand, deleteCommand, UpdateBehavior.Standard);

但是失败了，后来仔细比较QuickStart中的代码后才发现应该使用Database.AddInParameter(DbCommand command,string name,DbType dbType,string sourceColumn,object value)这个方法，查了一下帮助文档，对比如下：

1.public void AddInParameter(DbCommand command,string name,DbType dbType,object value)
Parameter
  command:The command to add the parameter;
  name:The name of the parameter;
  dbType:One of the DbType values;
  values:The value of the parameter;

2.public void AddInParameter(DbCommand command,string name,DbType dbType,string sourceColumn,object value)
Parameter
  command:The command to add the parameter;
  name:The name of the parameter;
  dbType:One of the DbType values;
  sourceColumn:The name of the source column mapped to the DataSet and used for loading or returning the value;
  values:The value of the parameter;