留言簿

看完你编写的控件代码，甚是佩服。尽管没有看懂。不知道我什么时候能达到你的水平？太有才了。。<br><br>还想问个问题：上一页和下一页的连接可以在数据连接的。比如右边。如图：<br> 1 2 3 4 5 6 ... 上一页 下一页<br><br>如果能讲解一下代码。那就更好不过了。<br>jyx0206@sina.com

可以了.,我以为朋友帮我搞定了

我下载了AspNetPagerSamples<br>运行超时啊,要不要配置sql啊 ,比如附加数据库到sql2000啊

我的aspx文件这样的<br>&lt;%@ Page language=&quot;c#&quot; Inherits=&quot;meet.main.joinedit&quot; CodeFile=&quot;joinedit.aspx.cs&quot; %&gt;<br>&lt;%@Register TagPrefix=&quot;Webdiyer&quot; Namespace=&quot;Wuqi.Webdiyer&quot; Assembly=&quot;aspnetpager&quot;%&gt;<br>&lt;%@ Register TagPrefix=&quot;H&quot; TagName=&quot;Header&quot; Src=&quot;../inc/Header.ascx&quot; %&gt;<br>&lt;%@ Register TagPrefix=&quot;F&quot; TagName=&quot;Footer&quot; Src=&quot;../inc/Footer.ascx&quot; %&gt;<br>&lt;!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.0 Transitional//EN&quot; &gt;<br>&lt;HTML&gt;<br>	&lt;HEAD&gt;<br>		&lt;title&gt;joinedit&lt;/title&gt;<br>		&lt;meta name=&quot;GENERATOR&quot; Content=&quot;Microsoft Visual Studio .NET 7.1&quot;&gt;<br>		&lt;meta name=&quot;CODE_LANGUAGE&quot; Content=&quot;C#&quot;&gt;<br>		&lt;meta name=&quot;vs_defaultClientScript&quot; content=&quot;JavaScript&quot;&gt;<br>		&lt;meta name=&quot;vs_targetSchema&quot; content=&quot;http://schemas.microsoft.com/intellisense/ie5&quot;&gt;<br>		&lt;Link href=&quot;../inc/meet.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;&gt;<br>	&lt;/HEAD&gt;<br>	&lt;body&gt;<br>		&lt;form id=&quot;Form1&quot; method=&quot;post&quot; runat=&quot;server&quot;&gt;<br>			&lt;H:Header id=&quot;Header&quot; runat=&quot;server&quot; /&gt;<br>		<br>						&lt;table align=&quot;center&quot; style=&quot;WIDTH: 1px; HEIGHT: 224px&quot;&gt;<br>							<br>								&lt;tr&gt;<br>									&lt;th align=&quot;center&quot; height=&quot;35&quot; colspan=&quot;6&quot; style=&quot;width: 454px&quot;&gt;<br>										&lt;asp:label id=&quot;ClassForm_Title&quot; runat=&quot;server&quot;&gt; 参展商信息管理 &lt;/asp:label&gt;&lt;/th&gt;<br>								&lt;/tr&gt;<br>						<br>										&lt;asp:Repeater id=&quot;class_Repeater&quot; runat=&quot;server&quot;&gt;<br>									<br>								&lt;ItemTemplate&gt;<br>									&lt;tr&gt;<br>									<br>										&lt;td bgcolor=&quot;#FFFFFF&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;%#Server.Ht

