Click here to Skip to main content
13,145,417 members (90,098 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
i need output for sql print value i am passing some values how to get that value aspx page any one help me sir
Posted 3-Oct-12 2:28am
Comments
Guirec Le Bars 3-Oct-12 8:40am
   
If I understand correctly you have some sql which makes usage of the "print" function and you want to get the output string appearing on a web page. Right?
if Yes then there is no direct way. You have to modify the sql so that you create a variable which is the concatenation of what you are printing and then use that variable as an output command of your ado.net query.

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

If you are trying to return a variable from your Stored Procedure, then you must declare an output variable. A sample Procedure is shown below.
You can then get the variable in your aspx page accordingly. Dont forget to handle null.
CREATE PROCEDURE [dbo].[sample]
     @input varchar,
     @output varchar OutPUT
AS
SET NOCOUNT ON
 
BEGIN
  IF @input = 1  
   BEGIN
    SET @output ='your message'
   END
END

OR

If you were referring to print an error message from the SQL stored Proc , then use RAISEERROR function in your SQL Procedure.
use link http://msdn.microsoft.com/en-us/library/ms178592.aspx[^]

You can then catch the exception in the aspx page and display it as required.
  Permalink  
v3
Comments
Oshtri Deka 4-Oct-12 11:20am
   
Comprehensive.
5.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web03 | 2.8.170915.1 | Last Updated 4 Oct 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100