前台直接访问数据库,DataList的数据绑定

前台直接访问数据库.把全部数据取出来就可以.我个人比较喜欢这种方法.很简单.

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            listbind();

            listbind2();

            //listbind3();
        }
    }
    /// <summary>
    /// DataList1的列表
    /// </summary>
    protected void listbind()
    {
        string MenuSQL = "select MenuID,MenuName,MenuUnit,MenuPrice,MenuDesc,OriPrice from wx_bu_Menu";
        //重构之后的代码调用
        PublicDataListBase.ShowDataList(DataList1, MenuSQL);
    }

    /// <summary>
    /// DataList2的列表
    /// </summary>
    protected void listbind2()
    {
        string ClassSql = "select ClassName from wx_bu_Class";
        //重构之后的代码调用
        PublicDataListBase.ShowDataList(DataList2, ClassSql);
    }

<asp:DataList ID="DataList2" runat="server" RepeatColumns="1" HorizontalAlign="Justify" RepeatDirection="Horizontal" >
                    <ItemTemplate><a href="index1.html"><li><%# Eval("ClassName")%></li></a></ItemTemplate>
                    </asp:DataList>
                </ul>
                <div class="blank25">
                </div>
            </div>
            <div id="page_right_contents">
                <div id="products" class="container">
                <asp:DataList ID="DataList1" runat="server" Height="354px" RepeatColumns="1" HorizontalAlign="Justify" RepeatDirection="Horizontal" Width="1355px">
                     <ItemTemplate>
                      <div class="item">
                            <div class="img">
                                <img src="UpLoadCaiPinImages/<%# Eval("MenuID")%>.jpg" onclick="ShowDiv(‘MyDiv‘,‘fade‘)" alt="gxlsystem.com,布布扣" id="code_img_closed_a8388c14-640e-4052-bd45-d1900a1b8559" 
class="code_img_closed"  src="/uploadfile/Uploads/news/20220310/6229bd8457a95.gif">View Code
 
前台直接访问数据库,DataList的数据绑定,布布扣,bubuko.com