Exemplo n.º 1
0
    public void load()
    {
        string sql = "select top 9 * from news  ";

        dt = DbHelperSQL.Query(sql).Tables[0];
        if (Session["_username"] != null)
        {
            string aa = " 欢迎您光临秋哈购物网!!";
            welcome.Text = Session["_username"].ToString() + aa.ToString() + "   ";
        }
        string  str = "select top 7 * from news order by _id desc  ";
        DataSet ds  = DB.dataSet(str);

        Repeater1.DataSource = ds.Tables[0];
        Repeater1.DataBind();

        int     id      = 2;
        BLLhelp bllhelp = new BLLhelp();
        DataSet ds1     = bllhelp.cj_ds(id);

        Repeater2.DataSource = ds1;
        Repeater2.DataBind();

        int     id1 = 26;
        DataSet ds2 = bllhelp._selectAll(id1);

        Re_xs.DataSource = ds2;
        Re_xs.DataBind();

        int     id2 = 19;
        DataSet ds3 = bllhelp._selectAll(id2);

        Re_ps.DataSource = ds3;
        Re_ps.DataBind();

        int     id3 = 20;
        DataSet ds4 = bllhelp._selectAll(id3);

        Re_fw.DataSource = ds4;
        Re_fw.DataBind();

        int     id4 = 25;
        DataSet ds5 = bllhelp._selectAll(id4);

        Re_huiy.DataSource = ds5;
        Re_huiy.DataBind();
    }