Compare value from database

[yaminilathatv]

Hi everyone I am trying to compare userid i.e, if the user exists I want to display the message.I am getting error when comparing the text in the textbox and the text from the database.Please tell me how to convert the value into string. the code is as follows... cmd.commandtext="select user from reg" da.selectcommand=cmd da.fill(ds,"reg") for each dr in ds.tables("reg").rows If textbox1.text=dr.item(0) then msgbox("UserExists") endif next thanxin advance yamini

[Muhammad Javed Khan]

may be "user" field have null values thats y it will be giving error Try this: cmd.commandtext="select user from reg" da.selectcommand=cmd da.fill(ds,"reg") for each dr in ds.tables("reg").rows If textbox1.text= (dr.item(0) & "") then msgbox("UserExists") endif next

[Guffa]

The data you get from dr.item(0) is of the type Object. That means that you are comparing the values as objects, not strings, and as they are not the same object, the expression never will be true. Convert the object to a string: If textbox1.text = dr.item(0).ToString() then --- b { font-weight: normal; }