📄 formparam.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="FormParam.aspx.cs" Inherits="FormParam" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HTML>
<BODY>
<FORM id="FORM1" runat="server">
<table style="width: 440px; height: 140px;">
<tr>
<td colspan="2">
<asp:dropdownlist id="dwnCompany" runat="server" datasourceid="sqldsShipper" datatextfield="CompanyName" datavaluefield="ShipperID" AppendDataBoundItems="True" DataMember="DefaultView" >
<asp:ListItem>请选择公司</asp:ListItem>
</asp:DropDownList>
</td>
<td colspan="1">
<asp:sqldatasource id="sqldsShipper" runat="server"
connectionstring="<%$ ConnectionStrings:NorthwindConnectionString %>"
selectcommand="SELECT CompanyName,ShipperID FROM Shippers"
insertcommand="INSERT INTO Shippers (CompanyName,Phone) VALUES (@paramCompanyName,@paramPhone)" ProviderName="<%$ ConnectionStrings:NorthwindConnectionString.ProviderName %>" OnInserting="SqlDataSource1_Inserting">
<insertparameters>
<asp:formparameter name="paramCompanyName" formfield="txtCompanyName" />
<asp:formparameter name="paramPhone" formfield="txtPhone" />
</insertparameters>
</asp:sqldatasource>
</td>
</tr>
<tr>
<td style="width: 194px; height: 59px;">
<asp:Label ID="capCompanyName" runat="server" Text="公司名称:"></asp:Label>
</td>
<td style="width: 100px; height: 59px;">
<asp:TextBox id="txtCompanyName" runat="server" ></asp:TextBox>
</td>
<td style="width: 100px; height: 59px">
<asp:RequiredFieldValidator ID="rvCompany" runat="server" ControlToValidate="txtCompanyName"
Display="Static" ErrorMessage="请输入公司名称" Width="180px">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td style="width: 194px; height: 45px;">
<asp:Label ID="capPhone" runat="server" Text="电话:"></asp:Label>
</td>
<td style="width: 100px; height: 45px;">
<asp:textbox id="txtPhone" runat="server" />
</td>
<td style="width: 100px; height: 45px">
<asp:RequiredFieldValidator id="rvTel" runat="server" ControlToValidate="txtPhone" Display="Static"
ErrorMessage="请输入电话号码" Width="180px" /></td>
</tr>
<tr>
<td colspan="2">
<asp:button id="btnInsert" runat="server" text="新建" onclick="InsertShipper" Width="55px" /></td>
<td colspan="1">
</td>
</tr>
</table>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -