📄 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>示例20_05</title>
</head>
<body style="text-align: center">
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DB_ADONETConnectionString %>"
InsertCommand="INSERT INTO [t_People] ([tb_PID], [tb_PName], [tb_PSex]) VALUES (@tb_PID, @tb_PName, @tb_PSex)"
SelectCommand="SELECT * FROM [t_People]" >
<InsertParameters>
<asp:ControlParameter ControlID="TextBox1" Name="tb_PID" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TextBox2" Name="tb_PName" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="tb_PSex" PropertyName="SelectedValue" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
<table border=1>
<tr>
<td style="width: 100px">
<table>
<tr>
<td style="width: 100px">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataKeyNames="tb_PID" DataSourceID="SqlDataSource1" Width="311px" PageSize=3 Height="1px">
<Columns>
<asp:BoundField DataField="tb_PID" HeaderText="tb_PID" ReadOnly="True" SortExpression="tb_PID" />
<asp:BoundField DataField="tb_PName" HeaderText="tb_PName" SortExpression="tb_PName" />
<asp:BoundField DataField="tb_PSex" HeaderText="tb_PSex" SortExpression="tb_PSex" />
</Columns>
</asp:GridView>
<hr style="width: 313px" />
</td>
<strong>
Insert方法的应用
</strong>
</tr>
<tr>
<td style="width: 100px">
<table style="width: 308px">
<tr>
<td style="width: 52px; text-align: right;">
编号：</td>
<td style="width: 100px">
<asp:TextBox ID="TextBox1" runat="server" Width="167px"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 52px; text-align: right;">
姓名：</td>
<td style="width: 100px">
<asp:TextBox ID="TextBox2" runat="server" Width="170px"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 52px; text-align: right;">
性别：</td>
<td style="width: 100px;">
<asp:DropDownList ID="DropDownList1" runat="server" Width="177px">
<asp:ListItem>男</asp:ListItem>
<asp:ListItem>女</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 52px">
</td>
<td style="width: 100px; text-align: left;">
<table>
<tr>
<td style="width: 83px; text-align: right">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="添 加" /></td>
<td style="width: 88px">
<asp:Button
ID="Button2" runat="server" Text="取 消" OnClick="Button2_Click" /></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="width: 100px">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -