Very Simple SQL Question??
I know this is easy...but I am having some differcultiy with it.
I am tring to get the City ID out of User Table...
I have the SQL string:
strSQL = "SELECT Name, City, Province FROM [User]"
strSQL = strSQL & "WHERE UserID = ' & mUserID & '"
How do I get the city value out this SQL string... Can I say some like, Create a datareader called objDR and set a var equal to objDR(city)??
Thanks In Advance,