Default.aspx.cs

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

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

namespace web
{
    public partial class Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                Page.Title = new access().ExecuteScalar("select sy_tit from wzinfo where id = 1").ToString(); ;
                this.Literal13.Text = "<meta name=\"keywords\" content=\"" + new access().ExecuteScalar("select sy_key from wzinfo where id=1").ToString() + "\" />";
                this.Literal14.Text = "<meta name=\"description\" content=\"" + new access().ExecuteScalar("select sy_contus from wzinfo where id=1").ToString() + "\" />";

                string gsname = new access().ExecuteScalar("select syms from wzinfo where id = 1");
                if (gsname == "1")
                {
                    this.Panel1.Visible = true;
                }
                else 
                {
                    this.Panel2.Visible = true;
                    using (DataTable dt = new access().ExecuteDataTable("select * from wzinfo where id = 1"))
                    {
                        this.Repeater3.DataSource = dt;
                        this.Repeater3.DataBind();
                    }
                }

                using (DataTable dt = new access().ExecuteDataTable("select top 5 * from merchandise where type_two_id in (select id from type_two where type_one_id = 1) order by px desc"))
                {
                    this.Repeater1.DataSource = dt;
                    this.Repeater1.DataBind();
                }
                using (DataTable dt = new access().ExecuteDataTable("select top 12 * from merchandise where type_two_id in (select id from type_two where type_one_id = 2) and iftj = 1 order by px desc"))
                {
                    this.Repeater2.DataSource = dt;
                    this.Repeater2.DataBind();
                }
            }
        }
    }
    
}