I am calling this sql command from vb.net:
cmd.CommandText = "SELECT * FROM SNUGZ_EXT00101_SOP10200_2 WHERE PT_UD_KEY = '" & strKey & "'"
The sql query will return 1 row with several columns labeled PT_UD_1, PT_UD_2, etc.
I want to put the values in the columns into variables in my vb.net code. For example:
strImprint = PT_UD_1
strImprintColor = PT_UD_2
How do I code my vb.net to do this?