Hi All ,
This is My Procedure code
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"
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 ?
??????????