📄 var.aspx
字号:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ OutputCache Duration="60" VaryByParam="MySelect" %>
<html>
<script language="C#" runat="server">
SqlConnection myConnection;
protected void Page_Load(Object Src, EventArgs E)
{
myConnection = new SqlConnection("server=(local);database=Northwind;Trusted_Connection=yes");
SqlDataAdapter myCommand;
DataSet ds = new DataSet();
//得到传过来的MySelect请求字符
String city=Request["MySelect"].ToString();
String selectCmd;
if(city==null)
{
selectCmd="select * from Employees";
}
else
{
selectCmd= "select * from Employees where City ='" + city + "'";
}
myCommand = new SqlDataAdapter(selectCmd, myConnection);
TimeMsg.Text = DateTime.Now.ToString("G");
myCommand.Fill(ds, "Employees");
MyDataGrid.DataSource= ds.Tables["Employees"].DefaultView;
MyDataGrid.DataBind();
}
</script>
<body>
<form method="post" runat="server">
选择城市:
<select id="MySelect" DataTextField="City" runat="server"/>
<input type="submit" Value="查询此地员工" runat="server"/><p>
<ASP:DataGrid id="MyDataGrid" runat="server"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
AutoGenerateColumns="False"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false">
<Columns>
<asp:BoundColumn HeaderText="序号" DataField="EmployeeID"/>
<asp:BoundColumn HeaderText="姓名" DataField="FirstName" />
<asp:BoundColumn HeaderText="职位" DataField="title"/>
</Columns>
</asp:DataGrid>
<i>页面创建于:</i> <asp:label id="TimeMsg" runat="server"/>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -