Database

create procedure SP_abc(
@a INT,
@b VARCHAR(10) OUTPUT
)
as
begin
set @b = 'ABCD'
end

balaji.t wrote:

cudnt

balaji.t wrote:

wht

balaji.t wrote:

ppl

balaji.t wrote:

5n

balaji.t wrote:

u

balaji.t wrote:

ure

/*Declare an output Parameter, The Dimenstion should be the same as the 
one you have in your table.*/
    cmdselect.Parameters.Add("@OutString", SqlDbType.VarChar, 10);

 cmdselect.Parameters["@OutRess"].Direction = ParameterDirection.Output;
 
//The Following line you are going to retrieve what has been returned. 


            con.Open(); //open connection 

       cmdselect.ExecuteNonQuery(); //Execution of a Stored Procedure  

  RString = Convert.ToString(cmdselect.Parameters["@OutRess"].Value);
  //accept a Geocode from the output variable

            con.Close();//Closing the Connection

/* Remember the Output Variable name in your Stored Procedure ,should be the same as the one you declare in C# code. */

balaji.t wrote:

DC1DataContext obj = new DC1DataContext();
string b = null;
string c = obj.StoredProcedure1(1, ref b).ToString();