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();
}