📄 editablegridview.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="EditableGridView.aspx.vb" Inherits="EditableGridView" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>ASP.NET 2.0 GridView and DetailsView Controls</title>
</head>
<body style="font-size: 12pt">
<form id="frmEditable" runat="server">
<div style="background-color: Gainsboro">
<div style="text-align: left">
<div style="text-align: left">
<span style="font-size: 14pt; font-family: Arial"><b>Editable GridView Control
<asp:LinkButton ID="lbReadOnly" Runat="server" Font-Size="11pt" PostBackUrl="~/Default.aspx"
ToolTip="Click to display default read-only GridView page" EnableViewState="False">Read-Only GridView</asp:LinkButton>
<asp:LinkButton ID="lbDetailsView" PostBackUrl="~/EditableDetailsView.aspx"
Font-Size="11pt" Runat="server">Editable DetailsView</asp:LinkButton>
<asp:TextBox ID="txtError" Runat="server" Font-Size="10pt" ForeColor="Red" Font-Names="Verdana"
Width="856px" Height="18px" Visible="False"></asp:TextBox>
</b></span>
</div>
<table style="width: 800px; height: 419px" cellpadding="2" border="0">
<tr>
<td style=" height: 209px; background-color: gainsboro; width: 695px;" colspan="2">
<asp:GridView ID="gvOrdersEditable" Style="font-size: 10pt; font-family: Verdana" Runat="server"
DataSourceID="dsOrdersEdit" DataKeyNames="OrderID" AutoGenerateColumns="False" AllowPaging="True"
BorderWidth="1px" BackColor="White" GridLines="Vertical" CellPadding="3" BorderStyle="None"
BorderColor="#999999" PageSize="15" AutoGenerateEditButton="True">
<FooterStyle ForeColor="Black" BackColor="Gainsboro"></FooterStyle>
<PagerStyle ForeColor="Black" HorizontalAlign="Left" BackColor="Gainsboro" Font-Names="Arial" Font-Size="11pt" Font-Bold="True"></PagerStyle>
<HeaderStyle ForeColor="White" Font-Bold="True" BackColor="#000084"></HeaderStyle>
<PagerSettings FirstPageText="First" LastPageText="Last" Mode="NumericFirstLast"></PagerSettings>
<AlternatingRowStyle BackColor="Gainsboro"></AlternatingRowStyle>
<Columns>
<asp:BoundField ReadOnly="True" HeaderText="Order ID" InsertVisible="False" DataField="OrderID"
SortExpression="OrderID">
<ItemStyle HorizontalAlign="Right"></ItemStyle>
</asp:BoundField>
<asp:TemplateField SortExpression="CustomerID" HeaderText="Cust. ID"><EditItemTemplate>
<asp:TextBox ID="txtCustomerID" Runat="server" Width="46px" Text='<%# Bind("CustomerID") %>' ReadOnly="True"></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Left"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("CustomerID") %>' ID="Label3"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Empl. ID"><EditItemTemplate>
<asp:DropDownList ID="ddlEmployee" Runat="server" Height="22px" Width="94px" DataSourceID="dsEmployees"
DataValueField="EmployeeID" DataTextField="LastName" SelectedValue='<%# Bind("EmployeeID") %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("EmployeeID") %>' ID="Label2"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="OrderDate" HeaderText="Order Date"><EditItemTemplate>
<asp:TextBox ID="txtOrderDate" Runat="server" Width="76px" Text='<%# Bind("OrderDate", "{0:d}") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("OrderDate", "{0:d}") %>' ID="Label1"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="RequiredDate" HeaderText="Required Date"><EditItemTemplate>
<asp:TextBox ID="txtRequiredDate" Runat="server" Width="76px" Text='<%# Bind("RequiredDate", "{0:d}") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("RequiredDate", "{0:d}") %>' ID="Label4"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ShippedDate" HeaderText="Shipped Date"><EditItemTemplate>
<asp:TextBox ID="txtShippedDate" Runat="server" Width="76px" Text='<%# Bind("ShippedDate", "{0:d}") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("ShippedDate", "{0:d}") %>' ID="Label5"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ShipVia" HeaderText="Ship Via"><EditItemTemplate>
<asp:DropDownList ID="ddlShipper" Runat="server" Height="22px" Width="124px" DataSourceID="dsShippers"
DataValueField="ShipperID" DataTextField="CompanyName" SelectedValue='<%# Bind("ShipVia") %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("ShipVia") %>' ID="Label6"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="Freight" HeaderText="Freight"><EditItemTemplate>
<asp:TextBox ID="txtFreight" Runat="server" Width="52px" Text='<%# Bind("Freight") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("Freight", "{0:C2}") %>' ID="Label7"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ShipName" HeaderText="Ship Name"><EditItemTemplate>
<asp:TextBox ID="txtShipName" Runat="server" Width="204px" Text='<%# Bind("ShipName") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle Wrap="False"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("ShipName") %>' ID="Label8"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ShipAddress" HeaderText="Ship Address"><EditItemTemplate>
<asp:TextBox ID="txtShipAddress" Runat="server" Width="252px" Text='<%# Bind("ShipAddress") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle Wrap="False"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("ShipAddress") %>' ID="Label9"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ShipCity" HeaderText="Ship City"><EditItemTemplate>
<asp:TextBox ID="txtShipCity" Runat="server" Width="116px" Text='<%# Bind("ShipCity") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle Wrap="False"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("ShipCity") %>' ID="Label10"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ShipRegion" HeaderText="Ship Region"><EditItemTemplate>
<asp:TextBox ID="txtShipRegion" Runat="server" Width="108px" Text='<%# Bind("ShipRegion") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle Wrap="False"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("ShipRegion") %>' ID="Label11"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ShipPostalCode" HeaderText="Ship PostalCode"><EditItemTemplate>
<asp:TextBox ID="txtShipPostalCode" Runat="server" Width="92px" Text='<%# Bind("ShipPostalCode") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("ShipPostalCode") %>' ID="Label12"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ShipCountry" HeaderText="Ship Country"><EditItemTemplate>
<asp:TextBox ID="txtShipCountry" Runat="server" Width="100px" Text='<%# Bind("ShipCountry") %>'></asp:TextBox>
</EditItemTemplate>
<ItemStyle Wrap="False"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("ShipCountry") %>' ID="Label13"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<SelectedRowStyle ForeColor="White" Font-Bold="True" BackColor="#008A8C"></SelectedRowStyle>
<RowStyle ForeColor="Black" BackColor="#EEEEEE"></RowStyle>
</asp:GridView>
<asp:SqlDataSource ID="dsOrdersEdit" Runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT * FROM [Orders] ORDER BY [OrderID] DESC, [CustomerID]" DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @original_OrderID"
InsertCommand="INSERT INTO [Orders] ([CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName], [ShipAddress], [ShipCity], [ShipRegion], [ShipPostalCode], [ShipCountry]) VALUES (@CustomerID, @EmployeeID, @OrderDate, @RequiredDate, @ShippedDate, @ShipVia, @Freight, @ShipName, @ShipAddress, @ShipCity, @ShipRegion, @ShipPostalCode, @ShipCountry)"
UpdateCommand="UPDATE [Orders] SET [CustomerID] = @CustomerID, [EmployeeID] = @EmployeeID, [OrderDate] = @OrderDate, [RequiredDate] = @RequiredDate, [ShippedDate] = @ShippedDate, [ShipVia] = @ShipVia, [Freight] = @Freight, [ShipName] = @ShipName, [ShipAddress] = @ShipAddress, [ShipCity] = @ShipCity, [ShipRegion] = @ShipRegion, [ShipPostalCode] = @ShipPostalCode, [ShipCountry] = @ShipCountry WHERE [OrderID] = @original_OrderID">
<DeleteParameters>
<asp:Parameter Type="Int32" Name="OrderID"></asp:Parameter>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
<asp:Parameter Type="Int32" Name="EmployeeID"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="OrderDate"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="RequiredDate"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="ShippedDate" ConvertEmptyStringToNull=true></asp:Parameter>
<asp:Parameter Type="Int32" Name="ShipVia"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Freight"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipName"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipAddress"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipCity"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipRegion"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipPostalCode"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipCountry"></asp:Parameter>
<asp:Parameter Type="Int32" Name="OrderID"></asp:Parameter>
</UpdateParameters>
<InsertParameters>
<asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
<asp:Parameter Type="Int32" Name="EmployeeID"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="OrderDate"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="RequiredDate"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="ShippedDate"></asp:Parameter>
<asp:Parameter Type="Int32" Name="ShipVia"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Freight"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipName"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipAddress"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipCity"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipRegion"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipPostalCode"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipCountry"></asp:Parameter>
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="dsEmployees" Runat="server" SelectCommand="SELECT [EmployeeID], [LastName] FROM [Employees] ORDER BY [LastName]"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>">
</asp:SqlDataSource>
<asp:SqlDataSource ID="dsShippers" Runat="server" SelectCommand="SELECT [ShipperID], [CompanyName] FROM [Shippers] ORDER BY [CompanyName]"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>">
</asp:SqlDataSource>
</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -