protected void Page_Load(object sender, EventArgs e) { DreamWarDataContext dw = new DreamWarDataContext(); if (!IsPostBack) { } }
protected void Bind() { DreamWarDataContext dw = new DreamWarDataContext(); var results = from c in dw.User select c; gvUsers.DataSource = results; gvUsers.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { DreamWarDataContext dw = new DreamWarDataContext(); User info = new User(); info.UserName = txtInput.Text; info.Password = txtPassword.Text; dw.User.InsertOnSubmit(info); dw.SubmitChanges(); Response.Redirect("UserList.aspx"); }
protected void Delete_Click(object sender, EventArgs e) { DreamWarDataContext dw = new DreamWarDataContext(); var result = from c in dw.User where c.UserName == txtInput.Text select c; dw.User.DeleteAllOnSubmit(result); dw.SubmitChanges(); Bind(); }
protected void Unnamed_ServerClick(object sender, EventArgs e) { DreamWarDataContext dw = new DreamWarDataContext(ConfigurationManager.ConnectionStrings["DreamWarConnectionString"].ToString()); string username = this.UserName.Value.Trim(); string txtArea = this.textArea.Value.Trim(); table info = new table(); info.Username = username; info.Message = txtArea; dw.table.InsertOnSubmit(info); dw.SubmitChanges(); }
protected void BtnSubmit_ServerClick(object sender, EventArgs e) { string newpass = this.txtChange.Value.Trim(); DreamWarDataContext dw = new DreamWarDataContext(ConfigurationManager.ConnectionStrings["DreamWarConnectionString"].ToString()); User info = new User(); var result1 = from u in dw.User where u.UserName == Session["UserName"].ToString() select u; foreach (User s in result1) { s.Password = newpass; } dw.SubmitChanges(); Response.Redirect("~/Login.aspx"); }
protected void Unnamed_ServerClick(object sender, EventArgs e) { DreamWarDataContext dw = new DreamWarDataContext(); string name = this.txtName.Value.Trim(); string pwd = this.txtPassword.Value.Trim(); String infro = this.txtInfromation.Value.Trim(); string sex = Request.Form["sex"]; Writers info = new Writers(); info.WriterName = name; info.Password = pwd; info.Information = infro; dw.Writers.InsertOnSubmit(info); dw.SubmitChanges(); Response.Redirect("~/HomePage.aspx"); }
protected void btn_submit_ServerClick(object sender, EventArgs e) { DreamWarDataContext dw = new DreamWarDataContext(ConfigurationManager.ConnectionStrings["DreamWarConnectionString"].ToString()); string name = this.txtUserName.Value.Trim(); string pass = this.txtPassword.Value.Trim(); string conpass = this.txtConfirmation.Value.Trim(); if (pass == conpass) { Session["UserName"] = this.txtUserName.Value; Session["UserPwd"] = this.txtPassword.Value; User info = new User(); info.UserName = name; info.Password = pass; dw.User.InsertOnSubmit(info); dw.SubmitChanges(); Response.Redirect("~/HomePage.aspx"); } }
protected void submit_ServerClick(object sender, EventArgs e) { string name = this.txtUserName.Value.Trim(); string pwe = this.txtpPssword.Value.Trim(); DreamWarDataContext dw = new DreamWarDataContext(); var result = from v in dw.User where v.UserName == name && v.Password == pwe select v; if (result.Count() > 0) { Session["UserName"] = this.txtUserName.Value; Session["UserPwd"] = this.txtpPssword.Value; Response.Redirect("~/HomePage.aspx"); } else { Response.Write("<script> alter(Login Failture!); location='javascript:history.go(-1)'</script>"); } }