private void btnSubmit_Click(object sender, EventArgs e) { string query = "insert into siswa(NIS, nama, email, jurusan, kelas, password, no_hp, ttl, motto, alamat)" + " values ('" + tbNIS.Text + "', '" + tbNama.Text + "', '" + tbEmail.Text + "', '" + cbJurusan.Text + "', '" + cbKelas.Text + "','" + tbPass.Text + "', '" + tbNo.Text + "', " + "'" + dateTimePicker1.Value.Date.ToString("yyyyMMdd") + "', '" + tbMotto.Text + "', '" + tbAlamat.Text + "') ;"; MySqlDataReader reader; Form_Login f1 = new Form_Login(); try { connect.Open(); MySqlCommand SQLCommand = new MySqlCommand(query, connect); if (tbNIS.TextLength > 5) { MessageBox.Show("Panjang NIS tidak boleh lebih dari 5"); } else if (tbNIS.Text.Equals("") || tbNama.Text.Equals("") || tbEmail.Equals("") || cbJurusan.Text.Equals("") || cbKelas.Text.Equals("") || tbPass.Text.Equals("") || tbNo.Text.Equals("") || tbMotto.Text.Equals("") || tbAlamat.Text.Equals("")) { MessageBox.Show("Data harus terisi semua"); } else { reader = SQLCommand.ExecuteReader(); this.Dispose(); f1.ShowDialog(); } //MessageBox.Show("Connected");*/ connect.Close(); } catch (Exception ex) { MessageBox.Show("NIS sudah memiliki akun"); } }
private void btnSend_Click(object sender, EventArgs e) { Form_Login frm1 = new Form_Login(); MySqlCommand cmd, cmd2; FileStream fs; BinaryReader br; string CmdGetNama = "Select nama from siswa where nis='" + frm1.getuid() + "'"; //string CmdGetNama = "Select nama from siswa where nis='55555'"; cmd2 = new MySqlCommand(CmdGetNama, con); if (tbKet.Text.Length > 0) { try { if (tbFoto.Text.Length > 0) { string FileName = tbFoto.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(); string CmdString = "INSERT into kenangan(nis, nama, gambar, video, keterangan) values (@nis, @nama, @Image, @video, @ket)"; cmd = new MySqlCommand(CmdString, con); cmd.Parameters.Add("@Image", MySqlDbType.Blob); //cmd.Parameters.Add("@id", MySqlDbType.Int16, 5); cmd.Parameters.Add("@nis", MySqlDbType.Int16, 5); cmd.Parameters.Add("@nama", MySqlDbType.VarChar, 100); cmd.Parameters.Add("@video", MySqlDbType.VarChar, 10000); cmd.Parameters.Add("@ket", MySqlDbType.VarChar, 100000); cmd.Parameters["@Image"].Value = ImageData; // cmd.Parameters["@id"].Value = 0; cmd.Parameters["@nis"].Value = frm1.getuid(); cmd.Parameters["@video"].Value = tbVideo.Text; cmd.Parameters["@ket"].Value = tbKet.Text; con.Open(); MySqlDataReader nama_read = cmd2.ExecuteReader(); if (nama_read.Read()) { cmd.Parameters["@nama"].Value = nama_read.GetValue(0).ToString(); } con.Close(); con.Open(); int RowsAffected = cmd.ExecuteNonQuery(); if (RowsAffected > 0) { MessageBox.Show("Data berhasil di upload"); Form_AlbumKenangan frm9 = new Form_AlbumKenangan(); this.Dispose(); frm9.ShowDialog(); } con.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } }