如果我们使用EnterpriseLibrary的UpdateDataset()更新数据需要写存储过程或写Insertcommand、Updatecommand和Deletecommand,有点麻烦。我们用EnterpriseLibrary照样可以像SqlDataAdapter一样更新数据,如下:

Code
1 #region 保存单条产品数据
2 public Boolean SetProduct(DataSet dsData, out string ResultMsg)
3 {
4 Boolean result = false;
5 ResultMsg = string.Empty;
6 if (dsData == null)
7 {
8 ResultMsg = "数据集为空";
9 return result;
10 }
11
12 try
13 {
14 SqlCommand cmd = (SqlCommand)db.GetSqlStringCommand("select top 0 * from product");
15 cmd.Connection = (SqlConnection)db.CreateConnection();
16 SqlDataAdapter adapter = (SqlDataAdapter)db.GetDataAdapter();
17 adapter.SelectCommand = cmd;
18 SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
19 int n = adapter.Update(dsData);
20 result = (n > 0);
21 }
22 catch(Exception ex)
23 {
24 throw ex;
25 }
26
27 return result;
28 }
29 #endregion