📄 default.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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 style="text-align: center">
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DB_ADONETConnectionString %>"
DeleteCommand="DELETE FROM [t_People] WHERE [tb_PID] = @tb_PID" InsertCommand="INSERT INTO [t_People] ([tb_PID], [tb_PName], [tb_PSex]) VALUES (@tb_PID, @tb_PName, @tb_PSex)"
SelectCommand="SELECT * FROM [t_People]" UpdateCommand="UPDATE [t_People] SET [tb_PName] = @tb_PName, [tb_PSex] = @tb_PSex WHERE [tb_PID] = @tb_PID">
<DeleteParameters>
<asp:Parameter Name="tb_PID" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="tb_PName" Type="String" />
<asp:Parameter Name="tb_PSex" Type="String" />
<asp:Parameter Name="tb_PID" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="tb_PID" Type="String" />
<asp:Parameter Name="tb_PName" Type="String" />
<asp:Parameter Name="tb_PSex" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
<asp:FormView ID="FormView1" runat="server" AllowPaging="True" BorderStyle="Inset"
DataKeyNames="tb_PID" DataSourceID="SqlDataSource1" Width="202px">
<EditItemTemplate>
tb_PID:
<asp:Label ID="tb_PIDLabel1" runat="server" Text='<%# Eval("tb_PID") %>'></asp:Label><br />
tb_PName:
<asp:TextBox ID="tb_PNameTextBox" runat="server" Text='<%# Bind("tb_PName") %>'>
</asp:TextBox><br />
tb_PSex:
<asp:TextBox ID="tb_PSexTextBox" runat="server" Text='<%# Bind("tb_PSex") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="更新">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="取消">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
tb_PID:
<asp:TextBox ID="tb_PIDTextBox" runat="server" Text='<%# Bind("tb_PID") %>'></asp:TextBox><br />
tb_PName:
<asp:TextBox ID="tb_PNameTextBox" runat="server" Text='<%# Bind("tb_PName") %>'></asp:TextBox><br />
tb_PSex:
<asp:TextBox ID="tb_PSexTextBox" runat="server" Text='<%# Bind("tb_PSex") %>'></asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="插入"></asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="取消"></asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
tb_PID:
<asp:Label ID="tb_PIDLabel" runat="server" Text='<%# Eval("tb_PID") %>'></asp:Label><br />
tb_PName:
<asp:Label ID="tb_PNameLabel" runat="server" Text='<%# Bind("tb_PName") %>'></asp:Label><br />
tb_PSex:
<asp:Label ID="tb_PSexLabel" runat="server" Text='<%# Bind("tb_PSex") %>'></asp:Label><br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
Text="编辑">
</asp:LinkButton>
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
Text="删除">
</asp:LinkButton>
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
Text="新建">
</asp:LinkButton>
</ItemTemplate>
<HeaderTemplate>
<span style="font-size: 10pt"><strong>FormView控件演示</strong></span>
</HeaderTemplate>
</asp:FormView>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -