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

最新推荐文章于 2019-07-09 17:01:38 发布

weixin_30361641

最新推荐文章于 2019-07-09 17:01:38 发布

阅读量207

点赞数

原文链接：http://www.cnblogs.com/xinxinbb/archive/2008/08/13/1266822.html

版权

用一个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");