private void Hyni_button_Click_1(object sender, EventArgs e) { try { MySqlConnection conn = new MySqlConnection(connstr); conn.Open(); //RoleID = '1' string MesLog_query = "Select count(*) from Login where User_Name = '" + UsernametextBox.Text + "' and Pasword = '" + PasstextBox.Text + "' AND RoleID = 1 "; MySqlCommand cmd = new MySqlCommand(MesLog_query, conn); cmd.ExecuteReader(); conn.Close(); MySqlDataAdapter sda = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (Convert.ToInt32(dt.Rows[0][0]) == 1) { CookieClass.LoginID = UsernametextBox.Text; MessageBox.Show("Vendosja e kredencialeve u krye me sukses!", " ", MessageBoxButtons.OK, MessageBoxIcon.Information); MesuesMain m = new MesuesMain(); m.Show(); this.Hide(); } else { label1.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Hyni_button_Click(object sender, EventArgs e) { //string query = "Select * from MESUES where Username = '******' and Password = '******' "; //SqlConnection con = new SqlConnection(connectionsString); //con.Open(); //sda = new SqlDataAdapter(query, con); //sda.SelectCommand.ExecuteNonQuery(); //DataTable dt = new DataTable(); //sda.Fill(dt); //if (dt.Rows[0][0].ToString == "1") //{ PassPanel.BackColor = Color.FromArgb(100, 149, 237); PasstextBox.ForeColor = Color.Black; UsernamePanel.BackColor = Color.FromArgb(100, 149, 237); UsernamePanel.ForeColor = Color.Black; if (UsernametextBox.Text == "2030" && PasstextBox.Text == "1234") { MessageBox.Show("Vendosja e kredencialeve u krye me sukses!", " ", MessageBoxButtons.OK, MessageBoxIcon.Information); // this.Hide(); // MesueseMain m = new MesueseMain(); // m.Show(); //} //else //{ // MessageBox.Show("Ju nuk u futet me sukses ne platforme! "); //} MesuesMain mm = new MesuesMain(); mm.Show(); this.Hide(); } //con.Close(); else { MessageBox.Show("Vendosni sakte kredencialet!", " Mësuesi nuk ekziston ", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }