using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;public partial class PagerView : System.Web.UI.Page
{
private int pageNum; public int PageNum
{
get { return int.Parse(ViewState["pageNum"].ToString()); }
set { ViewState["pageNum"] = value; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["pageNum"] = 1;
}
}
public string pager()
{
if (string.IsNullOrEmpty(Request.QueryString["pager"]))
{
PageNum = 1;
return PageNum.ToString();
}
if (Request.QueryString["pager"] == "next")
{
PageNum = PageNum + 1;
return PageNum.ToString();
}
if (Request.QueryString["pager"] == "before")
{
PageNum = PageNum - 1;
return PageNum.ToString();
}
return null;
}
public string PrintTable(string pageNum,int pageSize)
{
pageSize = 10;
PageNum = int.Parse(pageNum);
string result = "";
SqlParameter[] par = new SqlParameter[]{
new SqlParameter("@pagenum",PageNum),
new SqlParameter("@pagesize",pageSize)
};
DataTable dt = getPager("pager",par);
result +="<table>";
result += "<tr>";
result += "<td>序号</td>";
result += "<td>id</td>";
result += "<td>名称</td>";
result += "<td>用户名</td>";
result += "<td>密码</td>";
result += "</tr>";
for (int i = 0; i < dt.Rows.Count; i++)
{
result += "<tr>";
result += "<td>"+dt.Rows[i]["rownum"].ToString()+"</td>";
result += "<td>" + dt.Rows[i]["id"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["title"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["uid"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["pwd"].ToString() + "</td>";
result += "</tr>";
}
result += "</table>";
return result;
} /// <summary>
/// 数据库连接,返回DataTable类型
/// </summary>
/// <param name="sql"></param>
/// <param name="par"></param>
/// <returns></returns>
public DataTable getPager(string sql,params SqlParameter[] par)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection("server=.;database=text;uid=sa;pwd=cc");
conn.Open();
SqlCommand command = new SqlCommand();
command.CommandText = sql;
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddRange(par);
SqlDataAdapter sda = new SqlDataAdapter(command);
sda.Fill(dt);
conn.Close();
return dt;
}
}
前台代码:
<body>
<form id="form1" runat="server">
<div id="print">
</div>
<a href="PagerView.aspx?pager=before" onclick="" >上一页</a>
<a href="PagerView.aspx?pager=next" onclick="" >下一页</a>
<script type="text/javascript">
var str = "<%=PrintTable(pager(),10) %>";
document.getElementById('print').innerHTML += str;
</script>
</form>
</body>
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;public partial class PagerView : System.Web.UI.Page
{
private int pageNum; public int PageNum
{
get { return int.Parse(ViewState["pageNum"].ToString()); }
set { ViewState["pageNum"] = value; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["pageNum"] = 1;
}
}
public string pager()
{
if (string.IsNullOrEmpty(Request.QueryString["pager"]))
{
PageNum = 1;
return PageNum.ToString();
}
if (Request.QueryString["pager"] == "next")
{
PageNum = PageNum + 1;
return PageNum.ToString();
}
if (Request.QueryString["pager"] == "before")
{
PageNum = PageNum - 1;
return PageNum.ToString();
}
return null;
}
public string PrintTable(string pageNum,int pageSize)
{
pageSize = 10;
PageNum = int.Parse(pageNum);
string result = "";
SqlParameter[] par = new SqlParameter[]{
new SqlParameter("@pagenum",PageNum),
new SqlParameter("@pagesize",pageSize)
};
DataTable dt = getPager("pager",par);
result +="<table>";
result += "<tr>";
result += "<td>序号</td>";
result += "<td>id</td>";
result += "<td>名称</td>";
result += "<td>用户名</td>";
result += "<td>密码</td>";
result += "</tr>";
for (int i = 0; i < dt.Rows.Count; i++)
{
result += "<tr>";
result += "<td>"+dt.Rows[i]["rownum"].ToString()+"</td>";
result += "<td>" + dt.Rows[i]["id"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["title"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["uid"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["pwd"].ToString() + "</td>";
result += "</tr>";
}
result += "</table>";
return result;
} /// <summary>
/// 数据库连接,返回DataTable类型
/// </summary>
/// <param name="sql"></param>
/// <param name="par"></param>
/// <returns></returns>
public DataTable getPager(string sql,params SqlParameter[] par)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection("server=.;database=text;uid=sa;pwd=cc");
conn.Open();
SqlCommand command = new SqlCommand();
command.CommandText = sql;
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddRange(par);
SqlDataAdapter sda = new SqlDataAdapter(command);
sda.Fill(dt);
conn.Close();
return dt;
}
}
前台代码:
<body>
<form id="form1" runat="server">
<div id="print">
</div>
<a href="PagerView.aspx?pager=before" onclick="" >上一页</a>
<a href="PagerView.aspx?pager=next" onclick="" >下一页</a>
<script type="text/javascript">
var str = "<%=PrintTable(pager(),10) %>";
document.getElementById('print').innerHTML += str;
</script>
</form>
</body>
解决方案 »
- ==========【囧】Timer 定时器老是自动停掉,怎么解决??========
- 点“后退”键后退的页面不再刷新,还是保留以前操作过的状态
- webdatagrid 的问题~~~~~~急~~~~~~~~~~~
- 如何将ocx控件转换成asp.net上可使用的控件
- dateview中刪除數據怎樣更新到數據庫,急!!!!
- 菜鸟:一段小代码调不出来了,大家帮帮忙~
- ASP.NET调用参数问题!请高手帮忙 急!~!~
- 关于DATAGRID的数据列。
- 很弱智的问题
- 哪儿有大的关于ASP.NET的例子,谢谢!
- 【火狐不缓存,ie缓存了,真心就解,望高人解救】
- 在asp.net里面怎么获取到当前浏览器地址栏输入的地址的域名部分或者是IP
[code=C#]
public void pager()
{
if (string.IsNullOrEmpty(Request.QueryString["pager"]))
{
ViewState["pageNum"]=1;
}
if (Request.QueryString["pager"] == "next")
{
ViewState["pageNum"]=(int)ViewState["pageNum"]+1;
}
if (Request.QueryString["pager"] == "before")
{
ViewState["pageNum"]=(int) ViewState["pageNum"]-11
}
} public string PrintTable(string pageNum,int pageSize)
{
pageSize = 10;
int PageNum = (int)ViewState["pageNum"];
string result = "";
SqlParameter[] par = new SqlParameter[]{
new SqlParameter("@pagenum",PageNum),
new SqlParameter("@pagesize",pageSize)
};
DataTable dt = getPager("pager",par);
result +="<table>";
result += "<tr>";
result += "<td>序号</td>";
result += "<td>id</td>";
result += "<td>名称</td>";
result += "<td>用户名</td>";
result += "<td>密码</td>";
result += "</tr>";
for (int i = 0; i < dt.Rows.Count; i++)
{
result += "<tr>";
result += "<td>"+dt.Rows[i]["rownum"].ToString()+"</td>";
result += "<td>" + dt.Rows[i]["id"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["title"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["uid"].ToString() + "</td>";
result += "<td>" + dt.Rows[i]["pwd"].ToString() + "</td>";
result += "</tr>";
}
result += "</table>";
return result;
}code]
这个 你调试一下。理解一下 页面加载顺序。
{
//这里判断一下是否是最后一页
if()//不是最后一页
{
ViewState["pageNum"]=(int)ViewState["pageNum"]+1;
}
else//最后一页
{
ViewState["pageNum"]=100;// 赋值最后页数
}
}
if (Request.QueryString["pager"] == "before")
{
if((int) ViewState["pageNum"]>=1)
{
ViewState["pageNum"]=(int) ViewState["pageNum"]-1;
}
else
{
ViewState["pageNum"]=0;
}
}