private void button4_Click(object sender, EventArgs e)
{
this.Hide();
ShowUsr frm = new ShowUsr();
frm.Show();
}
public void btnLogIn_Click(object sender, EventArgs e)
{
connect DB = new connect();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DB.openConnection();
MySqlCommand command = new MySqlCommand("SELECT `id_user`,`password` FROM `user_info` WHERE `login`=@login AND `password`=@password ", DB.getConnection());
command.Parameters.Add("@login", MySqlDbType.VarChar).Value = inputLogin1.Text;
command.Parameters.Add("@password", MySqlDbType.VarChar).Value = inputPassword1.Text;
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
User_info.id_user = String.Format("{0}", reader[0]);
User_info.password_user = String.Format("{0}", reader[1]);
}
DB.closeConnection();
adapter.SelectCommand = command;
adapter.Fill(table);
if (table.Rows.Count > 0)
{
this.Hide();
ShowUsr Main = new ShowUsr();
Main.Show();
}
else
{
MessageBox.Show("Неверные данные");
}
}