<html><head runat="server">
<title>GridView Edit</title>
</head><body>
<form id="frmGridViewEditExample" runat="server">
<asp:GridView DataSourceID="gvExample"
AutoGenerateEditButton="true" Runat="Server"
AllowSorting="True" AllowPaging="True"
PageSize="10" AutoGenerateColumns="False"
BackColor="#c0c0c0" BorderColor="black"
BorderStyle="Groove" BorderWidth="5"
Caption="GridView Edit 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" Runat="Server">
<Columns>
<asp:BoundField DataField="EmployeeID" NullDisplayText="unknown" ReadOnly="True" />
<asp:BoundField DataField="LastName" NullDisplayText="unknown" />
<asp:BoundField DataField="FirstName" NullDisplayText="unknown" />
</Columns>
</asp:GridView>
</form></body></html>
用户评论