Question

OleDbDataReader怎样获得记录总数

Answer 1

您可以通过数据库记录的主键选择所有的记录，然后使用OleDataReader的Read方法，当没有更多的记录时，Read方法会返回False。 public int MyDataNum(string myConnString) { int Count=0; string mySelectQuery = SELECT PrimaryKey FROM DataTable; OleDbConnection myConnection = new OleDbConnection(myConnString); OleDbCommand myCommand = new OleDbCommand(mySelectQuery,myConnection); myConnection.Open(); OleDbDataReader myReader; myReader = myCommand.ExecuteReader(); // Always call Read before accessing data. while (myReader.Read()) {Count++;}// always call Close when done reading. myReader.Close(); // Close the connection when done with it.