AluminumHaste
Active member
I'm using the datareader to get an entire row with this Select command:
Then doing this:
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??
Code:
Dim SelectString As String = "SELECT * FROM CUSTOMERS WHERE FirstName = '" & Me.txtCustFName.Text & "' AND LastName = '" & Me.txtCustLName.Text & "'"
Then doing this:
Code:
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??