如何在ASPX页面中检索@@ Identity值 [英] How to retrive @@Identity value in aspx page

问题描述

将ANSI_NULLS设置为
设置QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_Registration](
@CustomerId int，
@EmailId varchar(50)，
@FirstName varchar(50)，
@姓氏varchar(50)，
@ Phone1 varchar(15)，
@ Phone2 varchar(15)，
@CompanyName varchar(50)，
@Address varchar(max)，
@ZipCode varchar(20)，
@City varchar(50)，
@State varchar(50)，
@Country varchar(50)，
@TransactionDate datetime，
@Status varchar(30)
)
AS
开始
插入dbo.CustomerDetails值(@ EmailId，@ FirstName，@ Lastname，@ Phone1，@ Phone2，@ CompanyName
，@地址，@邮政编码，@城市，@州，@国家，@ TransactionDate，@状态)
将@NewId声明为int
选择@ NewId = @@ IDENTITY
END
在上表中，customerId是主键并自动生成.插入此信息后，我需要最后一条记录，我的意思是最近添加的记录客户ID请需要帮助

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_Registration] (
@CustomerId int,
@EmailId varchar(50),
@FirstName varchar(50),
@Lastname varchar(50),
@Phone1 varchar(15),
@Phone2 varchar(15),
@CompanyName varchar(50),
@Address varchar(max),
@ZipCode varchar(20),
@City varchar(50),
@State varchar(50),
@Country varchar(50),
@TransactionDate datetime,
@Status varchar(30)
)
AS
BEGIN
insert into dbo.CustomerDetails values(@EmailId,@FirstName,@Lastname,@Phone1,@Phone2,@CompanyName
,@Address,@ZipCode,@City,@State,@Country,@TransactionDate,@Status)
Declare @NewId as int
select @NewId= @@IDENTITY
END
In above table customerId is a primary key and auto generated. After inserting this information i need last record i mean recently added record Customer Id Please need help

推荐答案

只需在存储的过程中进行以下更改.

添加选择@@ identity

取而代之的是

Just make the following changes in stored proc.

Add select @@identity

Instead of this,

Declare @NewId as int
select @NewId= @@IDENTITY
END

现在您的代码看起来像

now ur code will look like

Select @@Identity
END

现在在执行命令时在aspx页面中.

Now in aspx page when executing command.

SqlCommand cmd = new SqlCommand();
CommandText = "StoredProcedureName";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
int ID=(Int32)cmd.ExecuteScalar();
sqlConnection1.Close();

如果您的ID是自动递增的，则在插入数据后检索MAX(ID).

If your Id is in auto-increment then retrieve MAX(ID) after inserting the data.

使用return关键字，

use return keyword,

Declare @NewId as int
select @NewId= @@IDENTITY
return @NewId

祝您编码愉快！
:)

Happy Coding!
:)

这篇关于如何在ASPX页面中检索@@ Identity值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！