protected void Button1_Click(object sender, EventArgs e) { ECDBDataContext db = new ECDBDataContext(); News news = new News(); news.Title = txtTitle.Text; news.Content = txtContent.Text; db.News.InsertOnSubmit(news); db.SubmitChanges(); Response.Redirect("~/Admin/Newsmanage.aspx"); }
protected void Bind() { if (Request.QueryString["SearchText"] != null) { string strSearchText = Request.QueryString["SearchText"].ToString(); ECDBDataContext db = new ECDBDataContext(); var news = from p in db.News where SqlMethods.Like(p.Title, "%" + strSearchText.Trim() + "%") select p; gvNews.DataSource = news; gvNews.DataBind(); } }
protected void Bind() { ECDBDataContext db = new ECDBDataContext(); if (Request.QueryString["NewId"] != null) { int newsid = int.Parse(Request.QueryString["NewsId"]); var results = from p in db.News where p.NewsId == newsid select p; DataList1.DataSource = results; DataList1.DataBind(); } }