ASP.NET中FormView（表单视图）的使⽤前台绑定 ASP.NET中 FormView(表单视图)的使⽤前台绑定。 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Fvw.aspx.cs" Inherits="Fvw" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="/1999/xhtml">
<head runat="server">
<title>⽆标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h3>FromView</h3>
<hr />
<asp:FormView ID="fvw" runat="server" AllowPaging="True"
DataKeyNames="ProductID" DataSourceID="SqlDataSource1">
<EditItemTemplate>
ProductID:
<asp:Label ID="ProductIDLabel1" runat="server"
Text='<%# Eval("ProductID") %>' />
<br />
ProductName:
<asp:TextBox ID="ProductNameTextBox" runat="server"
Text='<%# Bind("ProductName") %>' />
<br />
李人志
CategoryID:
<asp:TextBox ID="CategoryIDTextBox" runat="server"
Text='<%# Bind("CategoryID") %>' />
<br />
UnitPrice:
<asp:TextBox ID="UnitPriceTextBox" runat="server"
Text='<%# Bind("UnitPrice") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="更新"/>
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="取消"/>
</EditItemTemplate>
<InsertItemTemplate>
ProductName:
<asp:TextBox ID="ProductNameTextBox" runat="server"
Text='<%# Bind("ProductName") %>' />协作图
<br />
CategoryID:
<asp:TextBox ID="CategoryIDTextBox" runat="server"
Text='<%# Bind("CategoryID") %>' />
<br />
UnitPrice:
<asp:TextBox ID="UnitPriceTextBox" runat="server"
Text='<%# Bind("UnitPrice") %>' />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="插⼊"/>
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="取消"/>
</InsertItemTemplate>
<ItemTemplate>
ProductID:
<asp:Label ID="ProductIDLabel" runat="server" Text='<%# Eval("ProductID") %>' />
<br />
ProductName:
<asp:Label ID="ProductNameLabel" runat="server"
Text='<%# Bind("ProductName") %>' />
<br />
CategoryID:
<asp:Label ID="CategoryIDLabel" runat="server"
Text='<%# Bind("CategoryID") %>' />
<br />
UnitPrice:
<asp:Label ID="UnitPriceLabel" runat="server" Text='<%# Bind("UnitPrice") %>' />
<br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False"
CommandName="Edit" Text="编辑"/>
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False"
CommandName="Delete" Text="删除"/>
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False"
CommandName="New" Text="新建"/>
</ItemTemplate>
</asp:FormView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
奥运五环DeleteCommand="DELETE FROM [Products] WHERE [ProductID] = @ProductID"
InsertCommand="INSERT INTO [Products] ([ProductName], [CategoryID], [UnitPrice]) VALUES (@ProductName, @CategoryID, @UnitPrice)"
SelectCommand="SELECT [ProductID], [ProductName], [CategoryID], [UnitPrice] FROM [Products] ORDER BY [ProductID] DESC"
UpdateCommand="UPDATE [Products] SET [ProductName] = @ProductName, [CategoryID] = @C
ategoryID, [UnitPrice] = @UnitPrice WHERE [ProductID] = @ProductID"> <DeleteParameters>
<asp:Parameter Name="ProductID" Type="Int32"/>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ProductName" Type="String"/>
<asp:Parameter Name="CategoryID" Type="Int32"/>
<asp:Parameter Name="UnitPrice" Type="Decimal"/>
<asp:Parameter Name="ProductID" Type="Int32"/>
</UpdateParameters>
燕山大学<InsertParameters>
<asp:Parameter Name="ProductName" Type="String"/>
<asp:Parameter Name="CategoryID" Type="Int32"/>
<asp:Parameter Name="UnitPrice" Type="Decimal"/>
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
/fig
<connectionStrings>
北京政治副中心
<add name="NorthwindConnectionString" connectionString="Data
Source=.;Initial Catalog=Northwind;Integrated Security=True"
providerName="System.Data.SqlClient"/>
</connectionStrings>
