.net 下数据统计统计

近来，在做一个程序，在校生名册里需要分别统计每个周岁的总人数和女生人数。不才想个很笨的办法，希望能抛砖引玉。程序如下：

protected void Page_Load(object sender, EventArgs e)
    {
        Label38.Text = Request.QueryString["CName"];
        GridView1.Attributes.Add("BorderColor", "#000000");
        string myIsStr = System.Configuration.ConfigurationManager.ConnectionStrings["YU#DataConnectionString"].ConnectionString;
        SqlConnection MyIsConn = new SqlConnection(myIsStr);
        //queryStr书写选择所有留言的SQL命令;建立Adapter对象执行SQL命令
        string IsStr = "select * from [Yu_Stu] where Yu_Class_Id='" + Request.QueryString["CId"] + "' ORDER BY Yu_Stu_Code";
        SqlDataAdapter MyAdapter = new SqlDataAdapter(IsStr, MyIsConn);
        //建立DataSet对象ds;利用Adapter的Fill方法把SQL命令执行的结果倒入DataSet对象
        DataSet ds = new DataSet();
        MyAdapter.Fill(ds, "Temp");

        int O5num = 0;//5岁以下人数
        int O5num1 = 0;//5岁以下女生人数
        int O6num = 0;//6岁以下人数
        int O6num1 = 0;//6岁以下女生人数
        int O7num = 0;//7岁以下人数
        int O7num1 = 0;//7岁以下女生人数
        int O8num = 0;//8岁以下人数
        int O8num1 = 0;//8岁以下女生人数
        int O9num = 0;//9岁以下人数
        int O9num1 = 0;//9岁以下女生人数
        int O10num = 0;//10岁以下人数
        int O10num1 = 0;//10岁以下女生人数
        int O11num = 0;//11岁以下人数
        int O11num1 = 0;//11岁以下女生人数
        int O12num = 0;//12岁以下人数
        int O12num1 = 0;//12岁以下女生人数
        int O13num = 0;//13岁以下人数
        int O13num1 = 0;//13岁以下女生人数
        int O14num = 0;//14岁以下人数
        int O14num1 = 0;//14岁以下女生人数
        int O15num = 0;//15岁以下人数
        int O15num1 = 0;//15岁以下女生人数

        if (ds.Tables["Temp"].Rows.Count < 1)
        {
            //Response.Write("<script type='text/javascript' language='javascript'>alert('该班级没有学生！');history.go(-1);</script>");
        }
        else
        {
            for (int i = 0; i < ds.Tables["Temp"].Rows.Count; i++)
            {
                //ds.Tables["Temp"].Rows[0]["Yu_User_Id"].ToString();
                switch (ds.Tables["Temp"].Rows[i]["Yu_Stu_Old"].ToString())
                {
                    case "6":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O6num1 = O6num1 + 1;
                        }
                        O6num = O6num + 1;
                        break;
                    case "7":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O7num1 = O7num + 1;
                        }
                        O7num = O7num + 1;
                        break;
                    case "8":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O8num1 = O8num1 + 1;
                        }
                        O8num = O8num + 1;
                        break;
                    case "9":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O9num1 = O9num1 + 1;
                        }
                        O9num = O9num + 1;
                        break;
                    case "10":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O10num1 = O10num1 + 1;
                        }
                        O10num = O10num + 1;
                        break;
                    case "11":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O11num1 = O11num1 + 1;
                        }
                        O11num = O11num + 1;
                        break;
                    case "12":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O12num1 = O12num1 + 1;
                        }
                        O12num = O12num + 1;
                        break;
                    case "13":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O13num1 = O13num1 + 1;
                        }
                        O13num = O13num + 1;
                        break;
                    case "14":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O14num1 = O14num1 + 1;
                        }
                        O14num = O14num + 1;
                        break;
                    case "15":
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O15num1 = O15num1 + 1;
                        }
                        O15num = O15num + 1;
                        break;
                    default:
                        if (ds.Tables["Temp"].Rows[i]["Yu_Stu_Sex"].ToString() == "女")
                        {
                            O5num1 = O5num1 + 1;
                        }
                        O5num = O5num + 1;
                        break;
                }
                //Response.Write(ds.Tables["Temp"].Rows[i]["Yu_Stu_Old"].ToString());
            }
            GridView1.DataSource = ds;
            GridView1.DataBind();

        }
        int num = O5num + O6num + O7num + O8num + O9num + O10num + O11num + O12num + O13num + O14num + O15num;//全体学生数
        int num1 = O5num1 + O6num1 + O7num1 + O8num1 + O9num1 + O10num1 + O11num1 + O12num1 + O13num1 + O14num1 + O15num1;//全体女生数
        int num2 = num - num1;
        if (O5num != 0)
        {
            Label1.Text = O5num.ToString();
        }
        else
        {
            Label1.Text = "";
        }
        if (O5num1 != 0)
        {
            Label2.Text = O5num1.ToString();
        }
        else
        {
            Label2.Text = "";
        }
        if (O6num != 0)
        {
            Label3.Text = O6num.ToString();
        }
        else
        {
            Label3.Text = "";
        }
        if (O6num1 != 0)
        {
            Label4.Text = O6num1.ToString();
        }
        else
        {
            Label4.Text = "";
        }
        if (O7num != 0)
        {
            Label5.Text = O7num.ToString();
        }
        else
        {
            Label5.Text = "";
        }
        if (O7num1 != 0)
        {
            Label6.Text = O7num1.ToString();
        }
        else
        {
            Label6.Text = "";
        }
        if (O8num != 0)
        {
            Label7.Text = O8num.ToString();
        }
        else
        {
            Label7.Text = "";
        }
        if (O8num1 != 0)
        {
            Label8.Text = O8num1.ToString();
        }
        else
        {
            Label8.Text = "";
        }
        if (O9num != 0)
        {
            Label9.Text = O9num.ToString();
        }
        else
        {
            Label9.Text = "";
        }
        if (O9num1 != 0)
        {
            Label10.Text = O9num1.ToString();
        }
        else
        {
            Label10.Text = "";
        }
        if (O10num != 0)
        {
            Label11.Text = O10num.ToString();
        }
        else
        {
            Label11.Text = "";
        }
        if (O10num1 != 0)
        {
            Label12.Text = O10num1.ToString();
        }
        else
        {
            Label12.Text = "";
        }
        if (O11num != 0)
        {
            Label13.Text = O11num.ToString();
        }
        else
        {
            Label13.Text = "";
        }
        if (O11num1 != 0)
        {
            Label14.Text = O11num1.ToString();
        }
        else
        {
            Label14.Text = "";
        }
        if (O12num != 0)
        {
            Label15.Text = O12num.ToString();
        }
        else
        {
            Label15.Text = "";
        }
        if (O12num1 != 0)
        {
            Label16.Text = O12num1.ToString();
        }
        else
        {
            Label16.Text = "";
        }
        if (O13num != 0)
        {
            Label17.Text = O13num.ToString();
        }
        else
        {
            Label17.Text = "";
        }
        if (O13num1 != 0)
        {
            Label18.Text = O13num1.ToString();
        }
        else
        {
            Label18.Text = "";
        }
        if (O14num != 0)
        {
            Label19.Text = O14num.ToString();
        }
        else
        {
            Label19.Text = "";
        }
        if (O14num1 != 0)
        {
            Label20.Text = O14num1.ToString();
        }
        else
        {
            Label20.Text = "";
        }
        if (O15num != 0)
        {
            Label21.Text = O15num.ToString();
        }
        else
        {
            Label21.Text = "";
        }
        if (O15num1 != 0)
        {
            Label22.Text = O15num1.ToString();
        }
        else
        {
            Label22.Text = "";
        }
        Label35.Text = Label33.Text = num.ToString();
        Label37.Text = Label34.Text = num1.ToString();
        Label36.Text = num1.ToString();

        //Label36.Text = O16num1.ToString();
        //Label37.Text = O17num.ToString();
    }