locked
String.Concate failed in dot net 3.5 Class Library project RRS feed

  • Question

  • My query string in Data Access Layer

    commandText = "SELECT * FROM Users WHERE USERNAME='" & USERNAME & "' AND PASSWORD='" & PASSWORD & "'"

     

    It Gives result as

    commandText = SELECT * FROM WRM_MACHINEMASTER WHERE DELETED=0 AND USERNAME='jignesh

     

    commandText Means whenever it finds single quotes " ' " it stops manipulating string concatination.

     

    Please! i am stuck at this since long, even I uninstalled VS, then try with SP1 also, but problem is same.

     

    Is there anybody to help me...????

     

    Its in Visual Basic (means not a problem of escape characters)

    Wednesday, August 20, 2008 5:35 AM

Answers