protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataList4.DataSource = data.GetDataReader("select * from Musictype"); DataList4.DataBind(); DataList6.DataSource = data.GetDataReader("select * from Singer"); DataList6.DataBind(); DataList5.DataSource = data.GetDataReader("select * from Album"); DataList5.DataBind(); Datalist3.DataSource = data.GetDataReader("select top 8 * from News"); Datalist3.DataBind(); DataList1.DataSource = data.GetDataReader("select top 6 * from Music where IsCheck='1' order by id desc "); DataList1.DataBind(); DataList2.DataSource = data.GetDataReader("select top 6 * from Music where IsCheck='1' order by clk desc "); DataList2.DataBind(); if (Session["users"] != null) { table2.Visible = true; TABLE1.Visible = false; MName.Text = Session["users"].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataList1.DataSource = data.GetDataReader("select top 4 * from shangping order by shangpingid desc "); DataList1.DataBind(); Datalist2.DataSource = data.GetDataReader(" select top 4 shangpingid,shangpingname,chushouprice,pic from shangping where fenleiid = 3 order by shangpingid desc "); Datalist2.DataBind(); Datalist3.DataSource = data.GetDataReader(" select top 4 shangpingid,shangpingname,chushouprice,pic from shangping where fenleiid = 4 order by shangpingid desc "); Datalist3.DataBind(); } }