DataSet pgsmDataSet = new DataSet();
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=pgsm.mdb;";
//string sqlConnection = "Select * FROM member";
System.Data.OleDb.OleDbConnection oleDbConnection = new System.Data.OleDb.OleDbConnection(connection); System.Data.OleDb.OleDbDataAdapter oleDataAdapter = new System.Data.OleDb.OleDbDataAdapter(); oleDbConnection.Open();
oleDataAdapter.Fill(pgsmDataSet);/////////////
我想用pgsmDataSet 来代替我连接的一个数据库 PGSM
数据库里面就一张表 memeber
想实现下面语句,结果不行
int a = pgsmDataSet.Tables["member"].Rows.Count - 1;
string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=pgsm.mdb;";
//string sqlConnection = "Select * FROM member";
System.Data.OleDb.OleDbConnection oleDbConnection = new System.Data.OleDb.OleDbConnection(connection); System.Data.OleDb.OleDbDataAdapter oleDataAdapter = new System.Data.OleDb.OleDbDataAdapter(); oleDbConnection.Open();
oleDataAdapter.Fill(pgsmDataSet);/////////////
我想用pgsmDataSet 来代替我连接的一个数据库 PGSM
数据库里面就一张表 memeber
想实现下面语句,结果不行
int a = pgsmDataSet.Tables["member"].Rows.Count - 1;
--->
oleDataAdapter.Fill(pgsmDataSet, "member");你要指定填充的表名,但要注意,这个表名与数据库里的member表没有关系,可以任意指定,比如
oleDataAdapter.Fill(pgsmDataSet, "mytest");
那么使用时
int a = pgsmDataSet.Tables["mytest"].Rows.Count - 1;
改下
oleDataAdapter.Fill(pgsmDataSet,"member");
--->
System.Data.OleDb.OleDbDataAdapter oleDataAdapter = new System.Data.OleDb.OleDbDataAdapter("Select * FROM member",oleDbConnection);
得出来的是什么?