private void Login_Button_Click(object sender, EventArgs e) { if (userName_textBox.Text == "" || password_textBox.Text == "") { MessageBox.Show("Please enter your username and password"); userName_textBox.Focus(); return; } string sqlCommand = "Select * from Account where username=@usrname and password=@passwd"; connection.Open(); using (SqlCommand cmd = new SqlCommand(sqlCommand, connection)) { cmd.Parameters.AddWithValue("@usrname", userName_textBox.Text); cmd.Parameters.AddWithValue("@passwd", password_textBox.Text); using (SqlDataReader reader = cmd.ExecuteReader()) { login.Load(reader); } } //Ko dang nhap dc if (login.Rows.Count == 0) { MessageBox.Show("Wrong username or password, try again"); userName_textBox.Clear(); password_textBox.Clear(); userName_textBox.Focus(); } else //Dang nhap thanh cong { Account account = new Account(login.Rows[0]["username"].ToString(), int.Parse(login.Rows[0]["userID"].ToString()), login.Rows[0]["phone"].ToString(), login.Rows[0]["name"].ToString(), login.Rows[0]["DOB"].ToString() ); MessageBox.Show("Login successfully !"); mainScr.loading_thread.Start(); mainScr.setAccount(account); mainScr.setAccountButtonUsername(login.Rows[0]["username"].ToString()); /*this.Hide(); * var temp = new MainScreen(account); * temp.Show();*/ this.Close(); } login.Clear(); connection.Close(); }