随机读取Access数据库记录(转）

Random rnd =   new  Random(unchecked(( int )DateTime.Now.Ticks));
     int  intRandomNumber  =  rnd.Next();
    string ConnectionString  =  @ " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|aspxWeb.mdb;Persist Security Info=True " ;
    string sql  =   " select top 10 Title,objectGuid from Document  Order By  Rnd( "   +  ( - 1   *  intRandomNumber)  +   " *id) " ;
    System.Data.OleDb.OleDbConnection cn  =   new  System.Data.OleDb.OleDbConnection(ConnectionString);
    cn.Open();
    System.Data.OleDb.OleDbCommand cmd  =   new  System.Data.OleDb.OleDbCommand(sql, cn);
    System.Data.OleDb.OleDbDataReader dr  =  cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
    GridView1.DataSource  =  dr;
    GridView1.DataBind();
    dr.Close();
    cmd.Dispose();
    cn.Dispose();
    cn  =   null ;