用两个DataAdapter啊
DataAdapter dAt1=new SqlDataAdapter
DataAdapter dAt2=new SqlDataAdapter
dAt1=new SqlDataAdapter("select * from table1",Sqlconnection1)
dAt2=new SqlDataAdapter("select * from table1",Sqlconnection1)
dAt1.Fll(Ds,"Table1")
dAt1.Fill(Ds,"Table2")
这样就可以在一个数据集里填充两个表了.
DataAdapter dAt1=new SqlDataAdapter
DataAdapter dAt2=new SqlDataAdapter
dAt1=new SqlDataAdapter("select * from table1",Sqlconnection1)
dAt2=new SqlDataAdapter("select * from table1",Sqlconnection1)
dAt1.Fll(Ds,"Table1")
dAt1.Fill(Ds,"Table2")
这样就可以在一个数据集里填充两个表了.
string aaa="select * from table1;select * from table2";
DataAdapter dAt1=new SqlDataAdapter
dAt1=new SqlDataAdapter(aaa,Sqlconnection1)
dAt1.Fll(Ds)
第一表為ds.Tables[0]
第二表為ds.Tables[1]
string aaa="select * from table1;select * from table2";
DataAdapter dAt1=new SqlDataAdapter(aaa,Sqlconnection1);
dAt1.Fll(Ds)
第一表為ds.Tables[0]
第二表為ds.Tables[1]