linq查询全部.docVIP

linq查询全部 1,添加新项--》linq to sql类 2，打开服务资源管理器，连接数据库。选择表，拖进编辑区 3.ctrl+s保存 4.查看xx。designer.cs 5.在Default.aspx中，引入命名空间 using System.Linq; using System.Data.Linq;、 public DataClassesDataContext cxt = new DataClassesDataContext(); protected void setConnectionString() { cxt.Connection.ConnectionString = ConfigurationManager.ConnectionStrings[BookShopConnectionString].ConnectionString; } protected void Page_Load(object sender, EventArgs e) { setConnectionString(); var ss = from a in cxt.Categories select a; this.GridView1.DataSource = ss; this.DataBind(); var count = cxt.Categories.Count();//获取共有多少条数据 Label1.Text = count.ToString(); } 分页 var ss=(from a in cxt.Categories select a).Skip(1).Take(3); this.GridView1.DataSource = ss; this.DataBind(); 总页数 var Count=表名.Count();方法。 模糊查询 GridView1.DataSource = from a in cxt.Categories where a.Name.Contains(a) select a; GridView1.DataSource = from a in cxt.Categories where a.Name.StartsWith(a) select a; GridView1.DataBind(); 嵌套查询 GridView1.DataSource = from a in cxt.Categories where a.Id == (from b in cxt.Categories where b.Name == 其他 select b).Single().Id select a; GridView1.DataBind();（我们要完成一次数据的更新，至少要完成一次查询和一次更新。） 更新数据：var query = from emp in dbdata.Employees where emp.DepId==1001 select emp; Employee employee = query.First(); employee.EmployeeName = 李四; dbdata.SubmitChanges(); 添加表中的数据，要求此表必须有主键 protected void Button1_Click(object sender, EventArgs e) { test1 ss = new test1(); ss.id =Convert.ToInt32( TextBox1.Text); = TextBox1.Text; ctx.test1.InsertOnSubmit(ss); ctx.SubmitChanges(); GridView1.DataSource = from a in ctx.test1 select a; GridView1.DataBind(); } 删除数据 protected void Button2_Click(object sender, EventArgs e