private void Form_MyProfil_Load(object sender, EventArgs e)
{
MySqlCommand cmd, cmd2, cmdNama, cmdEmail, cmdNo, cmdTtl, cmdAlamat, cmdMotto;
this.ControlBox = false;
lblShowNis.Text = f1.getuid();
//lblShowNis.Text = "55555";
string cmd_nama = "select nama from siswa where NIS = '" + lblShowNis.Text + "'";
string cmd_email = "select email from siswa where NIS = '" + lblShowNis.Text + "'";
string cmd_no = "select no_hp from siswa where NIS = '" + lblShowNis.Text + "'";
string cmd_ttl = "select ttl from siswa where NIS = '" + lblShowNis.Text + "'";
string cmd_alamat = "select alamat from siswa where NIS = '" + lblShowNis.Text + "'";
string cmd_motto = "select motto from siswa where NIS = '" + lblShowNis.Text + "'";
cmdNama = new MySqlCommand(cmd_nama, con);
cmdEmail = new MySqlCommand(cmd_email, con);
cmdNo = new MySqlCommand(cmd_no, con);
cmdTtl = new MySqlCommand(cmd_ttl, con);
cmdAlamat = new MySqlCommand(cmd_alamat, con);
cmdMotto = new MySqlCommand(cmd_motto, con);
cmd = new MySqlCommand("select gambar from siswa where NIS='" + lblShowNis.Text + "'", con);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cmd = new MySqlCommand("select gambar from siswa where NIS='00001'", con);
MySqlDataAdapter da2 = new MySqlDataAdapter(cmd);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
con.Open();
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row.IsNull("gambar"))
{
MemoryStream ms = new MemoryStream((byte[])ds2.Tables[0].Rows[0]["gambar"]);
pbFoto.Image = new Bitmap(ms);
//pbFoto.Image = Image.FromFile("E:/ProfileKotak.png");
}
else if (ds.Tables[0].Rows.Count > 0)
{
MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0]["gambar"]);
pbFoto.Image = new Bitmap(ms);
}
}
con.Close();
con.Open();
MySqlDataReader DR1 = cmdNama.ExecuteReader();
if (DR1.Read())
{
tbNama.Text = DR1.GetValue(0).ToString();
}
con.Close();
con.Open();
MySqlDataReader DR2 = cmdEmail.ExecuteReader();
if (DR2.Read())
{
tbEmail.Text = DR2.GetValue(0).ToString();
}
con.Close();
con.Open();
MySqlDataReader DR3 = cmdNo.ExecuteReader();
if (DR3.Read())
{
tbTelp.Text = DR3.GetValue(0).ToString();
}
con.Close();
con.Open();
MySqlDataReader DR4 = cmdTtl.ExecuteReader();
if (DR4.Read())
{
dateTimePicker1.Text = DR4.GetValue(0).ToString();
}
con.Close();
con.Open();
MySqlDataReader DR5 = cmdAlamat.ExecuteReader();
if (DR5.Read())
{
tbAlamat.Text = DR5.GetValue(0).ToString();
}
con.Close();
con.Open();
MySqlDataReader DR6 = cmdMotto.ExecuteReader();
if (DR6.Read())
{
tbMotto.Text = DR6.GetValue(0).ToString();
}
con.Close();
}
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();
}
}
}
}