Web/UserControl/top.ascx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Model;
using Bll;
using System.Data;
using Dal;

namespace Web.UserControl
{
    public partial class top : System.Web.UI.UserControl
    {
        protected string value;
        BBanner objbb = new BBanner();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {

            }
        }
        /// <summary>
        /// 获取最新图片
        /// </summary>
        /// <returns></returns>
        public string ImagesNames()
        {
            string sql = " select top 5 N_Id,N_SortId,N_Name,N_Name2,N_Date,N_Order,N_Key,N_Click,N_Show,N_Special,N_Url,N_Pic,N_Pic2,N_Memo,N_Content,N_Title,N_Keywords,N_Description from Banner where N_SortId=1";
            value = "";
            DataSet ds = OLEDBHelper.Query(sql);          
            if (ds.Tables[0].Rows.Count >0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    if (ds.Tables[0].Rows.Count == (i+1))
                    {
                        value += "/images/Banner_small/"+ds.Tables[0].Rows[i]["N_Pic"].ToString();
                    }
                    else
                    {

                        value += "/images/Banner_small/"+ds.Tables[0].Rows[i]["N_Pic"].ToString()+"|";
                    }
              
                }



            }

            return value;
        }
    }
}