Need Help with VB Database: OleDbDataReader

[AluminumHaste]

I'm using the datareader to get an entire row with this Select command:

Dim SelectString As String = "SELECT * FROM CUSTOMERS WHERE FirstName = '" & Me.txtCustFName.Text & "' AND LastName = '" & Me.txtCustLName.Text & "'"

Then doing this:

reader = myCommand.ExecuteReader
reader.Read()

What I need to do is then be able to select each column seperately using colomn names instead of index values.

I've seen ways of doing this like using [column_name] with the reader object to get the value at that column, but I can't find it.

Can anyone help me??

 

[monkeydust]

sValue = reader["event_date"]

 

[AluminumHaste]

Thanks, I figured it out about 1 hour after I posted that. Thanks though.

I you guys )