private void button1_Click(object sender, EventArgs e) { if (textBox3.Text == code) { Personal_acc_freelancer acc = new Personal_acc_freelancer(this, username); acc.Show(); this.Close(); } else { MessageBox.Show("Wrong code!"); } }
private void button1_Click(object sender, EventArgs e) { using (SqlConnection conn = DBUtils.GetDBconnection()) { string username = ""; DataTable table2 = new DataTable(); //создаем вторую таблицу SqlDataAdapter adapter2 = new SqlDataAdapter(); //создаем второй адаптер DataTable table = new DataTable(); //создаем таблицу SqlDataAdapter adapter = new SqlDataAdapter(); //создаем адаптер conn.Open(); string sqlExpression = "SELECT * FROM Freelancer WHERE Email = '" + textBox2.Text + "' AND Pass = '******' "; string sqlExpression2 = "SELECT Username FROM Freelancer WHERE Email = '" + textBox2.Text + "' AND Pass = '******' "; SqlCommand command = new SqlCommand(sqlExpression, conn); SqlCommand command2 = new SqlCommand(sqlExpression2, conn); command.ExecuteNonQuery(); command2.ExecuteNonQuery(); adapter.SelectCommand = command; adapter2.SelectCommand = command2; adapter.Fill(table); adapter2.Fill(table2); foreach (DataRow row in table2.Rows) { // получаем все ячейки строки var cells = row.ItemArray; foreach (object cell in cells) { username = cell.ToString(); } } if (table.Rows.Count > 0)//проверяем, есть ли в таблице данные { Personal_acc_freelancer perAcc = new Personal_acc_freelancer(this, username); perAcc.Show(); this.Close(); conn.Close(); } else { MessageBox.Show("Invalid E-mail or Password"); conn.Close(); } } }