取出新闻标题.内容.时间的代码!

      public newsModel SelectNew(string id)
      {
          newsModel nm = new newsModel();
          DataTable dt = new DataTable();
          string sql = "SelectNew";
          SqlParameter[] para = new SqlParameter[] {
          new SqlParameter("@id",id),
          };
          dt = sqlhelper.ExecuteQuery(sql,para,CommandType.StoredProcedure);
          nm.Id = id;
          nm.Title = dt.Rows[0]["title"].ToString();
          nm.Content = dt.Rows[0]["content"].ToString();
          nm.Createtime= dt.Rows[0]["createtime"].ToString();
          return nm;
      }

 

 

 

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            string newsid = Request.QueryString["newsid"];
            NewsBLL nb = new NewsBLL();
            newsModel nm = new NewsBLL().SelectNew(newsid);
            Lbltitle.Text = nm.Title;
            Lblcontent.Text = nm.Content;
            Lblcreatetime.Text = nm.Createtime;
        }
    }