62,046
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE Add_gb_user
@test_name nvarchar(8)
AS
INSERT INTO user_Personal (test_name) values(@test_name)
return SELECT IDENT_CURRENT('user_Personal')
go
string connstring = WebConfigurationManager.ConnectionStrings["test"].ConnectionString;
SqlConnection conna = new SqlConnection(connstring);
SqlCommand cmda = conna.CreateCommand();
conna.Open();
string ca ="88";
cmda.CommandType = CommandType.StoredProcedure;
cmda.CommandText = "Add_gb_user";
cmda.Parameters.Add("@test_name", ca);
cmda.ExecuteNonQuery().ToString();
conna.Close();
return SELECT IDENT_CURRENT('user_Personal')
有问题,或者.net中应该怎样得到那个返回值呢,望请教,谢谢~~!