<div>
<div class="content wysiwyg-content">
My Stored procedure is;<br />
ALTER PROCEDURE [dbo].[MyStoredProcedure] <br />
&nbsp; &nbsp; @xxx nvarchar(40),<br />
&nbsp; &nbsp; @yyy &nbsp; &nbsp; &nbsp; &nbsp;nvarchar(20)<br />
AS<br />
BEGIN<br />
&nbsp; &nbsp; IF (EXISTS( SELECT * FROM dbo.MyTable WHERE &nbsp;xxx= @xxxAND yyy= @yyy))<br />
&nbsp; &nbsp; &nbsp; &nbsp; RETURN(1)<br />
&nbsp; &nbsp; ELSE<br />
&nbsp; &nbsp; &nbsp; &nbsp; RETURN(0)<br />
END<br />
I want to get the return value(0/1 or true/false) of the MyStoredProcedure at run time with C# by using a SqlDataSource. How can I give the paramerters and how I can get the value?
</div>
</div>


My Stored procedure is;
ALTER PROCEDURE [dbo].[MyStoredProcedure] 
    @xxx nvarchar(40),
    @yyy        nvarchar(20)
AS
BEGIN
    IF (EXISTS( SELECT * FROM dbo.MyTable WHERE  xxx= @xxxAND yyy= @yyy))
        RETURN(1)
    ELSE
        RETURN(0)
END
I want to get the return value(0/1 or true/false) of the MyStoredProcedure at run time with C# by using a SqlDataSource. How can I give the paramerters and how I can get the value?

How get data from a storedprocedure?

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.