The DataReader Object

We can use a DataReader object to read data from a database. A DataReader object is effectively a forward-only collection of records from your data source.

OleDbDataReader dbReader = null;
OleDbCommand cmd = Myconnection.CreateCommand();

cmd.CommandText = "SELECT * FROM familyTree";
dbReader = cmd.ExecuteReader();


while(dbReader.Read())
{
Email = (string)dbReader.GetValue(5);
lb.Items.Add(Email);
}