private void GetRoles() { LinQDBDataContext linqDB = new LinQDBDataContext(); this.rdlRole.DataSource = linqDB.Role.ToList <Role>().Distinct(); this.rdlRole.DataTextField = "RoleName"; this.rdlRole.DataValueField = "RoleID"; this.rdlRole.DataBind(); this.rdlRole.Items[0].Selected = true; }
private void BinderToGridView() { //获取DataContext--获取映射文件--当我们对DB进行对象操作的时候,自动生成相对应的SQL语句 LinQDBDataContext linqDB = new LinQDBDataContext(); var result = linqDB.User; //要实现分页处理 this.GridView1.DataSource = result; this.GridView1.DataBind(); }
private void BinderToGridView(int pageIndex, int pageSize) { //获取DataContext--获取映射文件--当我们对DB进行对象操作的时候,自动生成相对应的SQL语句 LinQDBDataContext linqDB = new LinQDBDataContext(); var result = linqDB.User; int pageTotal = (result.Count() + pageSize - 1) / pageSize; this.DropDownList1.DataSource = (System.Linq.Enumerable.Range(1, pageTotal)).ToList <int>(); this.DropDownList1.DataBind(); //要实现分页处理--跳过(pageIndex-1)*pageSize条记录,然后提取pageSize条记录 this.GridView1.DataSource = result.Skip((pageIndex - 1) * pageSize).Take(pageSize); this.GridView1.DataBind(); }
protected void btnDelete_Click(object sender, EventArgs e) { //是否已经存在 LinQDBDataContext linqDB = new LinQDBDataContext(); int i = linqDB.User.Where(p => this.txtName.Text == p.UserName).Count(); if (i > 0) { User u = linqDB.User.Where(p => p.UserName == this.txtName.Text).Single(); linqDB.User.DeleteOnSubmit(u); //更新对象 linqDB.SubmitChanges(); } else { Response.Write("<script language=javascript>window.alert('该用户已经存在')</script>"); return; } }
protected void btnUpdate_Click(object sender, EventArgs e) { //是否已经存在 LinQDBDataContext linqDB = new LinQDBDataContext(); int i = linqDB.User.Where(p => this.txtName.Text == p.UserName).Count(); if (i > 0) { User u = linqDB.User.Where(p => p.UserName == this.txtName.Text).Single(); u.UserPassword = this.txtPwd.Text; u.RoleID = int.Parse(this.rdlRole.SelectedValue.ToString()); //更新对象 linqDB.SubmitChanges(); } else { Response.Write("<script language=javascript>window.alert('该用户已经存在')</script>"); return; } }
protected void btnRegister_Click(object sender, EventArgs e) { //是否已经存在 LinQDBDataContext linqDB = new LinQDBDataContext(); int i = linqDB.User.Where(p => this.txtName.Text == p.UserName).Count(); if (i > 0) { Response.Write("<script language=javascript>window.alert('该用户已经存在')</script>"); return; } //注册用户 //OR映射实现注册 //将需要保存的信息封装在对象内部,然后OR映射将对象转化为SQL语句 User u = new User(); u.UserName = this.txtName.Text; u.UserPassword = this.txtPwd.Text; u.RoleID = int.Parse(this.rdlRole.SelectedValue.ToString()); //在容器中添加一个新对象 linqDB.User.InsertOnSubmit(u); //更新到数据库 linqDB.SubmitChanges(); }