我们在进行数据库插入或更新操作的时候,有时我们需要知道当前插入行的数据库表的主键值。
那么我们怎么获得当前插入行主键呢?
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params MySqlParameter[] commandParameters)
{
MySqlCommand cmd = new MySqlCommand();
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.CommandText = "select @@IDENTITY"; //查找主键:asp.net获得当前插入行主键
int PrimaryKey = Convert.ToInt32(cmd.ExecuteScalar());
return PrimaryKey;
// return val;
}
}
cmd.CommandText = "select @@IDENTITY"; //查找主键:asp.net获得当前插入行主键
int PrimaryKey = Convert.ToInt32(cmd.ExecuteScalar());
return PrimaryKey;
返回的结果即为当前插入行主键