public int CheckLogin(string username, string password)
{
AccessData acc = new AccessData();
SqlDataReader reader = acc.ExecuteReader("SELECT USERNAME, PASSWORD FROM USER_INFO");
while (reader.Read())
{
if (reader[0].ToString() == username && reader[1].ToString() == password)
{
return(1);
}
}
return(0);
}
private void Profile_Load(object sender, EventArgs e)
{
AccessData acc = new AccessData();
string frmUsername = frm1.TxtUsername.Text;
SqlDataReader reader = acc.ExecuteReader("SELECT * FROM USER_INFO WHERE USERNAME = '******'");
while (reader.Read())
{
txtUsername.Text = reader[0].ToString();
txtPassword.Text = reader[1].ToString();
txtCPassword.Text = reader[2].ToString();
txtEmail.Text = reader[3].ToString();
txtAddress.Text = reader[4].ToString();
txtOccupation.Text = reader[7].ToString();
//
if (reader[5].ToString() == "Male")
{
rdMale.Checked = true;
}
else
{
if (reader[5].ToString() == "Female")
{
rdFemale.Checked = true;
}
}
//
string birth = reader[6].ToString();
string[] arrBirth = birth.Split('/');
cbDate.Text = arrBirth[0];
cbMonth.Text = arrBirth[1];
cbYear.Text = arrBirth[2];
}
reader.Close();
}
