📄 twotier.aspx
字号:
<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="TwoLayer" %>
<html>
<script language="C#" runat="server">
public void Page_Load(Object sender, EventArgs E)
{
if (!IsPostBack)
{
//创建DataObj对象的实例，初始化参数为ConnectionString
DataObj data = new DataObj("server=(local);database=Northwind;Trusted_Connection=yes");
//为列表绑定字段，全部方法封装在DataObj对象当中。
City.DataSource = data.GetCity();
City.DataBind();
}
}
void MyDataGrid_Page(Object sender, DataGridPageChangedEventArgs e) {
Employees.CurrentPageIndex = e.NewPageIndex;
DataBind();
}
public void Submit_Click(Object sender, EventArgs E)
{
Employees.CurrentPageIndex=0;
DataBind();
}
public void DataBind()
{
//同样创建DataObj对象的实例。
DataObj data = new DataObj("server=(local);database=Northwind;Trusted_Connection=yes");
//为DataGrid控件绑定
Employees.DataSource = data.GetEmployeesForCity(City.SelectedItem.Value);
Employees.DataBind();
}
</script>
<body>
<form runat="server">
<h3>简单的两层模型</h3>
请选择职员所在的城市：
<ASP:DropDownList id="City" DataValueField="City" runat="server"/>
<input type="Submit" OnServerClick="Submit_Click" Value="查询" runat="server"/><p>
<ASP:DataGrid id="Employees" runat="server"
AutoGenerateColumns="false"
AllowPaging="True"
PageSize="1"
PagerStyle-HorizontalAlign="Right"
PagerStyle-NextPageText="Next"
PagerStyle-PrevPageText="Last"
PagerStyle-Mode="NextPrev"
OnPageIndexChanged="MyDataGrid_Page">
<Columns>
<asp:BoundColumn HeaderText="FirstName" ReadOnly="true" DataField="FirstName"/>
<asp:BoundColumn HeaderText="LastName" DataField="LastName" />
<asp:BoundColumn HeaderText="职务" DataField="Title"/>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -