Hi. i have written a stored procedure in sqlserver:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create procedure [dbo].[Insert_Person_SP]
(
@CityId int ,
@Name nvarchar(100),
@Family nvarchar(100),
@Gender nchar(10),
@MilitaryStatus nvarchar(50)
)
as
begin
insert into Person (CityId,Name,Family,Gender,MilitaryStatus)
values (@CityId,@Name,@Family,@Gender,@MilitaryStatus)
return @@Identity
end
and also i have made a class in Asp.net for retrieving PersonId as below:
public class globalvaribles
{
public static int PersonId
{
get
{
if (HttpContext.Current.Session["PersonId"] == null)
HttpContext.Current.Sessio ...
Go to the complete details ...