private void CancelB_Click(object sender, EventArgs e)
{
Homepage hmpage = new Homepage();
hmpage.Show();
this.Hide();
}
private void LoginB_Click(object sender, EventArgs e)
{
sqlcon.Open();
SqlCommand cmd = sqlcon.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select UserName from PLogin Where UserName = '******'and Password = '******'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
UN = UNbox.Text;
sqlcon.Close();
if (dt.Rows.Count >= 1)
{
Homepage hmpage = new Homepage();
hmpage.Show();
this.Hide();
}
else
{
MessageBox.Show("Check User Nmae and Password");
}
}
private void CancelB_Click(object sender, EventArgs e)
{
if (MessageBox.Show("If you go back you have to re-submit all the info. \nDo you want to continue", "Go Back", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question) == DialogResult.Yes)
{
Homepage hmpage = new Homepage();
hmpage.Show();
this.Hide();
}
}
private void LoginB_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-I2JB8K5;Initial Catalog=Login;Integrated Security=True");
SqlDataAdapter sda = new SqlDataAdapter("select count(*) from Login_tb where User_Name='" + UNbox.Text + "' and Password= '******'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
Homepage hmpage = new Homepage();
hmpage.Show();
this.Hide();
}
else
{
MessageBox.Show("Please Check your UserName and Password!", "aleart", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}