?? default.aspx
字號:
<% @ Page Language="C#" debug="true" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<%
Response.Write(Session["username"]);
%>
您好！你目前的工作列表為：
<html>
<body>
<Form runat="server">
<asp:DataGrid
AllowPaging="True"
PageSize="5"
PagerStyle-HorizontanAlign="Right"
PagerStyle-Mode="NumericPages"
OnPageindexChanged="ChangePage"
Headerstyle-BackColor="#AAAADD"
AlternatingItemStyle-BackColor="#FFFFCD"
BorderColor="Black"
CellPadding="2"
CellSpacing="0"
AutoGenerateColumns="false"
id="Grid1" runat="server">
<Columns>
<asp:HyperLinkColumn DataTextField="wname"
HeaderText="wname"
DataNavigateUrlField="wname"
DataNavigateUrlFormatString="detail.aspx?id={0}"
Target="_blank" />
<asp:BoundColumn DataField="srole" HeaderText="srole" />
</Columns>
</asp:DataGrid>
</Form></body></html>
<script language="C#" runat="server">
int startIndex;
void BindGrid()
{
String Provider,DataBase,ConnStr,SQL;
//第一步: 進行數據庫的鏈接
Provider="Microsoft.Jet.OLEDB.4.0;";
DataBase=Server.MapPath("../db/workflow.mdb");
ConnStr="Provider="+Provider+"Data Source="+DataBase;
//第二步：執行SQL指令，選出記錄集合
OleDbDataAdapter da;
string sql="Select * From workstep where srole='"+Session["username"]+"' and sflag='0'";
da=new OleDbDataAdapter(sql,ConnStr);
DataSet ds=new DataSet();
da.Fill(ds,"workstep");
//第三步：將數據集合同DataGrid結合在一起
Grid1.DataSource=ds.Tables["workstep"].DefaultView;
Grid1.DataBind();
}
void Page_Load(Object src,EventArgs e)
{
if(!IsPostBack) {
startIndex =0;
}
BindGrid();
}
void ChangePage(Object sender, DataGridPageChangedEventArgs e)
{
startIndex = e.NewPageIndex*Grid1.PageSize;
Grid1.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}
</script>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -