예제 #1
0
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            BBSDataContext lq   = new BBSDataContext(); //实例化LINQ类
            Users          user = new Users();          //创建一个新对象,

            user.uName     = txtuName.Text;             //并为相应的字段赋值
            user.uPwd      = txtuPwd.Text;
            user.uRealName = txtuRealName.Text;
            user.uSex      = rbluSex.SelectedValue;
            user.uAge      = Convert.ToInt16(txtuAge.Text);
            for (int i = 0; i < cbluHobby.Items.Count; i++)  //判断CheckBoxList控件中的每个选项是否被选中,
            {
                if (cbluHobby.Items[i].Selected)             //如果被选中,
                {
                    user.uHobby += cbluHobby.Items[i].Value; //将该项值加入到uHobby字段中
                }
            }
            user.uEmail   = txtuEmail.Text;
            user.uQQ      = txtuQQ.Text;
            user.uPhone   = txtuPhone.Text;
            user.uImage   = imguImage.ImageUrl.Substring(imguImage.ImageUrl.LastIndexOf("/") + 1);
            user.uRegTime = System.DateTime.Now;
            lq.Users.InsertOnSubmit(user);                    //执行插入数据操作
            lq.SubmitChanges();                               //提交数据库
            Response.Redirect("/UserManager/UserLogin.aspx"); //重新定位到会员管理页
        }
예제 #2
0
        protected void bnSubject_Click(object sender, EventArgs e)
        {
            BBSDataContext lq = new BBSDataContext(); //实例化LINQ类

            BBSAnswer ba = new BBSAnswer();           //创建一个新对象

            ba.uID       = Convert.ToInt32(Session["uID"]);
            ba.bnID      = Convert.ToInt32(Request["id"]);
            ba.baContent = txtbaContent.Text;
            ba.baAddTime = System.DateTime.Now;
            lq.BBSAnswer.InsertOnSubmit(ba);                             //执行插入数据操作
            lq.SubmitChanges();                                          //提交数据库
            Response.Redirect("BBSAnswerList.aspx?id=" + Request["id"]); //重新定位到该页面
        }