<html><head runat="server">
<title>GridView Delete</title>
</head><body>
<form id="frmGridViewDeleteExample" runat="server">
<asp:GridView DataSourceID="gvExample"
AutoGenerateEditButton="true"
AutoGenerateDeleteButton="true"
Runat="Server" AllowSorting="True"
AllowPaging="True" PageSize="10"
AutoGenerateColumns="False" BackColor="#c0c0c0"
BorderColor="black" BorderStyle="Groove"
BorderWidth="5" Caption="GridView Delete Example" />
<asp:SqlDataSource ID="gvExample"
ConnectionString=”Server=localhost;Database=Northwind;Trusted_Connection=true”
SelectCommand=”SELECT EmployeeID, LastName, FirstName FROM Employees”
UpdateCommand=”UPDATE Employees SET LastName=@LastName, FirstName=@FirstName WHERE EmployeeID=@EmployeeID"
DeleteCommand=”DELETE Employees WHERE EmployeeID=@EmployeeID” Runat="Server">
<Columns>
<asp:BoundField DataField="EmployeeID" NullDisplayText="unknown" ReadOnly="True" />
<asp:BoundField DataField="LastName" NullDisplayText="unknown" />
<asp:BoundFieldDataField="FirstName" NullDisplayText="unknown" />
</Columns>
</asp:GridView>
</form></body></html>
用户评论