index.aspx.cs

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

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

public partial class index : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindgonggao();
            bindpypx();
            bindjxj();
            bindbkjl();
            bindxw();
        }
    }
    protected void bindgonggao()
    {
        string sql;
        sql = "select top 5 * from 新闻 where 新闻类别='新闻' order by 发布日期 desc";//建立sql查询语句 
        this.Repeater2.DataSource = runsql.ExecuteDt(sql);
        this.Repeater2.DataBind();
    }
    protected void bindpypx()
    {
        string sql;
        sql = "select top 7 * from 评优评先 order by 学年 desc";//建立sql查询语句 
        this.Repeater1.DataSource = runsql.ExecuteDt(sql);
        this.Repeater1.DataBind();
    }

    protected void bindjxj()
    {
        string sql;
        sql = "select top 7 * from 奖学金信息表 order by 学期 desc";//建立sql查询语句 
        this.Repeater3.DataSource = runsql.ExecuteDt(sql);
        this.Repeater3.DataBind();
    }
    protected void bindbkjl()
    {
        string sql;
        sql = "select top 7 * from 补考记录 order by 开课学期 desc";//建立sql查询语句 
        this.Repeater4.DataSource = runsql.ExecuteDt(sql);
        this.Repeater4.DataBind();
    }
    protected void bindxw()
    {
        string sql;
        sql = "select top 7 * from 新闻 where 新闻类别='新闻' order by 发布日期 desc";//建立sql查询语句 
        this.Repeater5.DataSource = runsql.ExecuteDt(sql);
        this.Repeater5.DataBind();
    }
}