62,047
社区成员
发帖
与我相关
我的任务
分享
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Formview2.aspx.cs" Inherits="DataBindControlsTest_Formview2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FormView ID="FormView1" runat="server" DataKeyNames="loginName"
DataSourceID="SqlDataSource1">
<EditItemTemplate>
loginName:
<asp:Label ID="loginNameLabel1" runat="server"
Text='<%# Eval("loginName") %>' />
<br />
realname:
<asp:TextBox ID="realnameTextBox" runat="server"
Text='<%# Bind("realname") %>' />
<br />
password:
<asp:TextBox ID="passwordTextBox" runat="server" Text='<%# Bind("password") %>'
TextMode="Password" />
<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>
loginName:
<asp:TextBox ID="loginNameTextBox" runat="server"
Text='<%# Bind("loginName") %>' />
<br />
realname:
<asp:TextBox ID="realnameTextBox" runat="server"
Text='<%# Bind("realname") %>' />
<br />
password:
<asp:TextBox ID="passwordTextBox" runat="server" Text='<%# Bind("password") %>'
TextMode="Password" />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="插入" />
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="取消" />
</InsertItemTemplate>
<ItemTemplate>
loginName:
<asp:Label ID="loginNameLabel" runat="server" Text='<%# Eval("loginName") %>' />
<br />
realname:
<asp:Label ID="realnameLabel" runat="server" Text='<%# Bind("realname") %>' />
<br />
password:
<asp:Label ID="passwordLabel" runat="server" Text='<%# Bind("password") %>' />
<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:dgmlOAConnectionString %>"
DeleteCommand="DELETE FROM [Users] WHERE [loginName] = @loginName"
InsertCommand="INSERT INTO [Users] ([loginName], [realname], [password]) VALUES (@loginName, @realname, @password)"
SelectCommand="SELECT [loginName], [realname], [password] FROM [Users]"
UpdateCommand="UPDATE [Users] SET [realname] = @realname, [password] = @password WHERE [loginName] = @loginName">
<DeleteParameters>
<asp:Parameter Name="loginName" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="realname" Type="String" />
<asp:Parameter Name="password" Type="String" />
<asp:Parameter Name="loginName" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="loginName" Type="String" />
<asp:Parameter Name="realname" Type="String" />
<asp:Parameter Name="password" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>