使用微软企业库dll对数据操作

下面是主要代码，对数据进行增加，删除，更新，插入

1. using System;  
2. using System.Collections;  
3. using System.Configuration;  
4. using System.Data;  
5. using System.Linq;  
6. using System.Web;  
7. using System.Web.Security;  
8. using System.Web.UI;  
9. using System.Web.UI.HtmlControls;  
10. using System.Web.UI.WebControls;  
11. using System.Web.UI.WebControls.WebParts;  
12. using System.Xml.Linq;  
13. using System.Data.Common;  
14. using Microsoft.Practices.EnterpriseLibrary.Common;  
15. using Microsoft.Practices.EnterpriseLibrary.Data;  
16. namespace WebSite  
17. {  
18.     public partial class MicrosoftData : System.Web.UI.Page  
19.     {  
20.         protected void Page_Load(object sender, EventArgs e)  
21.         {  
22.  
23.         }  
24.  
25.         protected void btnSure_Click(object sender, EventArgs e)  
26.         {  
27.              
28.             // Create the Database object, using the default database service. The  
29.              //default database service is determined through configuration.  
30.             Database db = DatabaseFactory.CreateDatabase();  
31.  
32.             DataSet productsDataSet = new DataSet();  
33.  
34.             string sqlCommand = "Select * " +  
35.                 "From Users";  
36.             DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);  
37.  
38.             string productsTable = "Users";  
39.  
40.             // Retrieve the initial data  
41.             db.LoadDataSet(dbCommand, productsDataSet, productsTable);  
42.  
43.             // Get the table that will be modified  
44.             DataTable table = productsDataSet.Tables[productsTable];  
45.             GridView1.DataSource = table;  
46.             GridView1.DataBind();  
47.               
48.  
49.             // Establish our Insert, Delete, and Update commands  
50.             DbCommand insertCommand = db.GetStoredProcCommand("addUsers");  
51.  
52.             db.AddInParameter(insertCommand, "UserName", DbType.String, "f");  
53.             db.AddInParameter(insertCommand, "Password", DbType.String, "f");  
54.             db.ExecuteNonQuery(insertCommand);  
55.             DbCommand update = db.GetSqlStringCommand("update users set userName=@userName,password=@password where userID=@userID");  
56.             db.AddInParameter(update, "UserName", DbType.String, "fA");  
57.             db.AddInParameter(update, "Password", DbType.String, "fA");  
58.             db.AddInParameter(update, "UserID", DbType.Int32, 1053664);  
59.             db.ExecuteNonQuery(update);  
60.             DbCommand deleteCommand = db.GetStoredProcCommand("DeleteProduct");  
61.             db.AddInParameter(deleteCommand, "ProductID", DbType.Int32, "ProductID", DataRowVersion.Current);  
62.  
63.             //DbCommand updateCommand = db.GetStoredProcCommand("UpdateProduct");  
64.             //db.AddInParameter(updateCommand, "ProductID", DbType.Int32, "ProductID", DataRowVersion.Current);  
65.             //db.AddInParameter(updateCommand, "ProductName", DbType.String, "ProductName", DataRowVersion.Current);  
66.             //db.AddInParameter(updateCommand, "LastUpdate", DbType.DateTime, "LastUpdate", DataRowVersion.Current);  
67.  
68.             //// Submit the DataSet, capturing the number of rows that were affected  
69.             //int rowsAffected = db.UpdateDataSet(productsDataSet, "Products", insertCommand, updateCommand,  
70.             //                                    deleteCommand, UpdateBehavior.Standard);  
71.  
72.         
73.  
74.           
75.         }  
76.     }  
77. }