📄 webform2.aspx
字号:
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<MM:DataSet
id="dsCustomers"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_conn") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_conn") %>'
CommandText='<%# "SELECT * FROM Customers WHERE CustomerID = ?" %>'
Debug="true" PageSize="10"
>
<Parameters>
<Parameter Name="@CustomerID" Value='<%# IIf((txtCustomerID.text <> Nothing), txtCustomerID.text , 0) %>' Type="Integer" />
</Parameters>
</MM:DataSet>
<form action="SBGetData.aspx" method="post" runat="server">
<asp:TextBox ID="txtCustomerID" runat="server" />
<asp:Button ID="btnSearch" Text="提交查询" runat="server" />
<%response.write(txtCustomerID.text) %>
<p> </p>
</form>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<form action="SBGetData.aspx" method="post" runat="server">
<asp:TextBox ID="txtCustomerID" runat="server" />
<asp:Button ID="btnSearch" Text="提交查询" runat="server" />
<%response.write(txtCustomerID.text) %>
<p>
<MM:If runat="server" Expression='<%# (dsCustomers.RecordCount > 0) %>'>
<ContentsTemplate>
<asp:DataGrid id="DataGrid1"
runat="server"
AllowSorting="False"
AutoGenerateColumns="false"
CellPadding="3"
CellSpacing="0"
ShowFooter="false"
ShowHeader="true"
DataSource="<%# dsCustomers.DefaultView %>"
PagerStyle-Mode="NextPrev"
AllowPaging="true"
AllowCustomPaging="true"
PageSize="<%# dsCustomers.PageSize %>"
VirtualItemCount="<%# dsCustomers.RecordCount %>"
OnPageIndexChanged="dsCustomers.OnDataGridPageIndexChanged"
>
<HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" />
<ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<FooterStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" />
<PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<Columns>
<asp:BoundColumn DataField="CustomerID"
HeaderText="CustomerID"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="CustomerName"
HeaderText="CustomerName"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="Birthday"
HeaderText="Birthday"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="city"
HeaderText="city"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="Address"
HeaderText="Address"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="Phone"
HeaderText="Phone"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="Fax"
HeaderText="Fax"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="eMail"
HeaderText="eMail"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="Sex"
HeaderText="Sex"
ReadOnly="true"
Visible="True"/>
</Columns>
</asp:DataGrid>
</ContentsTemplate>
</MM:If>
</p>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -