用怎样在Access用C#顺序读取每条记录，小弟初学，请多多关照阿

Question

public static void ReadData(string connectionString, string queryString)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand(queryString, connection);        connection.Open();
        OleDbDataReader reader = command.ExecuteReader();        while (reader.Read())
        {
            Console.WriteLine(reader[0].ToString());
        }
        reader.Close();
    }
}

Answer 1

Access数据库表里面创建一个ID字段,然后按照ID字段顺序来读取
using System.Data.OleDb;//引用时加上这一句下面是按照ID字段顺序读取:
            string sqlconn="Provider=Microsoft.Jet.OleDb.4.0;Data Source=数据库名.mdb";
            OleDbConnection conn = new OleDbConnection(sqlconn);
            conn.Open();
            OleDbCommand cmd = new OleDbCommand("select * from 表名 order by ID",conn);
            OleDbDataReader  reader = cmd.ExecuteReader(); 
            while (reader.Read()) 
             { 
                 Console.WriteLine(reader[0].ToString()); 
             } 
            reader.Close(); 
            cmd.Dispose();
            conn.Close();
            conn.Dispose();

Answer 2

string   sqlconn="Provider=Microsoft.Jet.OleDb.4.0;Data   Source=数据库名.mdb"; 
                        OleDbConnection   conn   =   new   OleDbConnection(sqlconn); 
                        conn.Open(); 
                        OleDbCommand   cmd   =   new   OleDbCommand("select   *   from   表名   order   by   ID",conn); 
                        OleDbDataReader     reader   =   cmd.ExecuteReader();   
                        while   (reader.Read())   
                          {   
                                  Console.WriteLine(reader[0].ToString());   
                          }   
                        reader.Close();   
                        cmd.Dispose(); 
                        conn.Close(); 
                        conn.Dispose();