hczt/hc_index.aspx.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class hczt_hc_index : System.Web.UI.Page
{
    DataBase db = new DataBase();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindData();
        }

    }
    public void bindData()
    {
        
        //图片集锦
        string sqlstr = "select top 10 tid,imageUrl,title from tb_ZTImage";
        DataSet ds = new DataSet();
        ds = db.GetDataSet(sqlstr, ds);
        RptImage.DataSource = ds.Tables[0].DefaultView;
        RptImage.DataBind();
        //新闻头条
        DataSet ds1 = new DataSet();
        ds1 = db.GetDataSet("select top 1 * from tb_news where BigClass = 46 and SmallClass in (48,49) order by c_date", ds1);
        if (ds1.Tables[0].Rows.Count > 0)
        {
            HyperLink1.Text = ds1.Tables[0].Rows[0]["Title"].ToString();
            HyperLink1.Target = "_blank";
            HyperLink1.NavigateUrl = "hc_show.aspx?blmid=" + ds1.Tables[0].Rows[0]["BigClass"].ToString() + "&slmid=" + ds1.Tables[0].Rows[0]["SmallClass"].ToString() + "&infoid=" + ds1.Tables[0].Rows[0]["tid"].ToString() + "";
            lblIntro.Text = ds1.Tables[0].Rows[0]["Intro"].ToString();
            hlkShow.Target = "_blank";
            hlkShow.NavigateUrl = "hc_show.aspx?blmid=" + ds1.Tables[0].Rows[0]["BigClass"].ToString() + "&slmid=" + ds1.Tables[0].Rows[0]["SmallClass"].ToString() + "&infoid=" + ds1.Tables[0].Rows[0]["tid"].ToString() + "";
        }
        else
        {
            hlkShow.Visible = false;
        }
    }
}