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();
}
}
