Click here to Skip to main content
15,903,033 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi All ,

This is My Procedure code

SQL
CREATE PROCEDURE dbo.AddNewPerson
	(
	
	
	@FirstName nvarchar(50),
	
	@LastName nvarchar(50),
	@dateofbirth nvarchar(50),
		@Mrn int OUTPUT
		
	)
AS

BEGIN 



INSERT INTO Person(FirstName,LastName,dateofbirth)
		                         VALUES        (@FirstName,@LastName,@dateofbirth)
	 
		SELECT  @Mrn=SCOPE_IDENTITY();
		Return @Mrn
	END

	RETURN


And I'm using SortedList in Class To Pass Parameters To StoredProcedure as following "Code behind"

C#
SortedList SL = new SortedList();
       
        SL.Add("@FirstName", FirstName);
        SL.Add("@LastName", LastName);
        SL.Add("@dateofbirth", dateofbirth);
               

        ProcedureName = "AddNewPerson";
        if (db.RunProcedure(ProcedureName, SL) == 1)
            return true;
        else
            return false;
    }

The inserting is success but how can I get "@Mrn" Value in Text box after inserting
I dont know how to add this output to parameter in Sortedlist or what can I do ?
??????????
Posted
Comments
Joan Magnet 10-Apr-15 11:52am    
what kind of object is db (db.RunProcedure) ?
shms_rony 10-Apr-15 12:42pm    
It's Run Procedure Function that Run any Procedure

public int RunProcedure(string ProcedureName, SortedList ParaValues)
{
connect(CommandType.StoredProcedure, ProcedureName);
for (int x = 0; x < ParaValues.Count; x++)
cmd.Parameters.AddWithValue(ParaValues.GetKey(x).ToString(), ParaValues.GetByIndex(x).ToString());
return ExecuteUpdation();

}
shms_rony 10-Apr-15 12:43pm    
and db is object of class
ZurdoDev 10-Apr-15 11:59am    
SortedList will not support parameter direction. You need to use something else.
shms_rony 10-Apr-15 12:43pm    
like what ??
after save data how to redirect to user data's page with it's ID

1 solution

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900