Popup window with Sql return values

[strtech]

I have created a web application with Sql 2005 stored procedures. I want to show the return value messages in a pop up window in the application but have been unsuccessful in getting it to display. I have tested it in SQL Query Analyzer and it is working successfully.

How can I display it in the ASP.net application in a popup window?

 

[jbenson001]

What do you mean by return value? Do you mean an output variable that you are using to pass back a value, or the return code of the SP?

 

[strtech]

For example, in my stored procedure I'm checking for duplicate records before inserting the record in the table. The stored procedure returns a code of Return (5) and prints the message "A duplicate record has been found". I want that message to show up in a message box. I hope I have clarified it.

 

[jbenson001]

You will have to pass back message in an output paramater and display it.

 

[vbkris]

>>I want that message to show up in a message box. I hope I have clarified it

AND

u need to use JavaScript for this. Check the alert() function of JS...

Known is handfull, Unknown is worldfull