首页没反应,按下一页时地址栏的地址改变了,但是显示的数据没变using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using System.Configuration;/// <summary>
///fenye 的摘要说明
/// </summary>
public class fenye
{
public static string connstr = ConfigurationManager.ConnectionStrings["valuationConnectionString"].ConnectionString;
public SqlConnection conn; #region 属性
private string fields;
private string fieldkey;
private string tablename;
private int pageindex;
private int pagesize = 10;
private string pagename;
private string address;
private string operation = "";
public string Fields
{
get { return fields; }
set { fields = value; }
}
public string Fieldkey
{
get { return fieldkey; }
set { fieldkey = value; }
}
public string TableName
{
get { return tablename; }
set { tablename = value; }
}
public int PageIndex
{
get { return pageindex; }
set { pageindex = value; }
}
public int PageSize
{
get { return pagesize; }
set { pagesize = value; }
}
public string PageName
{
get { return pagename; }
set { pagename = value; }
}
public string Address
{
get { return address; }
set { address = value; }
}
public string Operation
{
get { return operation; }
set { operation = value; }
}
#endregion #region public string feye()
{
StringBuilder str = new StringBuilder();
string sql = "select" + Fields + " from(select" + Fields + ",row_number() over(order by " + Fieldkey + ")as number from " + TableName + ")as temp where temp.number between((@pageindex*@pagesize)-(@pagesize-1))and(@pageindex*@pagesize)";
conn = new SqlConnection(connstr);
String stra = "";
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.SelectCommand.CommandType = CommandType.Text;
da.SelectCommand.Parameters.Add("pageindex", SqlDbType.Int);
da.SelectCommand.Parameters.Add("pagesize", SqlDbType.Int);
da.SelectCommand.Parameters[0].Value = PageIndex;
da.SelectCommand.Parameters[1].Value = PageSize;
DataSet ds = new DataSet();
da.Fill(ds);
str.Append("<table border=1 width=100% align=center >");
str.Append("<tr>");
for (int irow = 0; irow < ds.Tables[0].Columns.Count - 1; irow++)
{
str.AppendFormat("<th>{0}</th>", ds.Tables[0].Columns[irow].ColumnName.ToString());
} str.Append("<th>操作</th>"); str.Append("</tr>");
for (int jrow = 0; jrow < ds.Tables[0].Rows.Count; jrow++)
{
str.Append("<tr>");
for (int icol = 0; icol < ds.Tables[0].Columns.Count - 1; icol++)
{
if (ds.Tables[0].Rows[jrow][icol] != null)
{
str.AppendFormat("<td>{0}</td>", ds.Tables[0].Rows[jrow][icol].ToString());
}
else
{
str.Append("<td> </td>");
}
}
if (Operation == "" || Operation.Length == 0)
{
str.Append("<td> </td>");
}
else
{
stra = Operation.Replace("aspx?id=", ("aspx?id=" + ds.Tables[0].Rows[jrow][0].ToString()));
str.AppendFormat("<td align=\"center\">{0}</td>", stra);
}
str.Append("</tr>");
}
str.Append("</table>");
return str.ToString() + dispalypage();
} catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close(); }
}
public int getpagecount()
{
conn = new SqlConnection(connstr);
string sql = "select count(" + Fieldkey + ") from " + TableName;
try
{
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
int zs = Convert.ToInt16(comm.ExecuteScalar());
return zs;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close();
} } public string dispalypage()
{
StringBuilder str = new StringBuilder();
int recordtotle = getpagecount();
int pagetotle = 0;
if (recordtotle % PageSize == 0)
{
pagetotle = recordtotle / PageSize;
}
else
{
pagetotle = recordtotle / PageSize + 1;
}
str.Append("<table>border=1 width=100%");
str.Append("<tr><td align=center>");
str.AppendFormat("共有 {0} 记录, 当前第{1}页; <a herf={2}?pageindexa={1}>首页</a>  ", recordtotle,PageIndex, PageName);
if (pageindex > 1)
{
str.AppendFormat("<a href={0}?pageindexa={1}>上一页</a> ", PageName, Convert.ToString(PageIndex - 1));
}
if (pageindex < pagetotle)
{
str.AppendFormat("<a href={0}?pageindexa={1}>下一页</a> ", PageName, Convert.ToString(PageIndex + 1));
}
str.AppendFormat("<a href={0}?pageindexa={1}>尾页</a>", PageName, pagetotle.ToString());
str.Append("</td></tr></table>");
conn.Close();
return str.ToString();
}
#endregion}
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using System.Configuration;/// <summary>
///fenye 的摘要说明
/// </summary>
public class fenye
{
public static string connstr = ConfigurationManager.ConnectionStrings["valuationConnectionString"].ConnectionString;
public SqlConnection conn; #region 属性
private string fields;
private string fieldkey;
private string tablename;
private int pageindex;
private int pagesize = 10;
private string pagename;
private string address;
private string operation = "";
public string Fields
{
get { return fields; }
set { fields = value; }
}
public string Fieldkey
{
get { return fieldkey; }
set { fieldkey = value; }
}
public string TableName
{
get { return tablename; }
set { tablename = value; }
}
public int PageIndex
{
get { return pageindex; }
set { pageindex = value; }
}
public int PageSize
{
get { return pagesize; }
set { pagesize = value; }
}
public string PageName
{
get { return pagename; }
set { pagename = value; }
}
public string Address
{
get { return address; }
set { address = value; }
}
public string Operation
{
get { return operation; }
set { operation = value; }
}
#endregion #region public string feye()
{
StringBuilder str = new StringBuilder();
string sql = "select" + Fields + " from(select" + Fields + ",row_number() over(order by " + Fieldkey + ")as number from " + TableName + ")as temp where temp.number between((@pageindex*@pagesize)-(@pagesize-1))and(@pageindex*@pagesize)";
conn = new SqlConnection(connstr);
String stra = "";
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.SelectCommand.CommandType = CommandType.Text;
da.SelectCommand.Parameters.Add("pageindex", SqlDbType.Int);
da.SelectCommand.Parameters.Add("pagesize", SqlDbType.Int);
da.SelectCommand.Parameters[0].Value = PageIndex;
da.SelectCommand.Parameters[1].Value = PageSize;
DataSet ds = new DataSet();
da.Fill(ds);
str.Append("<table border=1 width=100% align=center >");
str.Append("<tr>");
for (int irow = 0; irow < ds.Tables[0].Columns.Count - 1; irow++)
{
str.AppendFormat("<th>{0}</th>", ds.Tables[0].Columns[irow].ColumnName.ToString());
} str.Append("<th>操作</th>"); str.Append("</tr>");
for (int jrow = 0; jrow < ds.Tables[0].Rows.Count; jrow++)
{
str.Append("<tr>");
for (int icol = 0; icol < ds.Tables[0].Columns.Count - 1; icol++)
{
if (ds.Tables[0].Rows[jrow][icol] != null)
{
str.AppendFormat("<td>{0}</td>", ds.Tables[0].Rows[jrow][icol].ToString());
}
else
{
str.Append("<td> </td>");
}
}
if (Operation == "" || Operation.Length == 0)
{
str.Append("<td> </td>");
}
else
{
stra = Operation.Replace("aspx?id=", ("aspx?id=" + ds.Tables[0].Rows[jrow][0].ToString()));
str.AppendFormat("<td align=\"center\">{0}</td>", stra);
}
str.Append("</tr>");
}
str.Append("</table>");
return str.ToString() + dispalypage();
} catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close(); }
}
public int getpagecount()
{
conn = new SqlConnection(connstr);
string sql = "select count(" + Fieldkey + ") from " + TableName;
try
{
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
int zs = Convert.ToInt16(comm.ExecuteScalar());
return zs;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close();
} } public string dispalypage()
{
StringBuilder str = new StringBuilder();
int recordtotle = getpagecount();
int pagetotle = 0;
if (recordtotle % PageSize == 0)
{
pagetotle = recordtotle / PageSize;
}
else
{
pagetotle = recordtotle / PageSize + 1;
}
str.Append("<table>border=1 width=100%");
str.Append("<tr><td align=center>");
str.AppendFormat("共有 {0} 记录, 当前第{1}页; <a herf={2}?pageindexa={1}>首页</a>  ", recordtotle,PageIndex, PageName);
if (pageindex > 1)
{
str.AppendFormat("<a href={0}?pageindexa={1}>上一页</a> ", PageName, Convert.ToString(PageIndex - 1));
}
if (pageindex < pagetotle)
{
str.AppendFormat("<a href={0}?pageindexa={1}>下一页</a> ", PageName, Convert.ToString(PageIndex + 1));
}
str.AppendFormat("<a href={0}?pageindexa={1}>尾页</a>", PageName, pagetotle.ToString());
str.Append("</td></tr></table>");
conn.Close();
return str.ToString();
}
#endregion}
解决方案 »
- 弱弱的问个ajax的问题
- asp.net 如何实现调用人人网API发布状态
- 发个今天遇到的奇怪问题
- 求助,DataGrid 读取表中图片时,图片显示不完整
- 如何在WEB应用程序中动态创建“数据库链接”,并进行多库间的数据联合查询??
- aspnetmenu控件的xml可以用其他数据库吗? 如mssql2000,我想只有用动态查询才能解决好根据权限显示栏目的问题了.
- * 如何编写支持设计时集合属性的Web控件?
- SQL语句 高手进
- 怎样上传文件?
- 攒钱机会:我公司正在采购邮件服务系统(WEB)版,合适的开发商或个人赶紧报价以及给一份解决方案说明。急用!!
- 关于ajax的问题
- 页面调用用户控件没有触发用户控件的事件
aspnetpager分页
da.SelectCommand.Parameters.Add("pageindex", SqlDbType.Int);
da.SelectCommand.Parameters.Add("pagesize", SqlDbType.Int);
----
错误1:参数名前面要加“@”--
错误2:da.SelectCommand.Parameters.Add的是SQLParameter对象或者其它类似OLEDBParameter对象,似乎应该写成da.SelectCommand.Parameters.Add(new SQLParameter("pagesize", SqlDbType.Int));