登 录
郁闷了好长一段时间，做了各种各样的修改，就是“删除”无法执行，罪魁祸首竟然是 ListView 控件中少设置了一个 DataKeyNames 属性，悲哀啊！
default.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="listView6._Default" %></p> <p><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"></p> <p><html xmlns="http://www.w3.org/1999/xhtml" ><br /> <head runat="server"><br /> <title>增删改查数据库记录</title><br /> <style type="text/css" mce_bogus="1">body<br /> {<br /> font-family:宋体;<br /> font-size:14px;<br /> }<br /> .insert {<br /> background-color: #9C0;<br /> }<br /> .xm {<br /> width: 80px;<br /> }<br /> .dh, .qq {<br /> width: 100px;<br /> }<br /> .edit td {<br /> padding-top: 3px;<br /> padding-right: 0px;<br /> padding-bottom: 4px;<br /> padding-left: 6px;<br /> font-family:宋体;<br /> background-color: #CFF;<br /> color:#F00;<br /> font-weight:bolder;<br /> }<br /> a<br /> {<br /> color: #06F;<br /> text-decoration: none;<br /> }<br /> .edit a, .edit input<br /> {<br /> font-weight:bolder;<br /> color:#F00;<br /> text-decoration: none;<br /> font-family:宋体;<br /> }<br /> .edit a:hover<br /> {<br /> font-weight:bolder;<br /> color:#F00;<br /> text-decoration: underline overline;<br /> }<br /> a:hover {<br /> color: #F00;<br /> text-decoration: underline overline;<br /> }</style><br /> </head><br /> <body><br /> <form id="form1" runat="server"><br /> <div></p> <p> <asp:ListView ID="ListView1" runat="server" DataSourceID="AccessDataSource1" DataKeyNames="xh"<br /> ItemPlaceholderID="PlaceHolder1"<br /> InsertItemPosition="LastItem" ><br /> <LayoutTemplate><br /> <table border="2" cellpadding="6" cellspacing="0" align="center" style="border-collapse:collapse;" mce_style="border-collapse:collapse;"></p> <p> <tr><br /> <th width="80">学号</th><br /> <th width="105">姓名</th><br /> <th width="124">电话</th><br /> <th width="124">QQ</th><br /> <th width="80">管理</th><br /> </tr><br /> <asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder><br /> <tr><br /> <td colspan="5" align="right"><br /> <asp:DataPager ID="DataPager1" runat="server" PageSize="15" ><br /> <Fields><br /> <asp:NextPreviousPagerField ShowFirstPageButton="True" ShowNextPageButton="False" /><br /> <asp:NumericPagerField /><br /> <asp:NextPreviousPagerField ShowLastPageButton="True" ShowPreviousPageButton="False" /><br /> </Fields><br /> </asp:DataPager><br /> </td><br /> </tr><br /> </table><br /> </LayoutTemplate></p> <p> <ItemTemplate><br /> <tr><br /> <td><asp:Label ID="Label1" runat="server" Text='<%# Eval("xh") %>'></asp:Label></td><br /> <td><%#Eval("xm") %></td><br /> <td><%#Eval("dh") %></td><br /> <td><%#Eval("qq") %></td><br /> <td align="center"><br /> <asp:LinkButton ID="btnModify" runat="server" CommandName="Edit" >修改</asp:LinkButton><br /> <asp:LinkButton ID="btnDelete" runat="server" CommandName="Delete" >删除</asp:LinkButton><br /> </td><br /> </tr><br /> </ItemTemplate></p> <p> <EditItemTemplate><br /> <tr class="edit"><br /> <td><asp:Label ID="Label1" runat="server" Text='<%# Eval("xh") %>'></asp:Label></td><br /> <td><asp:TextBox ID="TextBox2" runat="server" Text="<%# Bind('xm') %>" CssClass="xm"></asp:TextBox></td><br /> <td><asp:TextBox ID="TextBox3" runat="server" Text="<%# Bind('dh') %>" CssClass="dh"></asp:TextBox></td><br /> <td><asp:TextBox ID="TextBox4" runat="server" Text="<%# Bind('qq') %>" CssClass="qq"></asp:TextBox></td><br /> <td align="center"><br /> <asp:LinkButton ID="btnModify" runat="server" CommandName="Update" >确认</asp:LinkButton><br /> <asp:LinkButton ID="btnCancel" runat="server" CommandName="Cancel" >取消</asp:LinkButton><br /> </td><br /> </tr><br /> </EditItemTemplate></p> <p> <InsertItemTemplate><br /> <tr class="insert"><br /> <td><asp:TextBox ID="TextBox1" runat="server" Text="<%# Bind('xh') %>" CssClass="xm"></asp:TextBox></td><br /> <td><asp:TextBox ID="TextBox2" runat="server" Text="<%# Bind('xm') %>" CssClass="xm"></asp:TextBox></td><br /> <td><asp:TextBox ID="TextBox3" runat="server" Text="<%# Bind('dh') %>" CssClass="dh"></asp:TextBox></td><br /> <td><asp:TextBox ID="TextBox4" runat="server" Text="<%# Bind('qq') %>" CssClass="qq"></asp:TextBox></td><br /> <td align="center"><br /> <asp:LinkButton ID="btnInsert" runat="server" CommandName="Insert" >插入</asp:LinkButton><br /> <asp:LinkButton ID="btnClear" runat="server" CommandName="Cancel" >清除</asp:LinkButton><br /> </td><br /> </tr><br /> </InsertItemTemplate><br /> </asp:ListView><br /> <asp:AccessDataSource ID="AccessDataSource1" runat="server"<br /> DataFile="~/App_Data/students.mdb"<br /> SelectCommand="SELECT * FROM [students] ORDER BY [xh]"<br /> UpdateCommand="UPDATE [students] SET [xm] = ?, [dh] = ?, [qq] = ? WHERE [xh] = ?"<br /> DeleteCommand="DELETE FROM [students] WHERE (xh =?)"<br /> InsertCommand="INSERT INTO [students] ([xh], [xm], [dh], [qq]) VALUES (?, ?, ?, ?)"<br /> ><br /> <UpdateParameters><br /> <asp:Parameter Name="xm" Type="String" /><br /> <asp:Parameter Name="dh" Type="String" /><br /> <asp:Parameter Name="qq" Type="String" /><br /> <asp:Parameter Name="xh" Type="String" /><br /> </UpdateParameters></p> <p> <DeleteParameters><br /> <asp:Parameter Name="xh" Type="String" /><br /> </DeleteParameters></p> <p> <InsertParameters><br /> <asp:Parameter Name="xh" Type="String" /><br /> <asp:Parameter Name="xm" Type="String" /><br /> <asp:Parameter Name="dh" Type="String" /><br /> <asp:Parameter Name="qq" Type="String" /><br /> </InsertParameters><br /> </asp:AccessDataSource></p> <p> </div><br /> </form><br /> </body><br /> </html><br />
抱歉!评论已关闭.
