留言簿

不好意思，版主，我是楼下那位．是我犯了个小错误，现在好了．谢谢您！

我使用您的控件对dataList进行分页，点击分页数字时DataList的数据始终不变，也就是就说没有转到另一页．
而且，我设置了pager.pagesize＝3，但DataList只显示一条记录．
PageChang事件已写．

我也想学习一下定制控件，可是看网上的一些源码，总是感觉看不大懂。网上的一些资料很少有关于定制控件的。该如何能系统的学习到定制控件？想听您点建议！

网站前段时间好象访问不了！

呵呵，我遇到同样的问题了。在安装AspNetPager.msi时，出现
无法安装，错误信息如下： ================================================ 指定的路径'http://intel/AspNetPager'不可用。Internet Infomation Server 可能并未运行或者路径已重定向到另外的计算机。请检查Internet Infomation Server 中虚拟目录的状态
其中intel是主机名。而我的iis已经开了。当然也没重定向啦！！
怎么搞定啊！！
谢谢啦！！

新增@tablefield参数.
如果@tablefield的字段名为@tablename的字段则正确,而如果是根据@tablename内的字段取另一库中的字段值,则出错(第一次载入不出错,点击页码出错).
存储过程:
ALTER procedure GsjyShowDGProcessor
(
 @pagesize int,
 @pageindex int,
 @docount bit,
 @where nvarchar(1000),
 @tablename nvarchar(10),
 @tableField nvarchar(400)
)
as
set nocount on
       declare @RecordCount int 
       declare @sqlStr nVarchar(2000) 
       set @sqlstr='select @RecordCount=count(*)  from '+@tablename+'  '+@where
       exec sp_executesql @sqlstr,N'@RecordCount int output',@RecordCount output
if(@docount=1)
select @RecordCount
else
begin
if(@pageindex=1)
exec('select top '+@pagesize+'  '+@tableField+'  from '+@tablename+'  '+@where+' order by indextime desc')
else
begin
declare @PageUpperBound int
declare @endrecords int
set @PageUpperBound=@pageindex*@pagesize
if(@PageUpperBound-@pagesize)>=@RecordCount
select ''
else if(@RecordCount-(@PageUpperBound-@pagesize)<=@pagesize)
begin
set @endrecords=@RecordCount-(@PageUpperBound-@pagesize)
exec('select '+'   '+@tableField+' from (select top '+@endrecords+'   '+@tableField+'  from '+@tablename+'  '+@where+' order by indextime)A order by indextime desc')
end
else
exec('select '+'   '+@tableField+' from (select top '+@pagesize+'     '+@tableField+'  from (select top  '+@PageUpperBound+'   '+@tableField+'  from '+@tablename+'  '+@where+' order by indextime desc)A order by indextime)B order by indextime desc')
end
end
set nocount off

传入的tablefield:
                TableField= " *,zouzheemail=(select email from gsjyuserlist where account=news.zouzhe,checkemail=(select  email from gsjyuserlist where account = news.checkname)"

我应该怎样更改存储过程.

exec('select '+'   '+@tableField+' from (select top '+@endrecords+'   '+@tableField+'  from '+@tablename+'  '+@where+' order by indextime)A order by indextime desc')
end
else
exec('select '+'   '+@tableField+' from (select top '+@pagesize+'     '+@tableField+'  from (select top  '+@PageUpperBound+'   '+@tableField+'  from '+@tablename+'  '+@where+' order by indextime desc)A order by indextime)B order by indextime desc')
这两条语句,当
@tablefield为
              " *,zouzheemail=(select email from gsjyuserlist where account=news.zouzhe),checkemail=(select  email from gsjyuserlist where account = news.checkname)"
时出错.
出错提示:
异常详细信息: System.Data.SqlClient.SqlException: 列前缀 'news' 与查询中所用的表名或别名不匹配。

请教：我从数据库中读文字类型的字段，显示的是乱码。怎么解决？

看了您的网站，欣赏了您的成就，虽然我还没有试用您的成果——感动ing！我想它一定能够解决许多问题。谢谢您的劳动！

顺带问一句，能否推荐一个支持拖放的好用的、非Demo的treeview控件？
再次感谢！

1:ALTER procedure GsjyShowDGProcessor
2:(@where varchar(100),
3:@pagesize int,
4:@pageindex int,
5:@docount bit)
6:as
7:set nocount on
8:declare @RecordCount int
9:select @RecordCount=count (id) from news
10:if(@docount=1)
11:select @RecordCount
12:else
13:begin
14:if(@pageindex=1)
15:exec('select top '+@pagesize+'* from news'+@where+' order by indextime desc')
16:else
17:begin
18:declare @PageUpperBound int
19:declare @endrecords int
20:set @PageUpperBound=@pageindex*@pagesize
21:if(@PageUpperBound-@pagesize)>=@RecordCount
22:select ''
23:else if(@RecordCount-(@PageUpperBound-@pagesize)<=@pagesize)
24:begin
25:set @endrecords=@RecordCount-(@PageUpperBound-@pagesize)
26:exec('select * from (select top '+@endrecords+' * from news'+@where+' order by 27:indextime)A order by indextime desc')
28:end
29:else
30:exec('select * from (select top '+@pagesize+'* from (select top '+@PageUpperBound+' 31:* from news'+@where+' order by indextime desc)A order by indextime)B order by 32:indextime desc')
33:end
34:end
35:set nocount off
我设置了where参数,字符串如"where a='1'and b='2'and c='3'...."是程序中动态生成的.
我应该如何更改第9行,才能得到where条件下的RecordCount的值,试了半天都不行,
select @RecordCount=count (id) from news ?????????????
怎么添加后面的语句,谢谢.