Printable View
In a system we're developing admin users can add users to the system. So i would add a user such as "Domain\fishcake" and then check to see if that user already exists.
However the value of txtAccount.text = @"Domain\fishcake" and when passed in as a parameter to a stored procedure to check if it's a duplicate it returns false even if "Domain\fishcake" is in there.
How can i get around this?
If the stored procedure is doing all the work, then I think we would need to see what is happening there.
\ -- is an escape character in C#. You would need to prefix any string that needs \ with an @ sign.
So when you pass it to a stored procedure you should be prefix it with @ there also.
Can you post the code how you are calling the stored procedure and how you are adding the parameter.
Cheers guys, sorted it.