Esempio n. 1
0
    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");
    }
Esempio n. 2
0
 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();
     }
 }
Esempio n. 3
0
    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();
        }
    }