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"); //重新定位到会员管理页 }
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"]); //重新定位到该页面 }