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

From: http://blog.csdn.net/zbc496218/article/details/51082983

    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;