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();
}
}
}
