Matching a textBox entry to a Primary Key in a DB table

[GaryMazzone]

MY advice (and I know other don't agree) is never use the generated datasets. I allways create my own objects.

But to your point I think

Dim strSQL As String = String.Empty
strSQL &= "Select Pin From ATMCards Where cardNumber = @cardNumber"
now create a connection object.
Create a command Oblect
create a parameter for the command object
parm.AddWithValue(@cardNumber,textbox.text)
execute scaler on the command object.