private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (checkBox1.Checked)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=DESKTOP-69MM1NJ\SQLEXPRESS;Initial Catalog=NadhamniDB;Integrated Security=True;Pooling=False";
try
{
con.Open();
string sql = "select ProfilePic,Password,Email from Profile where UserName = '******'";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
txt_password.Text = dr[1].ToString();
txt_Email.Text = dr[2].ToString();
Byte[] img = (Byte[])(dr[0]);
if (img == null)
{
pictureBox1.Image = null;
}
else
{
MemoryStream ms = new MemoryStream(img);
pictureBox1.Image = Image.FromStream(ms);
}
}
else
{
CheckRegistration cr = new CheckRegistration();
cr.Show();
//MessageBox.Show("error img not found");
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
//btnUploadPic.Visible = false;
}
}
private void btn_signIn_Click(object sender, EventArgs e)
{
try
{
con.Open();
cmd.Connection = con;
cmd.CommandText = "select * from Profile where UserName='******'";
dr = cmd.ExecuteReader();
if (dr.HasRows)
{ //get the FK
FK = txt_username.Text;
Boolean ok = false;
while (dr.Read() && ok == false)
{
if (!txt_password.Text.Equals(dr["Password"]))
{
PasswordCheck pw = new PasswordCheck();
pw.Show();
// MessageBox.Show("You need to check your password!");
ok = true;
}
else if (!txt_Email.Text.Equals(dr["Email"]))
{ //MessageBox.Show("You need to check your E-mail!");
EmailCheck ec = new EmailCheck();
ec.Show();
ok = true;
}
}
if (ok == false)
{
dsh.Show();
this.Hide();
fb.Hide();
tw.Hide();
gp.Hide();
}
}
else
{
if (txt_password.Text.Equals("") && txt_Email.Text.Equals("") && txt_username.Text.Equals(""))
{
// MessageBox.Show("The fields are empty");
EmptyFields ep = new EmptyFields();
ep.Show();
}
else
{
}
// MessageBox.Show("You need to register!");
CheckRegistration crg1 = new CheckRegistration();
crg1.Show();
dr.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}