zhuti.ascx.cs

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

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


public partial class zhuti : System.Web.UI.UserControl
{
    SqlHelper data = new SqlHelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            binddatalist();//显示类别
            binddrv();//显示新闻
        }
    }
    //显示类别
    private void binddatalist()
    {
        DataSet ds = data.GetDs("select * from  NovelType  order by id desc  ", "NovelType");//取新闻
        DataList1.DataSource = ds.Tables[0].DefaultView;
        DataList1.DataBind();
    }
    //显示当前类别下新闻
    private void binddrv()
    {
        foreach (DataListItem item in DataList1.Items)
        {
            int dalei = Int32.Parse(DataList1.DataKeys[item.ItemIndex].ToString());//取类别ID
            GridView gw = (GridView)item.FindControl("grv");
            DataSet ds = getnewsshow(dalei, 6);//按类别ID显示新闻
            gw.DataSource = ds.Tables[0].DefaultView;
            gw.DataBind();
        }
    }

    public DataSet getnewsshow(int leibie, int count)
    {

        DataSet ds = data.GetDs("select top " + count + " * from Novel where Typeid=" + leibie + " order by Addtime desc", "Novel");
        return ds;
    }
    //限制字数
    protected string myroad(string road)
    {
        if (road.Length > 20)//如果字数大于20个，则截取
        {
            road = road.Substring(0, 20);
        }
        return road;
    }
}