ado中SelectCommand的commandstring能不能是多条select语句啊?

Question

可以比如说
  string sql="select * from table1;"+"select * from table2";//注意前一句的";"
  ...
  SqlCommand comm=new SqlCommand();
  comm.commandString=sql;
   ...注意:两个sql语句间用分号隔开
                                                     wish u good luck
                                                           Greatsft

Answer 1

多语句查询
string strConn, strSQL;
strConn = "Provider=SQLOLEDB;Data Source=(local)\\NetSDK;" + 
          "Initial Catalog=Northwind;Trusted_Connection=Yes;";
strSQL = "SELECT CustomerID, CompanyName, ContactName, Phone " +
         "FROM Customers WHERE CustomerID = 'ALFKI'; " +
         "SELECT OrderID, CustomerID, EmployeeID, OrderDate " + 
         "FROM Orders WHERE CustomerID = 'ALFKI'";
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, strConn);
da.TableMappings.Add("Table", "Customers");
da.TableMappings.Add("Table1", "Orders");
DataSet ds = new DataSet();
da.Fill(ds);

Answer 2

to 楼主
  填充数据集时同样可以用多个表比如
   da.Fill(ds,"table1");
   da.Fill(ds,"table2");
 ///////////////////
da即SqlDataAdapter 的对象
ds即DataSet的对象
在上述操作后
   ds.Tables[0]中就是table1
   ds.Tables[1]中就是table2

Answer 3

当然可以了
const string SelectCategoryCustomerQuery = 
"SELECT CategoryID,CategoryName FROM Categories;"+
"SELECT CustomerOD,CompanyName FROM Customers";SqlDataAdapter da= new SqlDataAdapter(SelectCategoryCustomerQuery,myconnect);
DataSet myset = new DataSet();
da.Fill(myset,"Categories");
da.Fill(myset,"Customers");