本文整理汇总了C#中Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase.LoadDataSet方法的典型用法代码示例。如果您正苦于以下问题：C# SqlDatabase.LoadDataSet方法的具体用法？C# SqlDatabase.LoadDataSet怎么用？C# SqlDatabase.LoadDataSet使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase的用法示例。
在下文中一共展示了SqlDatabase.LoadDataSet方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: UseOfDataSet
public void UseOfDataSet()
{
SqlDatabase sqlDb = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(GetConnectionString());
//IDataReader reader = sqlDb.ExecuteReader(CommandType.Text, "Select * from Syncada.Location");
DbCommand command = new System.Data.SqlClient.SqlCommand();
command.CommandText = "select * from Syncada.Location";
command.CommandType = CommandType.Text;
DataSet locationSet = new DataSet();
sqlDb.LoadDataSet(command, locationSet, "Location");
//var tb = locationSet.Tables[0].AsEnumerable().Select(field => field);
var tb1 = from loc in locationSet.Tables[0].AsEnumerable().Select(field => field) select new { LocationID = loc["LocationID"].ToString(), Street1 = loc["Street1"].ToString() };
foreach (var item in tb1)
{
Console.WriteLine(item.LocationID);
}
}示例2: 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);
}