IF condition message based on sql temp variable not displaying

Question

I'm trying to check if username exists on textbox changed event.I've a stored procedure that does this checking and returns the output variable @proceed which I call in my code behind file.How do I handle the if condition based on output parameter in my stored procedure.Like

@ proceed == 1

{

print 'record exists'

}                

Answer 1

hi, below given link may help you.

http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html

Answer 2

Hi SQLProgramming,

Please have a look at the following links to work with output parameters in ADO.NET:

http://www.codeproject.com/Articles/15403/Calling-Stored-procedures-in-ADO-NET

http://ketakikode.blogspot.com/2009/07/adonet-output-parameter-in-vb.html

http://www.java2s.com/Tutorial/CSharp/0560__ADO.Net/CallStoredProcedurewithinputandoutputparameters.htm

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.