关于手写datareader分页程序的一段代码,有点小错误,呵呵,20分表心意!!!!!
主代码是这些:
public partial class iframefordiscovery: System.Web.UI.Page
{
public string html;
public OleDbConnection conn;
int RecordCount, PageCount, CurrentPage, PageSize, startID, endID;
public void Page_Load(Object sender, EventArgs e)
{
if(!IsPostBack)
{
PageSize = 15;
RecordCount = CalculateRecord();
PageCount = RecordCount / PageSize;
if (RecordCount % PageSize > 0)
PageCount = PageCount + 1;
lblPageCount.Text = PageCount.ToString();
lblRecordCount.Text = RecordCount.ToString();
CurrentPage = 0;
}
}
protected void tohtml()
{
string startIDt, endIDt;
startID = 0;
endID = 0;
startIDt = Request.Params[ "sid "];
endIDt = Request.Params[ "eid "];
string ConnStr = "select top " + PageSize + " * from discovery ";
**************问题出现在这里*********************************************
if (startIDt != null)
{
startID = Convert.ToInt32(startIDt);
if (startID > 0)
{
ConnStr += " where identifier < " + startID;
}
}
if (endIDt != null)
&nbs