bht.ascx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class bht : System.Web.UI.UserControl
{
    public string sql, ncontent;
    public string npic1, nlink1, ntext1, npic2, nlink2, ntext2, npic3, nlink3, ntext3, npic4, nlink4, ntext4, npic5, nlink5, ntext5;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            sql = "select top 5 id,title,shouyetupian from allgonggao where shouyetupian<>'' order by id desc";
            getsyt(sql);
        }
    }
    private void getsyt(string sql)
    {
        DataSet result = new DataSet();
        result = new Class1().hsggetdata(sql);
        if (result != null)
        {
            if (result.Tables[0].Rows.Count > 0)
            {

                npic1 = result.Tables[0].Rows[0]["shouyetupian"].ToString().Trim();
                nlink1 = "ggdetail.aspx?id=" + result.Tables[0].Rows[0]["id"].ToString().Trim();
                ntext1 = result.Tables[0].Rows[0]["title"].ToString().Trim();

                npic2 = result.Tables[0].Rows[1]["shouyetupian"].ToString().Trim();
                nlink2 = "ggdetail.aspx?id=" + result.Tables[0].Rows[1]["id"].ToString().Trim();
                ntext2 = result.Tables[0].Rows[1]["title"].ToString().Trim();

                npic3 = result.Tables[0].Rows[2]["shouyetupian"].ToString().Trim();
                nlink3 = "ggdetail.aspx?id=" + result.Tables[0].Rows[2]["id"].ToString().Trim();
                ntext3 = result.Tables[0].Rows[2]["title"].ToString().Trim();

                npic4 = result.Tables[0].Rows[3]["shouyetupian"].ToString().Trim();
                nlink4 = "ggdetail.aspx?id=" + result.Tables[0].Rows[3]["id"].ToString().Trim();
                ntext4 = result.Tables[0].Rows[3]["title"].ToString().Trim();

                npic5 = result.Tables[0].Rows[4]["shouyetupian"].ToString().Trim();
                nlink5 = "ggdetail.aspx?id=" + result.Tables[0].Rows[4]["id"].ToString().Trim();
                ntext5 = result.Tables[0].Rows[4]["title"].ToString().Trim();
            }
        }
    }
}