how to read the value from a column from a SQL table

I have a SQL table on an MS SQL SERVER 2008 database.
How can I read a row's column value by specifying the column name?
In my code below, I get an error trying to read the value of column "JOB_TABLE_CLIENT_ID".
I want to specify a column and then read the value of that column, in a given row.

' Reads CLIENT_JOBS_TABLE and sets all job_.. globals. Function read_job_record(client_ID, job_ID) Dim query_result As SqlDataReader select_where = "JOB_TABLE_CLIENT_ID = '" + client_ID + "'" + _ " AND JOB_TABLE_ID = '" + job_ID + "'" SQL_command = "SELECT * FROM " + CLIENT_JOBS_TABLE + " WHERE " + select_where successful_SQL_outcome = query_SQL_database(SQL_command, query_result) job_table_client_id = query_result.GetOrdinal("JOB_TABLE_CLIENT_ID") <<<<<<&l ...