I need Help building this query:

Question

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!

sathyaselvi_v · Answer

string strSQL = "SELECT USERID FROM TBUSERS WHERE USERNAME='" + strReportTo + "'";
OdbcDataReader dr = null;
OdbcCommand myCommand = new OdbcCommand(strSQL, myConnection);
dr=myCommand.ExecuteReader();
if(dr.Read())
{
Response.Write (dr["USERID"].ToString());
}
myConnection.Close();
Try it, u must get solution