谁能帮我把C#代码修改一下

来源：百度知道 编辑：UC知道 时间：2024/05/17 23:36:22
这段代码是Acess数据哭的,我想修改成SQL数据的,谁能帮忙修改一下
//This procedure prepares the query to bind the child GridView
private AccessDataSource ChildDataSource(string strCustometId, string strSort)
{
string strQRY = "";
AccessDataSource dsTemp = new AccessDataSource();
dsTemp.DataFile = "App_Data/Northwind.mdb";
strQRY = "SELECT [Orders].[CustomerID],[Orders].[OrderID]," +
"[Orders].[ShipAddress],[Orders].[Freight],[Orders].[ShipName] FROM [Orders]" +
" WHERE [Orders].[CustomerID] = '" + strCustometId + "'" +
"UNION ALL " +
"SELECT '" + strCustometId + "','','','','' FROM [Orders] WHERE [Orders].[CustomerID] = '" + strCustometId + "'&

private SqlDataSource ChildDataSource(string strCustometId, string strSort)
{
string strQRY = "";

SqlDataSource dsTemp = new SqlDataSource();

con =new SqlConnection("Data Source=.;Initial Catalog=Northwind;User ID=sa;Password=sa")

strQRY = "SELECT [Orders].[CustomerID],[Orders].[OrderID]," +
"[Orders].[ShipAddress],[Orders].[Freight],[Orders].[ShipName] FROM [Orders]" +
" WHERE [Orders].[CustomerID] = '" + strCustometId + "'" +
"UNION ALL " +
"SELECT '" + strCustometId + "','','','','' FROM [Orders] WHERE [Orders].[CustomerID] = '" + strCustometId + "'" +
"HAVING COUNT(*)=0 " + strSort;

dsTemp.SelectCommand = strQRY;

return dsTemp;
}

private AccessDataSource ChildDataSource(string strCustometId, string strSo