コード例 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["User_Id"] == null)
            {
                Response.Redirect("LoginPage.aspx");
            }
            if (!IsPostBack)
            {
                SqlConnection con        = new SqlConnection(ConfigurationManager.ConnectionStrings["UniversityDatabaseConnectionString"].ConnectionString);
                String        value      = Request.QueryString.ToString();
                Char          delimiter  = '&';
                String[]      substrings = value.Split(delimiter);
                //Response.Write("<script>alert('" + value + "');</script>");
                //Response.Write("<script>alert('year=" + substrings[0] + " name=" + substrings[1] + "');</script>");

                if (substrings[0].StartsWith("NUMBER="))
                {
                    substrings[0] = substrings[0].Remove(0, "NUMBER=".Length).Replace('+', ' ').Trim();
                }
                if (substrings[1].StartsWith("NAME="))
                {
                    substrings[1] = substrings[1].Remove(0, "NAME=".Length).Replace('+', ' ').Trim();
                }

                string number, Nm;
                number = substrings[0];
                Nm     = substrings[1];
                //Response.Write("<script>alert('YEAR =" + Yr + " NAME=" + Nm + "');</script>");
                DataSet ds = SelectAllSectionData(number, Nm);
                LblYrDis.Text   = number.ToString();
                LblNameDis.Text = Nm.ToString();
                TxtAmount.Text  = ds.Tables[0].Rows[0]["AMOUNT"].ToString();
            }
        }