void panggilnama() { Loginpage frm1 = new Loginpage(); koneksi(); String sql = "Select Name,Email,jk,nik from teacher "; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { if (frm1.getemail() == rdr.GetString(1)) { String jk = ""; if (rdr.GetString(2) == "Male") { jk = "Mr."; } else if (rdr.GetString(2) == "Female") { jk = "Mrs."; } label2.Text = "Welcome, " + jk + rdr.GetString(0); NIK = rdr.GetString(3); } } rdr.Close(); conn.Close(); }
string getNIK() { Loginpage frm1 = new Loginpage(); koneksi(); String sql = "Select nik from teacher where email = '" + frm1.getemail() + "'"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); String n = ""; while (rdr.Read()) { n = rdr.GetString(0); } conn.Close(); return(n); }
private void button2_Click(object sender, EventArgs e) { seting = new Seting(); Loginpage frm1 = new Loginpage(); koneksi(); //ganti back Color seting seting.BackColor = this.BackColor; seting.Show(); this.Hide(); String s = "SELECT nis FROM student WHERE email = '" + frm1.getemail() + "'"; MySqlCommand c = new MySqlCommand(s, conn); Object result = c.ExecuteScalar(); String nis1 = (String)result; String sql = ""; if (BackColor == Color.FromArgb(238, 142, 160)) { sql = "UPDATE student SET Theme = 1 WHERE NIS = '" + nis1 + "'"; } else if (BackColor == Color.FromArgb(249, 157, 42)) { sql = "UPDATE student SET Theme = 2 WHERE NIS = '" + nis1 + "'"; } else if (BackColor == Color.FromArgb(224, 43, 48)) { sql = "UPDATE student SET Theme = 3 WHERE NIS = '" + nis1 + "'"; } else if (BackColor == Color.FromArgb(95, 189, 102)) { sql = "UPDATE student SET Theme = 4 WHERE NIS = '" + nis1 + "'"; } else if (BackColor == Color.FromArgb(0, 192, 192)) { sql = "UPDATE student SET Theme = 5 WHERE NIS = '" + nis1 + "'"; } MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); }
void panggilnama() { Loginpage frm1 = new Loginpage(); koneksi(); String sql = "Select Name,Email,NIS from student "; //where Email='"+frm1.getemail()+"'" MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { if (frm1.getemail() == rdr.GetString(1)) { labeluser.Text = "Welcome, " + rdr.GetString(0); this.nis = rdr.GetString(2); } } conn.Close(); }
public DataTable baca() { Loginpage frm1 = new Loginpage(); koneksi(); String s = "SELECT username FROM teacher WHERE email = '" + frm1.getemail() + "'"; MySqlCommand c = new MySqlCommand(s, conn); Object result = c.ExecuteScalar(); String username = (String)result; String sql = "SELECT name, nis FROM student WHERE username = '******'"; DataColumn column = new DataColumn(); column.ColumnName = "no."; column.DataType = System.Type.GetType("System.Int32"); column.AutoIncrement = true; column.AutoIncrementSeed = 1; column.AutoIncrementStep = 1; DataTable dt = new DataTable(); try { dt.Columns.Add(column); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataAdapter data = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); data.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Columns[0].Width = 30; dataGridView1.Columns[1].Width = 240; dataGridView1.Columns[2].Width = 230; dataGridView1.BackgroundColor = Color.White; } catch (Exception ali) { MessageBox.Show(ali.Message); } conn.Close(); return(dt); }
public DataTable baca() { Loginpage frm1 = new Loginpage(); koneksi(); String s = "SELECT username FROM student WHERE email = '" + frm1.getemail() + "'"; MySqlCommand c = new MySqlCommand(s, conn); Object result = c.ExecuteScalar(); String username = (String)result; String sq = "SELECT nik FROM teacher WHERE username = '******'"; MySqlCommand cm = new MySqlCommand(sq, conn); Object r = cm.ExecuteScalar(); String nik = (String)r; String sql = "SELECT day, time, room, course, teacher FROM schedule WHERE nik = '" + nik + "'"; DataTable dt = new DataTable(); try { MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataAdapter data = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); data.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Columns[0].Width = 60; dataGridView1.Columns[1].Width = 50; dataGridView1.Columns[2].Width = 60; dataGridView1.Columns[3].Width = 267; dataGridView1.Columns[4].Width = 100; dataGridView1.BackgroundColor = Color.White; } catch (Exception ali) { MessageBox.Show(ali.Message); } conn.Close(); return(dt); }
private void Seting_Load(object sender, EventArgs e) { koneksi(); Loginpage frm1 = new Loginpage(); String sql = "SELECT Theme FROM student WHERE email = '" + frm1.getemail() + "'"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { //if (nis == rdr.GetString(0)) //{ if (rdr.GetInt16(0) == 1) { this.BackColor = Color.FromArgb(238, 142, 160); } else if (rdr.GetInt16(0) == 2) { this.BackColor = Color.FromArgb(249, 157, 42); } else if (rdr.GetInt16(0) == 3) { this.BackColor = Color.FromArgb(224, 43, 48); } else if (rdr.GetInt16(0) == 4) { this.BackColor = Color.FromArgb(95, 189, 102); } else if (rdr.GetInt16(0) == 5) { this.BackColor = Color.FromArgb(0, 192, 192); } //} } conn.Close(); }