datareader

来源：互联网发布：仙侠学院2 网络电影编辑：程序博客网时间：2024/04/19 19:21

private void BindData()
  {
   int ArticleID = Int32.Parse(Request.QueryString["ArticleID"].ToString());
   string SqlStr = "select Title,ViceTitle,TitleImage,ArtSource,ArtContent,ReadCount,PostTime from Article where ArticleID = @ArticleID";
   string SqlUpdate = "Update Article set ReadCount=ReadCount+1 where ArticleID=@ArticleID";

   SqlParameter pArticleID = new SqlParameter("@ArticleID",SqlDbType.Int,4);
   pArticleID.Value = ArticleID;
   SqlParameter[] parms = new SqlParameter[]
   {
    pArticleID
   };
   try
   {
    SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.CONN_STRING,CommandType.Text,SqlStr,parms);
    while(dr.Read())
    {
     Lb_Title.Text = dr["Title"].ToString();

     if(dr["ArtSource"].ToString().Length>0)
      Lb_ArtSource.Text = "来源：" + dr["ArtSource"].ToString();
     else
      Lb_ArtSource.Visible = false;

     if(dr["TitleImage"].ToString().Trim() !="" )
     {
      Image1.ImageUrl = dr["TitleImage"].ToString();
     }
     else
     {
      Image1.Visible = false;
     }

     try
     {
      Lb_PostTime.Text = "发布时间：" + Convert.ToDateTime(dr["PostTime"].ToString()).ToShortDateString();
     }
     catch
     {
      Lb_PostTime.Text = "";
     }

     Lb_ReadCount.Text = "浏览次数：" + Convert.ToString(Int32.Parse(dr["ReadCount"].ToString().Length==0?"0":dr["ReadCount"].ToString())+1) + "次";
     Lb_Content.Text = dr["ArtContent"].ToString();
    }
    dr.Close();
    SQLHelper.ExecuteNonQuery(SQLHelper.CONN_STRING,CommandType.Text,SqlUpdate,parms);
   }
   catch(Exception ex)
   {
    throw new Exception(ex.Message);
   }
  }