asp.net中的身份标识 [英] retern identity in asp.net

问题描述

ALTER PROCEDURE [dbo].[AddRegistration1Detail]
(
	@FirstName varchar(50),
	@LastName varchar(50)=null,
	

)
AS
	SET NOCOUNT OFF;
INSERT INTO [Registration1] ([FirstName], [LastName]) VALUES (@FirstName, @LastName);

select @@IDENTITY as newid

我的课是

and my class is

public static int AddRegistration1Detail(string FirstName, string LastName )
   {
       comm = new SqlCommand("AddRegistration1Detail", conn);
       comm.CommandType = CommandType.StoredProcedure;
       comm.Parameters.AddWithValue("@FirstName", FirstName);
       comm.Parameters.AddWithValue("@LastName", LastName);
       RegistrationDate);
       comm.Parameters.AddWithValue("@IsActive", IsActive);

       return Convert.ToInt32(CommExecuteNonQuery(comm));


   }

推荐答案

选中此示例将指导您

Hi ,
Check this Example will guide you

create proc  usp_test_Insert
(@OrderAmount int , @date datetime)
as
begin
insert into dbo.Orders
(  OrderAmount, [date])
values
(@OrderAmount ,@date)

select  SCOPE_IDENTITY()
end

protected void Button1_Click(object sender, EventArgs e)
 {
     using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
     {
         con.Open();
         using (SqlCommand cmd = new SqlCommand("usp_test_Insert",con))
         {
             cmd.CommandType = System.Data.CommandType.StoredProcedure;
             cmd.Parameters.AddWithValue("@OrderAmount",TextBox1.Text);
             cmd.Parameters.AddWithValue("@date", DateTime.Now);
              int ID = Convert.ToInt32(  cmd.ExecuteScalar());
              Response.Write("<script>alert('"+ID.ToString()+"')</script>");
         }
     }
 }

最好的问候
M.Mitwalli

Best Regards
M.Mitwalli

您的存储过程可以使用OUTPUT关键字返回一个值.可以使用另一个参数(其Direction属性设置为ParameterDirection.Output)在asp.net中进行检索.

请参阅rolla中4guys的这篇文章，其中对此进行了详细说明:

http://www.4guysfromrolla.com/articles/062905-1.aspx [ ^ ]

Your stored procedure can return a value using the OUTPUT keyword. This can be retrieved in asp.net using another parameter, whose Direction property is set to ParameterDirection.Output.

Refer to this article from 4guys in rolla, which explains this in detail:

http://www.4guysfromrolla.com/articles/062905-1.aspx[^]

您可以使用输出参数.
此

also ,you can use output param.
this

这篇关于asp.net中的身份标识的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！