protected void Page_Load(object sender, EventArgs e)
        {
            //View score
            connection.Open();
            MySqlCommand     cmd     = new MySqlCommand("SELECT userid,score FROM scores");
            MySqlDataAdapter adapter = new MySqlDataAdapter();

            cmd.Connection        = connection;
            adapter.SelectCommand = cmd;
            DataTable dt = new DataTable();

            adapter.Fill(dt);
            GridScores.DataSource = dt;
            GridScores.DataBind();
            if (GridScores.Rows.Count > 0)
            {
            }
            else
            {
                Response.Write("<script>alert('Error loading data');</script>");
            }


            //Show commnets
            Show();
        }
예제 #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["USERNAME"] != null)
            {
                lblSuccess.Text = "Welcome, " + Session["USERNAME"].ToString() + "";
            }
            else
            {
                Response.Redirect("~/LoginPage.aspx");
            }

            //View score
            connection.Open();
            MySqlCommand     cmd     = new MySqlCommand("SELECT userid,score FROM scores");
            MySqlDataAdapter adapter = new MySqlDataAdapter();

            cmd.Connection        = connection;
            adapter.SelectCommand = cmd;
            DataTable dt = new DataTable();

            adapter.Fill(dt);
            GridScores.DataSource = dt;
            GridScores.DataBind();
            if (GridScores.Rows.Count > 0)
            {
            }
            else
            {
                Response.Write("<script>alert('Error loading data');</script>");
            }


            //Show commnets
            Show();
        }