ADO.NET

Like this pattern you can use data reader with it .

private static OleDbDataReader olereader ;

oleconnection = new OleDbConnection(sConnection);

olecommand1 = new OleDbCommand("Select * from execution",oleconnection);

oleconnection.Open();

//olereader = new OleDbDataReader();

olereader = olecommand1.ExecuteReader();

while(olereader.Read())

Console.WriteLine("\t{0}\t{1}\t{2}", olereader.GetString(0), olereader.GetName (1),olereader.FieldCount);

olereader.Close();

oleconnection.Close();

Console.ReadLine();

Hopefully you will have an idea for Retrieving data from datareader .

Will u please explain with an example of how to open/close a DataReader

To read Data from datareader try while loop and read data from datareader using dtreader.read() to close data reader use dtreader.close()