private void btnLogin_Click(object sender, EventArgs e) { string sUname = txtUname.Text.ToString(); string sPass = txtPass.Text.ToString(); string sU = ""; string sP = ""; Boolean status = false; //no ok MySqlConnection con = new MySqlConnection("datasource=localhost;port=3306;username=root"); con.Open(); string query = "SELECT * from student.user_tb"; MySqlCommand cmd = new MySqlCommand(query, con); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { sU = reader.GetString("uname").ToString(); sP = reader.GetString("password").ToString(); if (sU == sUname && sP == sPass) { status = true; break; } } con.Close(); if (status) { //MessageBox.Show("User Login Successfully!"); frmStudentRegister frmstudentregister = new frmStudentRegister(); frmstudentregister.Show(); this.Hide(); status = false; } else { MessageBox.Show("Try Again!"); txtPass.Clear(); txtUname.SelectionStart = 0; txtUname.SelectionLength = txtUname.Text.Length; txtUname.Select(); } }
private void studentRegisterToolStripMenuItem_Click(object sender, EventArgs e) { frmStudentRegister frmstudentregister = new frmStudentRegister(); frmstudentregister.Show(); }