/**//// <summary> return ds; /**//// <summary> string sql; }
/// 返回数据集
/// </summary>
/// <param name=”sql”></param>
/// <returns></returns>
public DataSet GetData(string sql,string strconn)
{
OleDbConnection ole=new OleDbConnection(“PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=”+strconn);
ole.Open();
OleDbCommand cm=new OleDbCommand(sql,ole);
DataSet ds=new DataSet();
OleDbDataAdapter da=new OleDbDataAdapter(cm);
da.Fill(ds);
ole.Close();
}
/// 分页
/// </summary>
/// <param name=”pagesize”>每页大小</param>
/// <param name=”pageindex”>当前页数</param>
/// <param name=”field”>获取字段名</param>
/// <param name=”tablename”>表名</param>
/// <param name=”orderfield”>排序字段</param>
/// <param name=”taxis”>排序方式,true为升序,false为降序</param>
/// <param name=”condition”>满足的条件</param>
/// <returns></returns>
public DataSet GetPage(int pagesize,int pageindex,string field,string tablename,string orderfield,bool taxis,string condition)
{
string temp;
if(taxis)
{
temp=”asc”;
}
else
{
temp=”desc”;
}
if(pageindex==1)
{
if(condition==””)
{
sql=”select top “+pagesize+” “+field+” from “+tablename+” order by “+orderfield+” “+temp;
return GetData(sql);
}
else
{
sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+condition+” order by “+orderfield+” “+temp;
return GetData(sql);
}
}
else
{
pageindex=(pageindex-1)*pagesize;
if(condition==””)
{
if(taxis)
{
sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+orderfield+”>all(select top “+pageindex+” “+orderfield+” from “+tablename+” order by “+orderfield+” “+temp+”) order by “+orderfield+” “+temp;
}
else
{
sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+orderfield+”<all(select top “+pageindex+” “+orderfield+” from “+tablename+” order by “+orderfield+” “+temp+”) order by “+orderfield+” “+temp;
}
return GetData(sql);
}
else
{
if(taxis)
{
sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+condition+” and “+orderfield+”>all(select top “+pageindex+” “+orderfield+” from “+tablename+” where “+condition+” order by “+orderfield+” “+temp+”) order by “+orderfield+” “+temp;
}
else
{
sql=”select top “+pagesize+” “+field+” from “+tablename+” where “+condition+” and “+orderfield+”<all(select top “+pageindex+” “+orderfield+” from “+tablename+” where “+condition+” order by “+orderfield+” “+temp+”) order by “+orderfield+” “+temp;
}
return GetData(sql);
}
}
希望给于评价
http://www.cnblogs.com/wang123/archive/2006/12/08/586505.html
手写分页函数c#_c#应用
版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com 特别注意:本站所有转载文章言论不代表本站观点! 本站所提供的图片等素材,版权归原作者所有,如需使用,请与原作者联系。未经允许不得转载:IDC资讯中心 » 手写分页函数c#_c#应用
相关推荐
-      利用c#远程存取access数据库_c#应用
-      c# 3.0新特性系列:隐含类型var_c#教程
-      c#动态生成树型结构的web程序设计_c#应用
-      论c#变得越来越臃肿是不可避免的_c#应用
-      用c#监控并显示cpu状态信息_c#应用
-      c#中实现vb中的createobject方法_c#应用
-      photoshop给花瓶打造彩绘效果_photoshop教程
-      使用c#创建sql server的存储过程_c#应用