Loading

I need to get the values of USERID and put it in a string.

mathieusgirl2002

22y2.6k.NET

string strSQL = "SELECT USERID FROM TBUSERS WHERE USERNAME='" + strReportTo + "'"; OdbcCommand myCommand = new OdbcCommand(strSQL, myConnection); myConnection.Close();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

ganesh.ha22y ago
I think aarti is right. Regarding closing the odbc connection, you can close it immediately after "executeReader()"
0
aartikaur22y ago
hi there, if I am getting it right then you want to store the value of uderid that you are getting from the database into string. I hope the code snippet below answers your question Add these lines of code to ur existing code. SqlDataReader myReader= myCommand.ExecuteReader(); while(myReader.Read()) { string uid = myReader.GetString(0); } And one more thing maybe you should try closing the connection after this insead of closint it before,but i am not very sure.
0