random uit tabel access

[savant11]

Hoi allen,

het is de bedoeling dat uit de tabel 'plank' een willekeurig 'plank_nr' eruit haalt en op het scherm laat zien.

heb nu dit:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
//using System.Data.OleDB; 

namespace CustomDataReaders
{
    class Program
    {
        //Random ran = new Random();
        static void Main(string[] args)
        {

           
            //Create a connection
 OleDbConnection m_cnADONewConnection = new OleDbConnection( @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\meetSysteem.mdb");
//open the connection
 m_cnADONewConnection.Open();
//Create a command object.
 OleDbCommand myCommand = m_cnADONewConnection.CreateCommand();
//Specify a query
 myCommand.CommandText = "Select  plank_nr FROM  plank ORDER BY plank_nr";// ORDER BY kast_nr()" ;
//Create a DataReader for the command
OleDbDataReader myDataReader = myCommand.ExecuteReader();
//Display the resulting Data
while (myDataReader.Read())
   {
       Random ran = new Random();
       //Console.WriteLine(ran.Next("kast_nr"));
      // Console.ReadLine();

       //Console.WriteLine("{0}   ", myDataReader["kast_nr"]);
       Console.WriteLine(" plank:{0}   ",((Random)myDataReader["plank_nr"]));
        
   }

 
//Close the DataReader.
myDataReader.Close();
//Close the connection
m_cnADONewConnection.Close();

 
//Keep the console open until a keystroke.
Console.ReadKey(true);

           



        }
    }
}

Alvast enorm bedankt.