C#连接mysql数据库插入数据后获取自增长主键ID值

            MySqlConnection cOnn= new MySqlConnection("连接数据库字符串");
            conn.Open();
            MySqlCommand mycmd = new MySqlCommand();
            mycmd.COnnection= conn;
            mycmd.CommandType = CommandType.Text;
            mycmd.CommandText = "insert into product(productname) values ("产品名称");";
            mycmd.ExecuteNonQuery();
            //获取插入后的数据ID
            long newid = mycmd.LastInsertedId;