用一个DataAdapter向一个Dataset Fill多个表

用一个DataAdapter向一个Dataset Fill多个表

1
DataSet ds = new DataSet();
SqlDataAdapter mySqlAdapter = new SqlDataAdapter();

mySqlAdapter.SelectCommand = new SqlCommand();
mySqlAdapter.SelectCommand.Connection = conn;

strSql = "select * from table1";
mySqlAdapter.SelectCommand.CommandText =strSql ;
mySqlAdapter.Fill(ds,"table1");
strSql = "select * from table2";
mySqlAdapter.SelectCommand.CommandText =strSql
mySqlAdapter.Fill(ds,"table2");
----------------------------------------------------------------------------------------------
2
DataSet ds = new DataSet();

strSql = "select * from table1";
mySqlAdapter = new SqlDataAdapter(strSQL,strSqlConn);
mySqlAdapter.Fill(ds,"table1");

strSql = "select * from table2";
mySqlAdapter = new SqlDataAdapter(strSQL,strSqlConn);
mySqlAdapter.Fill(ds,"table2");