先看个简单的示例: 原来查询数据的代码:<佳能复印机> 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对象关闭数据库连接 如此一来,就能快速地查询与更新数据库里的数据了 推荐站点:长宸办公