private void metroButton1_Click(object sender, EventArgs e)
{
string sql = @"select * from userinfo where username = '******' and password = '******';";
DataAccess da = new DataAccess();
DataSet ds = da.ExecuteQuery(sql);
if (ds.Tables[0].Rows.Count == 1)
{
LobbyForm f3 = new LobbyForm(metroTextBoxUsername.Text);
f3.Show();
this.Dispose();
}
else
{
MessageBox.Show("Incorrect Username or Password");
}
}
public LeaderboardForm(LobbyForm lb) : this()
{
this.lb = lb;
string sqlUsernameCheck = @"select * from userinfo order by totalwin desc;";
DataAccess d = new DataAccess();
DataSet ds = d.ExecuteQuery(sqlUsernameCheck);
lbl1st.Text = ds.Tables[0].Rows[0]["username"].ToString();
lbl1stScore.Text = ds.Tables[0].Rows[0]["totalwin"].ToString();
lbl2nd.Text = ds.Tables[0].Rows[1]["username"].ToString();
lbl2ndScore.Text = ds.Tables[0].Rows[1]["totalwin"].ToString();
lbl3rd.Text = ds.Tables[0].Rows[2]["username"].ToString();
lbl3rdScore.Text = ds.Tables[0].Rows[2]["totalwin"].ToString();
lbl4th.Text = ds.Tables[0].Rows[3]["username"].ToString();
lbl4thScore.Text = ds.Tables[0].Rows[3]["totalwin"].ToString();
lbl5th.Text = ds.Tables[0].Rows[4]["username"].ToString();
lbl5thScore.Text = ds.Tables[0].Rows[4]["totalwin"].ToString();
lbl6th.Text = ds.Tables[0].Rows[5]["username"].ToString();
lbl6thScore.Text = ds.Tables[0].Rows[5]["totalwin"].ToString();
lbl7th.Text = ds.Tables[0].Rows[6]["username"].ToString();
lbl7thScore.Text = ds.Tables[0].Rows[6]["totalwin"].ToString();
lbl8th.Text = ds.Tables[0].Rows[7]["username"].ToString();
lbl8thScore.Text = ds.Tables[0].Rows[7]["totalwin"].ToString();
lbl9th.Text = ds.Tables[0].Rows[8]["username"].ToString();
lbl9thScore.Text = ds.Tables[0].Rows[8]["totalwin"].ToString();
lbl10th.Text = ds.Tables[0].Rows[9]["username"].ToString();
lbl10thScore.Text = ds.Tables[0].Rows[9]["totalwin"].ToString();
}