list view bound nettier datasource

来源：互联网发布：数据库checkpoint 编辑：程序博客网时间：2024/05/22 15:50

<asp:ListView runat="server" ID="smsLog" DataSourceID="SmsOutboundDataSource1" DataKeyNames="SmsOutboundId">            <LayoutTemplate>                <div class="table-box">                    <table class="data" width="100%" border="0" cellpadding="0" cellspacing="0">                        <tbody>                            <tr>                                <%--<td width="20%" class="heading-box">                                    API ID                                </td>                                <td width="20%" class="heading-box">                                    External ID                                </td>--%>                                <td width="20%" class="heading-box">                                    To                                </td>                                <td width="20%" class="heading-box">                                    Text                                </td>                                <td width="20%" class="heading-box">                                    Date Sent                                </td>                                <td width="20%" class="heading-box">                                    Delivery Date                                </td>                                <td width="20%" class="heading-box">                                    Is Delivered                                </td>                                <td width="20%" class="heading-box">                                    Date To Send                                </td>                                <td width="20%" class="heading-box">                                    State                                </td>                            </tr>                            <asp:Literal ID="itemPlaceholder" runat="server"></asp:Literal>                        </tbody>                    </table>                </div>                <p>                    <uc1:ucDataPager ID="ucDataPager1" runat="server" PagedControlID="smsLog"                        PageSize="10" />                </p>            </LayoutTemplate>            <ItemTemplate>                <tr>                    <%--<td class="rowgray" width="20%">                        <%# Eval("ApiId") %>                    </td>--%>                    <%--<td class="rowgray" width="20%">                        <%# Eval("ExternalId")%>                    </td>--%>                    <td class="rowgray" width="20%">                        <%# Eval("toNumber") %>                    </td>                    <td class="rowgray" width="20%">                        <%# Eval("text")%>                    </td>                    <td class="rowgray" width="20%">                        <%# Eval("dateSent") %>                    </td>                    <td class="rowgray" width="20%">                        <%# Eval("DeliveryDate")%>                    </td>                    <td class="rowgray" width="20%">                        <%# Eval("IsDelivered")%>                    </td>                    <td class="rowgray" width="20%">                        <%# Eval("DateToSend")%>                    </td>                    <td class="rowgray" width="20%">                        <%# Eval("State")%>                    </td>                </tr>            </ItemTemplate>            <EmptyDataTemplate>                <em>No SMS found</em>            </EmptyDataTemplate>        </asp:ListView><data:SmsOutboundDataSource ID="SmsOutboundDataSource1" runat="server" SelectMethod="GetPaged"><Parameters>        <data:SqlParameter Name="WhereClause" UseParameterizedFilters="false" DefaultValue="1=0">            <Filters>                <%--<data:LotteryDrawFilter Column="id" DefaultValue="2" />--%>                <%--<data:LotteryDrawFilter Column="DrawDate" DefaultValue='<%= DateTime.Now.ToString() %>' />--%>                <data:SmsOutboundExpressionBuilder  BuilderExpression="AppendLike" Column="Text" SessionField="SmsTicketCode" /> // SmsTicketCode = %xode%                <%--<data:LotteryDrawFilter Column="DrawDate" OnApplyFilter="DrawDate_ApplyFilter" />--%>                <%--<data:LotteryDrawFilter Column="LotteryId" PropertyName="Value" ControlID="hdnLotteryId" FilterType="Phrase" />--%>               <%-- <data:LotteryDrawFilter Column="LotteryId" OnApplyFilter="LotteryId_ApplyFilter"/>--%>            </Filters>        </data:SqlParameter>        <data:CustomParameter Name="OrderBy" Value="date_sent desc" />    </Parameters></data:SmsOutboundDataSource>

Sort

<asp:ListView ID="ProductList" runat="server" DataSourceID="ProductDataSource">   <LayoutTemplate>      <h3>Product Listing</h3>      [<asp:LinkButton runat="server" ID="SortByName" CommandName="Sort"                     CommandArgument="ProductName">Sort by Name</asp:LinkButton>]      | [<asp:LinkButton runat="server" ID="SortByPrice" CommandName="Sort"                     CommandArgument="UnitPrice">Sort by Price</asp:LinkButton>]   </LayoutTemplate>   ...</asp:ListView>