I need Help building this query:
This is in C#
string strSQL = "SELECT USERID FROM TBUSERS WHERE USERNAME='" + strReportTo + "'";
OdbcDataReader dr = null;
OdbcCommand myCommand = new OdbcCommand(strSQL, myConnection);
if(dr.Read())
{
Response.Write (dr);
}
myConnection.Close();
I just need to get a userid in odbc.If you can help I would appreciate it!