ASPNET服务端控件练习(一个机试题)

        public List GetWhereStudent(string name, string sub, string isG)
        {
            List lt = new List();
            string sql = "select * from SC_Student where studentName like @n and Subjects=@sub and IsGoodStudent=@is";
            SqlParameter[] param = { 
             new SqlParameter("@n","%"+name+"%"),
             new SqlParameter("@sub",sub),
             new SqlParameter("@is",isG)};
            using (SqlDataReader reader = SqlHelper.ExecuteDataReader(sql, param))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Web.Model.Student stu = new Model.Student();
                        stu.ID = reader.GetInt32(0);
                        stu.Name = reader.GetString(1);
                        stu.SubId = this.GetSubName(reader.GetInt32(2));
                        stu.Score = reader.GetInt32(3);
                        stu.IsGoodStudent = reader.GetBoolean(4);
                        lt.Add(stu);
                    }
                }
            }
            return lt;
        }

        public List EditStudent(string name, string sco)
        {
            List lst = new List();
            int s = 0;
            SqlParameter[] param = 
            { 
                         new SqlParameter("@likes","%"+name+"%"),
                         new SqlParameter("@sco",int.TryParse(sco,out s)==true?s:0)
                                   };
            using (SqlDataReader reader = SqlHelper.ExecuteProcedure("pro_Student_Avg", param))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Web.Model.StudentAvg stuavg = new Model.StudentAvg();
                        //拿取 ROW_NUMBER() over(order by studentName)产生的值
                        stuavg.ID = int.Parse(reader.GetSqlValue(0).ToString());
                        stuavg.Name = reader.GetString(1);
                        stuavg.SSum = reader.GetInt32(2);
                        stuavg.SAvg = reader.GetInt32(3);
                        lst.Add(stuavg);
                    }
                }
            }
            return lst;
        }

    protected void Page_Load(object sender, EventArgs e)
    {
        this.ObjectDataSource1.SelectParameters.Clear();
        this.ObjectDataSource1.SelectParameters.Add("name", "");
        this.ObjectDataSource1.SelectParameters.Add("sco", "0");
        this.ObjectDataSource1.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.ObjectDataSource1.SelectParameters.Clear();
        string name = this.txtName.Text;
        string sco = this.txtSco.Text;
        this.ObjectDataSource1.SelectParameters.Add("name", name);
        this.ObjectDataSource1.SelectParameters.Add("sco", sco);
        //Web.BLL.Tran tran = new Web.BLL.Tran();
        //List lst = tran.GetStudentAvg(name, sco);
        this.ObjectDataSource1.DataBind();
    }

    protected void Unnamed_Click(object sender, EventArgs e)
    {
        //还原 参数
        this.ObjectDataSource1.SelectParameters.Clear();
        LinkButton lb = ((LinkButton)sender);
        if (lb.CommandArgument != "")
        {
            if (true)//YEs No 对话框
            {
                string id = lb.CommandArgument;

                Web.BLL.Tran tran = new Web.BLL.Tran();
                if (tran.SetGood(int.Parse(id)) == 1)
                {
                    this.Repeater1.DataBind();
                }
            }

        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.ObjectDataSource1.SelectParameters.Clear();
        this.ObjectDataSource1.SelectParameters.Add("name", this.txtSName.Text);
        this.ObjectDataSource1.SelectParameters.Add("sub", this.DropDownList1.SelectedIndex + 1.ToString());
        this.ObjectDataSource1.SelectParameters.Add("isG", this.CheckBox1.Checked == true ? "1" : "0");
        this.ObjectDataSource1.SelectMethod = "GetWhereStudent";
        this.ObjectDataSource1.DataBind();
        //this.Page.DataBind();
        //this.ObjectDataSource1.SelectMethod = "GetWhereStudent";
    }

        function DelRow() {
            var ta = document.getElementById("lst");
            var len=ta.rows.length;
            for (var i = 1; i ) {
                var ro = ta.rows.item(i);
                if (ro.childNodes[0].innerHTML = arguments[0]) {
                    ta.deleteRow(i);
                    return;
                }
            }
        };

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string id = Request.QueryString["id"];
            if (id != null)
            {
                //this.ObjectDataSource1.SelectParameters.Add("id", id);
                this.ObjectDataSource1.SelectParameters[0].DefaultValue = id;
                this.ObjectDataSource1.DataBind();
            }
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Web.BLL.Tran tran = new Web.BLL.Tran();
        string id = ((TextBox)this.ListView1.Items[0].Controls[1]).Text;
        string name = ((TextBox)this.ListView1.Items[0].Controls[3]).Text;
        string sub = ((TextBox)this.ListView1.Items[0].Controls[5]).Attributes["MySubID"];
        string sco = ((TextBox)this.ListView1.Items[0].Controls[7]).Text;
        bool isG = ((CheckBox)this.ListView1.Items[0].Controls[9]).Checked;
        if (1 == tran.EditStudent(id, name, sub, sco, isG))
        {
            this.ObjectDataSource1.DataBind();
            Response.Redirect("Manage_Student.aspx");
        }
    }

            

"text" name="txtName" />
                
                    "server" ID="scoName" DataSourceID="ObjectDataSource1" DataTextField="StuId" DataValueField="Id">
                    

                
"text" name="txtSco" />
                
                    "" runat="server" ID="IsGoodStudent" />

            

        bool isGS = this.IsGoodStudent.Checked;