使用多个SQLDataAdapter对象查询与更新数据库数据的优化性能的技巧

 先看个简单的示例：

 

原来查询数据的代码：<佳能复印机>

SqlConnectionStringBuilder ssb = new SqlConnectionStringBuilder(); ssb.DataSource = "."; ssb.InitialCatalog = "Northwind"; ssb.UserID = "sa"; ssb.Password = "********"; SqlConnection cn = new SqlConnection(ssb.ConnectionString); SqlDataAdapter daORDER = new SqlDataAdapter("SELECT ProductID,Quantity,UnitPrice FROM [ORDER dETAiLS]", cn); SqlDataAdapter daCustomer = new SqlDataAdapter("SELECT CustomerID,CompanyName FROM Customers", cn); DataSet ds = new DataSet(); daORDER.Fill(ds,"order"); daCustomer.Fill(ds, "Customers");

 

优化后的代码：<喷墨照片打印机>

SqlConnectionStringBuilder ssb = new SqlConnectionStringBuilder(); ssb.DataSource = "."; ssb.InitialCatalog = "Northwind"; ssb.UserID = "sa"; ssb.Password = "********"; SqlConnection cn = new SqlConnection(ssb.ConnectionString); SqlDataAdapter daORDER = new SqlDataAdapter("SELECT ProductID,Quantity,UnitPrice FROM [ORDER dETAiLS]", cn); SqlDataAdapter daCustomer = new SqlDataAdapter("SELECT CustomerID,CompanyName FROM Customers", cn); DataSet ds = new DataSet(); cn.Open();//使用SqlConnection对象打开数据库连接 daORDER.Fill(ds,"order"); daCustomer.Fill(ds, "Customers"); cn.Close();//使用SqlConnection对象关闭数据库连接

 

如此一来，就能快速地查询与更新数据库里的数据了

 

推荐站点：长宸办公