20分的一路难题.多条件AspNetPager的

20分的一道难题..多条件AspNetPager的
我用AspNetPager存储过程可以很轻松的分页.
但是如果涉及到多条件查询的话,应该怎么办呢?

以下是我的多条件查询语句.怎么把这些做成AspNetPager分页.或者其它办法分页..
AspNetPager可以不用存储过程来分页吗?直接T-SQL运行..

  string   str   =   "select   count(lease_id)   as   [coun]   from   lease   where   lease_daodate   >   getdate() ";   //记录条数
                if   (Select1.Value   !=   "0 ")
                {
                        str   +=   "   and   city   =   ' "   +   county.Value.ToString()   +   " ' ";
                }
                if   (Select2.Value   !=   "选择 ")
                {
                        str   +=   "   and   hx   =   ' "   +   Select2.Value.ToString()   +   " ' ";

                }
                if   (Select3.Value   !=   "选择 ")
                {
                        str   +=   "   and   fitment   =   ' "   +   Select3.Value.ToString()   +   " ' ";

                }
                if   (txprice1.Value   !=   " "   ||   txprice2.Value   !=   " ")
                {
                        str   +=   "   and   lease_price   >   ' "   +   txprice1.Value.ToString()   +   " '   and   lease_price   <     ' "   +   txprice2.Value.ToString()   +   " ' ";
                                      }
                str   +=   "   order   by   id   desc ";
                str1   +=   "   order   by   id   desc ";
                str2   +=   "   order   by   id   desc ";


[解决办法]
记住中间要有and,有思路你自己就能写好了
[解决办法]
aspnetpager跟数据源无关，所以你用什么都没关系,只要能根据(当前页\页大小\总数)取分页数据
[解决办法]
AspNetPager应该和存储过程没关系吧，但是分页的存储过程肯定是最好的选择，你可以找一个通用的分页存储过程
[解决办法]
见http://www.cnblogs.com/meetweb/archive/2005/09/13/140239.html
其实最重要的问题就在
Select Top {0} * From User Where user_id Not in ( Select Top {1} user_id From User Order By user_id

使用sql本身已经把要分页的数据取出来。。其实DataGrid只是绑定显示而已。AspNetPager只是做了显示页码等数据显示而已

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack )
{
//求该数据集合的记录总和
SqlDataBase SqlDB=new SqlDataBase(DSN);
string strsql= "Select count(user_id) from User ";
DataSet ds= SqlDB.CreateSet(strsql, "IUser ");
this.AspNetPager1.RecordCount=System.Convert.ToInt32(ds.Tables[0].Rows[0][0]) ;
SqlDB.CloseConnection();
BindData();
}
}

void BindData()
{
SqlDataBase SqlDB=new SqlDataBase(DSN);

int RecordPage=(AspNetPager1.CurrentPageIndex-1)*AspNetPager1.PageSize;
string strsql=String.Format( " Select Top {0} * From User Where user_id Not in ( Select Top {1} user_id From User Order By user_id) ",AspNetPager1.PageSize.ToString(),RecordPage.ToString());
SqlDataAdapter adapter= SqlDB.CreateAdapter(strsql);
DataSet ds=new DataSet();
ds=SqlDB.CreateSet(strsql, "IUser ");
//adapter.Fill(ds,AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize, "IU_User ");
this.DataGrid1.DataSource=ds.Tables[ "IUser "];
this.DataGrid1.DataBind();
//动态设置用户自定义文本内容
AspNetPager1.CustomInfoText= "记录总数： <font color=\ "blue\ "> <b> "+AspNetPager1.RecordCount.ToString()+ " </b> </font> ";
AspNetPager1.CustomInfoText+= " 总页数： <font color=\ "blue\ "> <b> "+AspNetPager1.PageCount.ToString()+ " </b> </font> ";
AspNetPager1.CustomInfoText+= " 当前页： <font color=\ "red\ "> <b> "+AspNetPager1.CurrentPageIndex.ToString()+ " </b> </font> ";
}

private void AspNetPager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
{
AspNetPager1.CurrentPageIndex=e.NewPageIndex;
BindData();
System.Text.StringBuilder sb=new StringBuilder( " <script Language=\ "Javascript\ "> <!--\n ");
sb.Append( "var el=document.all; ");
sb.Append(this.DataGrid1.ClientID);
sb.Append( ".scrollIntoView(true); ");
sb.Append( " < ");
sb.Append( "/ ");
sb.Append( "script> ");
if(!Page.IsStartupScriptRegistered( "scrollScript "))
Page.RegisterStartupScript( "scrollScript ",sb.ToString());
}