Linq的技术太强大了分享一下（linq to sql 的插入、更新、查询、删除）

最新推荐文章于 2024-09-15 17:50:36 发布

liushihua

最新推荐文章于 2024-09-15 17:50:36 发布

阅读量626

点赞数

文章标签： linq sql textbox string

Linq的技术太强大了分享一下

linq to sql 的插入、更新、查询、删除

----------绑定

private void BindGuestBook()
    {
        this.rpt_Message.DataSource = from gb in ctx.GuestBook orderby gb.PostTime descending select gb;
        rpt_Message.DataBind();
    }

---------------------;//模糊查询

string searchText="%"+TextBox1.Text.Trim()+"%";
var searcht = from gbs in ctx.GuestBook where SqlMethods.Like(gbs.Message,searchText) select gbs
GridView1.DataSource=from gbs in ctx.GuestBook where SqlMethods.Like(gbs.Message,searchText) select gbs;//模糊查询
GridView1.DataBind();

----------插入

        GuestBook gb = new GuestBook();
        ctx.GuestBook.InsertOnSubmit(gb);
        gb.UserName = tb_UserName.Text;
        gb.Message = tb_Message.Text;
        gb.IsReplied = false;
        gb.PostTime = DateTime.Now;
        ctx.SubmitChanges();

-------------删除

if (e.CommandName == "DeleteMessage")
        {
            GuestBook gb =gbdc.GuestBook.Single(b=>b.ID==id);
            gbdc.GuestBook.DeleteOnSubmit(gb);
            gbdc.SubmitChanges();
            BindGuestBook();
        }

-------------更新
        if (e.CommandName == "SendReply")
        {
            //GuestBook gb = ctx.GuestBook.Single(b=>b.ID == id);//第一次更新数据时用single
            GuestBook gb = gbdc.GuestBook.First(b=> b.ID == id);//更新现有数据时用
            gb.IsReplied = true;
            gb.Reply=((TextBox)e.Item.FindControl("tb_Reply")).Text;

            gbdc.SubmitChanges();
            BindGuestBook();
        }