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)??

Please help...

Thanks In Advance,
Mark

Yes,

Or use:

SQLDataAdapter.Fill(objTable) 'DataTable

if (objtable.Rows.Count > 0) then
  'get the value as:
  objtable.Rows(<index>).Item("City").ToString()

  'Or whatever else
end if

Brian

Thanks I have it now.

OK, good.