private void checklogin(string qry)
{
try
{
DB_Connection dB_Connection = new DB_Connection();
DataTable dt = dB_Connection.getDataGrid(qry);
if (dt.Rows.Count == 1)
{
GMS_1v gMS_1V = new GMS_1v();
gMS_1V.Show();
((Form)this.TopLevelControl).Hide();
}
else
{
MessageBox.Show("Your Username or Password is incorrect! Check your username , password and try again!");
Username_tb_lg.Text = "";
Password_tb_lg.Text = "";
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
userControl11.inputs_ftl_1();
ft_login_form21.input_ftl_2();
string Username, Company_Name, Password, Password_hint, pin_Number;
Username = userControl11.username;
Company_Name = userControl11.companyname;
Password = ft_login_form21.password;
Password_hint = ft_login_form21.passwordhint;
pin_Number = ft_login_form21.pinnumber;
DB_Connection dB_Connection = new DB_Connection();
string qry = "INSERT INTO Usertb (Username,Company_Name,Password,Password_hint,Pin_Number) VALUES ('" + Username + "','" + Company_Name + "','" + Password + "','" + Password_hint + "','" + pin_Number + "')";
string qry2 = "Select * From Usertb";
dB_Connection.InsertData(qry);
DataTable dt = dB_Connection.getDataGrid(qry2);
if (dt.Rows.Count != 0)
{
GMS_1v gMS_1V = new GMS_1v();
gMS_1V.ShowDialog();
Console.WriteLine(qry);
}
}