private void button3_Click(object sender, EventArgs e)
{
UserFrm uf = new UserFrm(pa);
uf.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("Please provide UserName and Password");
return;
}
else if (comboBox1.Text == "Admin")
{
if (textBox1.Text == "admin" && textBox2.Text == "admin")
{
AdminForm fm = new AdminForm();
fm.Show();
this.Hide();
}
else
{
MessageBox.Show("Wrong Admin UserName or Passoword!");
}
}
else
{
try
{
//Create SqlConnection
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("Select * from [User] where UsrName=@username and Psw=@password", con);
cmd.Parameters.AddWithValue("@username", textBox1.Text);
cmd.Parameters.AddWithValue("@password", textBox2.Text);
con.Open();
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
con.Close();
pa = textBox1.Text;
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
//Parameter passing to form 2
UserFrm fm = new UserFrm(pa);
fm.Show();
this.Hide();
}
else
{
MessageBox.Show("User Name are Password are not Correct!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}//end of else
}