Linq增删改查的关键代码
来源:互联网 发布:淘宝上门自提 编辑:程序博客网 时间:2024/06/05 06:28
private void DtBind()
{
ContarDataContext cdc = new ContarDataContext();
var RtData = from OneLine in cdc.ENTRY_CONTAINERs
select OneLine;
GridView1.DataSource = RtData;
GridView1.DataBind();
}
protected void Bt_Select_Click(object sender, EventArgs e)
{
ContarDataContext cdc = new ContarDataContext();
var RtData=from OneLine in cdc.ENTRY_CONTAINERs
orderby OneLine.CONTAINER_WT descending
select OneLine;
GridView1.DataSource = RtData;
GridView1.DataBind();
}
protected void Bt_Insert_Click(object sender, EventArgs e)
{
ContarDataContext db = new ContarDataContext();
ENTRY_CONTAINER E_C = new ENTRY_CONTAINER{CONTAINER_ID="aa",CONTAINER_WT=10,ENTRY_ID="1"};
db.ENTRY_CONTAINERs.InsertOnSubmit(E_C);
db.SubmitChanges();
DtBind();
}
protected void Bt_Update_Click(object sender, EventArgs e)
{
ContarDataContext db = new ContarDataContext();
ENTRY_CONTAINER E_C = db.ENTRY_CONTAINERs.First(p => p.ENTRY_ID.StartsWith("1"));
E_C.CONTAINER_WT += 6;
db.SubmitChanges();
DtBind();
}
protected void Bt_Del_Click(object sender, EventArgs e)
{
ContarDataContext db = new ContarDataContext();
ENTRY_CONTAINER E_C = db.ENTRY_CONTAINERs.First(p => p.ENTRY_ID.StartsWith("1"));
db.ENTRY_CONTAINERs.DeleteOnSubmit(E_C);
db.SubmitChanges();
DtBind();
}
{
ContarDataContext cdc = new ContarDataContext();
var RtData = from OneLine in cdc.ENTRY_CONTAINERs
select OneLine;
GridView1.DataSource = RtData;
GridView1.DataBind();
}
protected void Bt_Select_Click(object sender, EventArgs e)
{
ContarDataContext cdc = new ContarDataContext();
var RtData=from OneLine in cdc.ENTRY_CONTAINERs
orderby OneLine.CONTAINER_WT descending
select OneLine;
GridView1.DataSource = RtData;
GridView1.DataBind();
}
protected void Bt_Insert_Click(object sender, EventArgs e)
{
ContarDataContext db = new ContarDataContext();
ENTRY_CONTAINER E_C = new ENTRY_CONTAINER{CONTAINER_ID="aa",CONTAINER_WT=10,ENTRY_ID="1"};
db.ENTRY_CONTAINERs.InsertOnSubmit(E_C);
db.SubmitChanges();
DtBind();
}
protected void Bt_Update_Click(object sender, EventArgs e)
{
ContarDataContext db = new ContarDataContext();
ENTRY_CONTAINER E_C = db.ENTRY_CONTAINERs.First(p => p.ENTRY_ID.StartsWith("1"));
E_C.CONTAINER_WT += 6;
db.SubmitChanges();
DtBind();
}
protected void Bt_Del_Click(object sender, EventArgs e)
{
ContarDataContext db = new ContarDataContext();
ENTRY_CONTAINER E_C = db.ENTRY_CONTAINERs.First(p => p.ENTRY_ID.StartsWith("1"));
db.ENTRY_CONTAINERs.DeleteOnSubmit(E_C);
db.SubmitChanges();
DtBind();
}
- Linq增删改查的关键代码
- Linq的增删改查
- LinQ To Entity的增删改查
- LinQ To Entity的增删改查
- LinQ To Entity的增删改查
- LinQ To Entity的增删改查
- LINQ之增删改查
- Linq对XML文件的增删改查
- LINQ to XML实现XML文档的增删改查
- Linq To Entity 的增删改查(转)
- LINQ增删改代码示例
- SQLite数据库的增删改查代码
- Hive的基本增删改查代码
- ORM, Linq to sql增删改查
- Linq to sql增删改查
- Linq实现增删改查详解
- LINQ to SQL之增删改查
- Linq增删改查语法大全
- Unix command
- ORACLE索引与高性能SQL介绍
- 掩码文本框
- VC中Combo Box控件使用大全
- 各种地图投影的特点及分带方法
- Linq增删改查的关键代码
- 西游记(3)
- uniqueidentifier数据类型详解
- 将vs2008 项目 转换成到2005 下的解决方案
- Delphi菜单中没有的快捷键
- ENVI和ERDAS中自定义坐标系的方法(转载)
- Hibernate之中inverse与cascade的异同
- 如果shell里面的date不能满足需要的话,用perl吧
- 内嵌类&this指针使用