//最新资讯绑定
private void TheLatestInformationBind()
{
        DataTable dt = new Hotsales.EBDoor.Cache.BusinessFacade.CacheMarketingNewsSystem().SelectCacheInfoTopNewsRegionDataByFlag(4, 1);
string NewsPKId = dt.Rows[0]["NewsPKId"].ToString(); TheLatestInformationHotImg.ImageUrl = SiteConfig.DocsSite + dt.Rows[0]["ImageLinkUrl"].ToString();
TheLatestInformationHotLink.InnerText = dt.Rows[0]["NewsTitle"].ToString();
TheLatestInformationHotImg.ToolTip = dt.Rows[0]["NewsTitle"].ToString();
TheLatestInformationHotLink.HRef = RewriteVirtulUrl.BrowseMarketingNews(NewsPKId);        dt = new Hotsales.EBDoor.Cache.BusinessFacade.CacheMarketingNewsSystem().SelectCacheInfoTopNewsRegionDataByFlag(4, 2); TheLatestInformationRepeater.DataSource = dt;
TheLatestInformationRepeater.DataBind();
}这段代码是绑定一个repeater控件的..但是现在可能是数据库没有数据,  就报错!!在位置 0 处没有任何行。现在我要加个判断.就是没有数据的时候还是初夏你正常的页面,,不要报错,,,没数据就显示空数据!!那位大哥大姐帮帮忙!!!谢谢了!!>

解决方案 »

  1.   

    //最新资讯绑定
    private void TheLatestInformationBind()
    {
            DataTable dt = new Hotsales.EBDoor.Cache.BusinessFacade.CacheMarketingNewsSystem()
                .SelectCacheInfoTopNewsRegionDataByFlag(4, 1);
    string NewsPKId = dt.Rows[0]["NewsPKId"].ToString(); TheLatestInformationHotImg.ImageUrl = SiteConfig.DocsSite + dt.Rows[0]["ImageLinkUrl"].ToString();
    TheLatestInformationHotLink.InnerText = dt.Rows[0]["NewsTitle"].ToString();
    TheLatestInformationHotImg.ToolTip = dt.Rows[0]["NewsTitle"].ToString();
    TheLatestInformationHotLink.HRef = RewriteVirtulUrl.BrowseMarketingNews(NewsPKId);        dt = new Hotsales.EBDoor.Cache.BusinessFacade.CacheMarketingNewsSystem()
                .SelectCacheInfoTopNewsRegionDataByFlag(4, 2); TheLatestInformationRepeater.DataSource = dt;
    TheLatestInformationRepeater.DataBind();
    }
      

  2.   


      DataTable dt = new Hotsales.EBDoor.Cache.BusinessFacade.CacheMarketingNewsSystem().SelectCacheInfoTopNewsRegionDataByFlag(4, 1);
    if (dt.Rows.Count > 0)
    {
     string NewsPKId = dt.Rows[0]["NewsPKId"].ToString(); TheLatestInformationHotImg.ImageUrl = SiteConfig.DocsSite + dt.Rows[0]["ImageLinkUrl"].ToString();
     TheLatestInformationHotLink.InnerText = dt.Rows[0]["NewsTitle"].ToString();
     TheLatestInformationHotImg.ToolTip = dt.Rows[0]["NewsTitle"].ToString();
     TheLatestInformationHotLink.HRef = RewriteVirtulUrl.BrowseMarketingNews(NewsPKId);
    }
       dt = new Hotsales.EBDoor.Cache.BusinessFacade.CacheMarketingNewsSystem().SelectCacheInfoTopNewsRegionDataByFlag(4, 2); TheLatestInformationRepeater.DataSource = dt;
     TheLatestInformationRepeater.DataBind();
     }
      

  3.   

    private void TheLatestInformationBind()
    {
     DataTable dt = new Hotsales.EBDoor.Cache.BusinessFacade.CacheMarketingNewsSystem().SelectCacheInfoTopNewsRegionDataByFlag(4, 1);
    if(dt.Rows.Count>0)
    {
    string NewsPKId = dt.Rows[0]["NewsPKId"].ToString();TheLatestInformationHotImg.ImageUrl = SiteConfig.DocsSite + dt.Rows[0]["ImageLinkUrl"].ToString();
    TheLatestInformationHotLink.InnerText = dt.Rows[0]["NewsTitle"].ToString();
    TheLatestInformationHotImg.ToolTip = dt.Rows[0]["NewsTitle"].ToString();
    TheLatestInformationHotLink.HRef = RewriteVirtulUrl.BrowseMarketingNews(NewsPKId);  dt = new Hotsales.EBDoor.Cache.BusinessFacade.CacheMarketingNewsSystem().SelectCacheInfoTopNewsRegionDataByFlag(4, 2);TheLatestInformationRepeater.DataSource = dt;
    TheLatestInformationRepeater.DataBind();
    }
    }