79
{
con.Open();
string query = "select
id,username,password,firstname,lastname,address from user WHERE username ='"
+ txtUsername.Text + "' AND password ='" + txtPassword.Text + "'";
MySqlDataReader row;
row = con.ExecuteReader(query);
if (row.HasRows)
{
while (row.Read())
{
id = row["id"].ToString();
username = row["username"].ToString();
password = row["password"].ToString();
firstname = row["firstname"].ToString();
lastname = row["lastname"].ToString();
address = row["address"].ToString();
} MessageBox.Show("Data found your name is " +
firstname + " " + lastname + " " + " and your address at " + address);
}
else
{