private void label3_Click(object sender, EventArgs e) { int login = 0; using (SqlConnection con = new SqlConnection(Properties.Settings.Default.Mess)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT Count(*) FROM Users WHERE Email='" + NameText.Text + "' and Password='******'"; SqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { login = Convert.ToInt32(read[0]); } con.Close(); } if (login == 1) { /*-----------------------------------------------------------------------------*/ using (SqlConnection con = new SqlConnection(Properties.Settings.Default.Mess)) { con.Open(); SqlCommand cmd1 = con.CreateCommand(); cmd1.CommandText = "SELECT id FROM Users WHERE Email='" + NameText.Text + "' "; SqlDataReader rader1 = cmd1.ExecuteReader(); while (rader1.Read()) { TEST = rader1["id"].ToString(); } con.Close(); con.Open(); SqlCommand cmd2 = con.CreateCommand(); cmd2.CommandText = "SELECT FirstName FROM Users WHERE id = '" + TEST + "' "; SqlDataReader rader2 = cmd2.ExecuteReader(); while (rader2.Read()) { nam = rader2["FirstName"].ToString(); } con.Close(); } /*-----------------------------------------------------------------------------*/ BigShaq1 BigShaq1 = new BigShaq1(this); BigShaq1.Show(); this.Hide(); } else { MessageBox.Show("Не правильный логин или пароль"); } }
private void label3_Click(object sender, EventArgs e) { try { user = userDAO.GetUser(NameText.Text, passwordText.Text); BigShaq1 BigShaq1 = new BigShaq1(user); BigShaq1.Show(); this.Hide(); } catch { MessageBox.Show("Не правильный логин или пароль"); } }