void UpdateProfileClick(object sender, EventArgs e)
        {
            FileStream fs;
            BinaryReader br;

            if(usernameUser.Text=="" || passwordUser.Text=="" || namaLengkapUser.Text=="" || tglLahirUser.Text=="" || pekerjaanUser.Text=="" || alamatUser.Text=="" || noHpUser.Text=="" || foto.Image==null )
            {
                MessageBox.Show("Data belum lengkap. Isilah semua data anda.", "Register Gagal", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            koneksi.Open();

            string FileName = fototext.Text;
            byte[] ImageData;
            fs = new FileStream(FileName, FileMode.Open, FileAccess.Read);
            br = new BinaryReader(fs);
            ImageData = br.ReadBytes((int)fs.Length);
            br.Close();
            fs.Close();

            MySqlCommand cmd = new MySqlCommand("update user set nama=@nama, password=@password, tanggal_lahir=@tanggal_lahir, pekerjaan=@pekerjaan, alamat=@alamat, no_hp=@no_hp, image=@image where username=@username", koneksi);
            cmd.Parameters.AddWithValue(@"nama", namaLengkapUser.Text);
            cmd.Parameters.AddWithValue(@"password", passwordUser.Text);
            cmd.Parameters.AddWithValue(@"tanggal_lahir", tglLahirUser.Text);
            cmd.Parameters.AddWithValue(@"pekerjaan", pekerjaanUser.Text);
            cmd.Parameters.AddWithValue(@"alamat", alamatUser.Text);
            cmd.Parameters.AddWithValue(@"no_hp", noHpUser.Text);
            cmd.Parameters.AddWithValue(@"username", usernameUser.Text);
            cmd.Parameters.AddWithValue(@"image", ImageData);

            try{
                cmd.ExecuteNonQuery();
                MessageBox.Show("Data profil berhasil di-edit.", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
                namauser.Text = namaLengkapUser.Text;
            }
            catch (MySqlException ex){
                MessageBox.Show(ex.ToString());
            }
            koneksi.Close();
        }

string FileName = fototext.Text;
byte[] ImageData;
fs = new FileStream(FileName, FileMode.Open, FileAccess.Read);
br = new BinaryReader(fs);
ImageData = br.ReadBytes((int)fs.Length);
br.Close();
fs.Close();