我的cs文件代码这样的<br>using System;<br>using System.Collections;<br>using System.ComponentModel;<br>using System.Data;<br>using System.Drawing;<br>using System.Web;<br>using System.Web.SessionState;<br>using System.Web.UI;<br>using System.Web.UI.WebControls;<br>using System.Web.UI.HtmlControls;<br>using System.Data.SqlClient;<br>using System.Configuration;<br><br>namespace meet.main<br>{<br>	/// &lt;summary&gt;<br>	/// joinedit 的摘要说明。<br>	/// &lt;/summary&gt;<br>	public partial class joinedit : System.Web.UI.Page<br>	{<br>		protected System.Web.UI.HtmlControls.HtmlTableRow class_no_records;<br>		SqlConnection cn;<br>	<br>		protected void Page_Load(object sender, System.EventArgs e)<br>		{<br>			// 在此处放置用户代码以初始化页面<br>            if (Session[&quot;user&quot;] == null){<br>                Response.Redirect(&quot;admin.aspx&quot;);<br>            }<br>			string strconn=ConfigurationSettings.AppSettings[&quot;ConnectionString&quot;];<br>			cn=new SqlConnection(strconn);<br>            if (!IsPostBack)<br>            {<br>                FirstBindData();<br>                //BindData();<br><br>            }<br>            else<br>            {<br>                BindData();<br>            }<br>		}<br>		<br><br><br>        public void FirstBindData()<br>        {<br>            SqlCommand cmd = new SqlCommand(&quot;z_list&quot;, cn);<br>            cmd.CommandType = CommandType.StoredProcedure;<br>            cmd.Parameters.Add(&quot;@pageindex&quot;, 1);<br>            cmd.Parameters.Add(&quot;@pagesize&quot;, 1);<br>            cmd.Parameters.Add(&quot;@docount&quot;, true);<br>            cn.Open();<br>            pager.RecordCount = (int)cmd.ExecuteScalar();<br>            cn.Close();<br>            BindData();<br>        }<br><br>        public void BindData()<br>        {<br>            SqlCommand cmd = new SqlCommand();<br>            cmd.Connection = cn;<br>            cmd.CommandType = CommandType.StoredProcedure;<br>            cmd.CommandText = &quot;z_list&quot;;<br> 

我就用vs2005啊,昨天弄出来了,还差点,高手帮我写存储过程了,把老师的存储过程注释了.给你看看.存储过程有问题啊,他这个存储过程能用,但是有错误啊,分页出错啊,<br>SET QUOTED_IDENTIFIER ON <br>GO<br>SET ANSI_NULLS ON <br>GO<br><br><br>ALTER   proc z_list<br>(@pagesize int,<br>@pageindex int,<br>@docount bit)<br>as<br>set nocount on<br>if(@docount=1)<br>select count(ID) from [join]<br>else<br>begin<br>-- declare @indextable table(table_id int identity(1,1),ID int)<br>-- declare @PageLowerBound int<br>-- declare @PageUpperBound int<br>-- set @PageLowerBound=(@pageindex-1)*@pagesize<br>-- set @PageUpperBound=@PageLowerBound+@pagesize<br>-- set rowcount @PageUpperBound<br>-- insert into @indextable(ID) select ID from [join] order by id desc<br>-- select O.* from DATATABLE O,@indextable t where O.ID=t.ID<br>-- and t.table_id&gt;@PageLowerBound and t.table_id&lt;=@PageUpperBound order by t.table_id<br>	declare @SumRow int<br>	declare @sql nvarchar(1000)<br>	set @SumRow=(select count(ID) from [join])<br>	if (@pagesize*@pageindex)&gt;@SumRow<br>		select * from [join] order by id <br>	else<br>	begin<br>		if(@pageindex&gt;1)<br>		begin<br>		set @sql='<br>		select top '+ cast(@pagesize as varchar(20))+'  * from [join] where id not in(select <br>			top '+cast((@pageindex-1)*@pagesize as varchar(20))+' id from [join] <br>			order by id) order by id'<br>		end<br>		else<br>		set @sql='select top '+cast(@pagesize as varchar(20))+'  * from [join] order by id'<br>		--select @sql<br>		exec sp_executesql @sql --N'@size int,@index int',@size=@pagesize,@index=@pageindex<br>		--sp_executesql @sql<br>	end<br>	 <br>end<br><br><br>GO<br>SET QUOTED_IDENTIFIER OFF <br>GO<br>SET ANSI_NULLS ON <br>GO

出个vs2003里用的吧，<br>因为2005和2003差太大，大项目很难升级到2005

http://net.hooyes.com/hooyes.aspx?page=1<br>首先谢谢站长的组件,但是我用在网站上后能正常分页,但是如上网页,当点最后一页的时候却出错,不知道为什么?<br>测试在本地却没有错误,不知道为何.???

我不会用你的控件啊,我不知道怎么用啊<br>能不能给我一个例子啊<br>发到我邮箱里面:谢谢啊,跪求了<br>jiangjianshuang@126.com<br>或者QQ :395475789

怎么实现多个参数的url重写呢比如说a.aspx?id=1&c=1&page=1重写成a_1_1_1.aspx呢