如果是SQL SERVER数据库,你可以使用返回值:
先创建一个存储过程:
CREATE PROCEDURE Inserttest
@name AS VARCHAR(50)
AS
INSERT INTO 数据表 ([name]) VALUES (@name) RETURN @@identity
调用代码如下:
SqlCommand cmd = new SqlCommand("Inserttest", sqlConn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = "abc";
cmd.ExecuteNonQuery();
int nID = (int)cmd.Parameters["RETURN_VALUE"].Value;
先创建一个存储过程:
CREATE PROCEDURE Inserttest
@name AS VARCHAR(50)
AS
INSERT INTO 数据表 ([name]) VALUES (@name) RETURN @@identity
调用代码如下:
SqlCommand cmd = new SqlCommand("Inserttest", sqlConn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = "abc";
cmd.ExecuteNonQuery();
int nID = (int)cmd.Parameters["RETURN_VALUE"].Value;