本文整理汇总了C#中Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase.UpdateDataSet方法的典型用法代码示例。如果您正苦于以下问题：C# SqlDatabase.UpdateDataSet方法的具体用法？C# SqlDatabase.UpdateDataSet怎么用？C# SqlDatabase.UpdateDataSet使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase的用法示例。
在下文中一共展示了SqlDatabase.UpdateDataSet方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: UpdateUsingDataSet
private static void UpdateUsingDataSet(SqlDatabase database)
{
var productsDataSet = new DataSet();
var cmd = database.GetSqlStringCommand("Select ProductID, ProductName, CategoryID, UnitPrice, LastUpdate From Products");
// Retrieve the initial data.
database.LoadDataSet(cmd, productsDataSet, "Products");
// Get the table that will be modified.
var productsTable = productsDataSet.Tables["Products"];
// Add a new product to existing DataSet.
productsTable.Rows.Add(new object[] { DBNull.Value, "New product", 11, 25 });
// Modify an existing product.
productsTable.Rows[0]["ProductName"] = "Modified product";
// Establish the Insert, Delete, and Update commands.
var insertCommand = database.GetStoredProcCommand("AddProduct");
database.AddInParameter(insertCommand, "ProductName", DbType.String, "ProductName", DataRowVersion.Current);
database.AddInParameter(insertCommand, "CategoryID", DbType.Int32, "CategoryID", DataRowVersion.Current);
database.AddInParameter(insertCommand, "UnitPrice", DbType.Currency, "UnitPrice", DataRowVersion.Current);
var deleteCommand = database.GetStoredProcCommand("DeleteProduct");
database.AddInParameter(deleteCommand, "ProductID", DbType.Int32, "ProductID", DataRowVersion.Current);
var updateCommand = database.GetStoredProcCommand("UpdateProduct");
database.AddInParameter(updateCommand, "ProductID", DbType.Int32, "ProductID", DataRowVersion.Current);
database.AddInParameter(updateCommand, "ProductName", DbType.String, "ProductName", DataRowVersion.Current);
database.AddInParameter(updateCommand, "LastUpdate", DbType.DateTime, "LastUpdate", DataRowVersion.Current);
// Submit the DataSet, capturing the number of rows that were affected.
var rowsAffected = database.UpdateDataSet(productsDataSet, "Products", insertCommand, updateCommand, deleteCommand,
UpdateBehavior.Standard);
}