Does the OleDbDataReader contain actual record information?

[Steve1 via DotNetMonster.com]

Hi all,

I''ve created an OleDbDataReader that will contain the number of records that
the used SQL query will return. I'm then using a while loop to loop while
the OleDBDataReader object has records. I would like to know does the
OleDbDataReader contain the actual information on each record i.e. the fields
in the database and their values? Or does the ExecuteReader command only
contain the number of records present from the used SQL query and no more?
Or am I going the completely wrong way about it??

I need to use the 'Name' field's value of the current OleDbDataReader record
in a following (not present in code snippit) code block. I using an Access
2000 database. Thanks in advance, Steve.

OleDbDataReader obj_ReaderLayou tsPound = obj_SQLLayoutsP ound.ExecuteRea der();
while( obj_ReaderLayou tsPound.Read())
{
// Is there a property of the OleDbDataReader that will contain the
information of each record?
string str_CurrentReco rd = obj_ReaderLayou tsPound.ToStrin g();
}
--
Message posted via DotNetMonster.c om
http://www.dotnetmonster.com/Uwe/For...sharp/200509/1