index1.aspx.cs

来自「大中型酒店管理系统」· CS 代码 · 共 48 行

using System;
using System.Data;
using System.Data.SqlClient;
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 index1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = db.createconn();
        //这里是新闻
        SqlDataAdapter myAdapter = new SqlDataAdapter("select top 6 *  from news order by newsdate desc", conn);
        DataSet ds1 = new DataSet();
        myAdapter.Fill(ds1, "news");
        Repeaternews.DataSource = ds1;
        Repeaternews.DataMember = "news";
        Repeaternews.DataBind();
        //这里是留言
        SqlDataAdapter myAdapterl = new SqlDataAdapter("select top 2 *  from liuyan order by date1 desc", conn);
        DataSet ds2 = new DataSet();
        myAdapterl.Fill(ds2, "liuyan");
        liuyan.DataSource = ds2;
        liuyan.DataMember = "liuyan";
        liuyan.DataBind();
        //这里是厂家
        SqlDataAdapter myAdapter2 = new SqlDataAdapter("select top 2 *  from user1 order by u_date desc", conn);
        DataSet ds3 = new DataSet();
        myAdapter2.Fill(ds3, "user");
       shop.DataSource = ds3;
        shop.DataMember = "user";
        shop.DataBind();
        //这里是友情链接
        SqlDataAdapter myAdapter3 = new SqlDataAdapter("select top 2 *  from links order by id desc", conn);
        DataSet ds4 = new DataSet();
        myAdapter3.Fill(ds4, "links");
        links.DataSource = ds4;
        links.DataMember = "links";
        links.DataBind();
    }
}