ListView

最新推荐文章于 2023-09-22 14:56:31 发布

a284447396

最新推荐文章于 2023-09-22 14:56:31 发布

阅读量237

点赞数

文章标签： listview server asp button delete textbox

本文链接：https://blog.csdn.net/a284447396/article/details/6508934

版权

<asp:ListView ID="ListView1" runat="server" DataKeyNames="ProductID"
      DataSourceID="SqlDataSource1"
      EnableViewState="False" onitemdatabound="ListView1_ItemDataBound"
      InsertItemPosition="LastItem" onitemcreated="ListView1_ItemCreated">
      <ItemTemplate>
         <tr style="">
            <td>
                  <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
                  <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
            </td>
            <td>
                  <asp:Label ID="ProductIDLabel" runat="server" Text='<%# Eval("ProductID") %>' />
            </td>
            <td>
                  <asp:Label ID="ProductNameLabel" runat="server" Text='<%# Eval("ProductName") %>' />
            </td>
         </tr>
      </ItemTemplate>
      <AlternatingItemTemplate>
         <tr style="">
            <td>
                  <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
                  <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
            </td>
            <td>
                  <asp:Label ID="ProductIDLabel" runat="server" Text='<%# Eval("ProductID") %>' />
            </td>
            <td>
                  <asp:Label ID="ProductNameLabel" runat="server" Text='<%# Eval("ProductName") %>' />
            </td>
         </tr>
      </AlternatingItemTemplate>
      <EmptyDataTemplate>
         <table runat="server" style="">
            <tr>
                  <td>No data was returned.</td>
            </tr>
         </table>
      </EmptyDataTemplate>
      <InsertItemTemplate>
         <tr style="">
            <td>
                  <asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="Insert" />
                  <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Clear" />
            </td>
            <td>
                  <asp:TextBox ID="ProductIDTextBox" runat="server"  Text='<%# Bind("ProductID") %>' />
            </td>
            <td>
                  <asp:TextBox ID="ProductNameTextBox" runat="server" Text='<%# Bind("ProductName") %>' />
            </td>
         </tr>
      </InsertItemTemplate>
      <LayoutTemplate>
         <table runat="server">
            <tr runat="server">
                  <td runat="server">
                     <table ID="itemPlaceholderContainer" runat="server" border="0" style="">
                        <tr runat="server" style="">
                              <th runat="server"></th>
                              <th runat="server">ProductID</th>
                              <th runat="server">
                                 ProductName</th>
                        </tr>
                        <tr ID="itemPlaceholder" runat="server"></tr>
                     </table>
                  </td>
            </tr>
            <tr runat="server">
                  <td runat="server" style="">
                  </td>
            </tr>
         </table>
      </LayoutTemplate>
      <EditItemTemplate>
         <tr style="">
            <td>
                  <asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
                  <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" />
            </td>
            <td>
                  <asp:Label ID="ProductIDLabel1" runat="server" Text='<%# Eval("ProductID") %>' />
            </td>
            <td>
                  <asp:TextBox ID="ProductNameTextBox" runat="server" Text='<%# Bind("ProductName") %>' />
            </td>
         </tr>
      </EditItemTemplate>
      <SelectedItemTemplate>
         <tr style="">
            <td>
                  <asp:Button ID="DeleteButton" runat="server" CommandName="Delete"
                     Text="Delete" />
                  <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
            </td>
            <td>
                  <asp:Label ID="ProductIDLabel" runat="server" Text='<%# Eval("ProductID") %>' />
            </td>
            <td>
                  <asp:Label ID="ProductNameLabel" runat="server"
                     Text='<%# Eval("ProductName") %>' />
            </td>
         </tr>
      </SelectedItemTemplate>
</asp:ListView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
      ConnectionString="<%$ ConnectionStrings:conn %>"
      SelectCommand="SELECT * FROM [Products] ORDER BY [ProductID] DESC"
            UpdateCommand="UPDATE [Products] SET [ProductName] = @ProductName WHERE [ProductID] = @ProductID"
            DeleteCommand="DELETE FROM [Products] WHERE [ProductID] = @ProductID"
            InsertCommand="INSERT INTO [Products] ([ProductID], [ProductName]) VALUES (@ProductID, @ProductName)">
</asp:SqlDataSource>