留言簿

你好：下面的代码编译时出错，（错误信息：不能在此范围内声明名为“i”的局部变量，因为这样会使“i”具有不同的含义，而它已经用于“父级或当前”范围以表示其他内容。
“System.Web.UI.WebControls.TableRow.Cells”表示“属性”，此处应为“方法”）该怎么改？谢谢

public void  dg_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType = ListItemType.Header){
   if((true)){
		int i; 
	for (int i = 0; i <= e.Item.Cells.Count - 1; i++) 
        { 
e.Item.Cells(i).Attributes.Add("onmousemove", "SyDG_moveOnTd(this)"); 
					e.Item.Cells(i).Attributes.Add("onmousedown", "SyDG_downOnTd(this)"); 
					e.Item.Cells(i).Attributes.Add("onmouseup", "this.mouseDown=false"); 
					e.Item.Cells(i).Attributes.Add("onmouseout", "this.mouseDown=false"); 
				} 
			} 
		}

大哥您好:

发现你的的分页控件有个小小的缺点: "不支持自定义的URL"

例如: 当前页面是"http://www.webdiyer.com/guestbook/Default.aspx?page=2"
我希望自定义成
http://www.webdiyer.com/guestbook/Default.html?page=2 
或 http://www.webdiyer.com/guestbook/Default?page=2

不知可否支持? 因为这样做可以提高Google的收录率. 

谢谢!!!

我给你发了个mail。是那个窗体的代码dgxx.aspx.cs。能帮我看看吗？编译，执行都可以。代码会不会有点乱？谢谢！

是服务器端程序错误.Unspecified System Error = -21000. 搞不明白

楼下的溜达
那个查询的窗体编译通过的，执行也成功的。就是翻的时候有些页会出错，会不会和日期选择控件的
Default.css样式表有关系？

您好，我得问题已经解决，是一开始测试时的代码很乱，留下了一些干扰的代码，删除后可以正常使用了，谢谢您的辛苦工作给我们带来方便

看到上次留言显示混乱
您到这里看看吧
http://www.51js.com/viewthread.php?tid=39195&pid=351677&page=1&sid=H06744#pid351677

我想用作datalist的分页，但是不显示控件，数据库表里面有超过60行的数据
您看代码哪里错了
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
         If Not IsPostBack Then
               Call mydatabind()
        End If
    End Sub

    Private Sub AspNetPager1_PageChanged(ByVal src As System.Object, ByVal e As Wuqi.Webdiyer.PageChangedEventArgs) Handles AspNetPager1.PageChanged
        AspNetPager1.CurrentPageIndex = e.NewPageIndex
        Call mydatabind()
    End Sub
    Sub mydatabind()
        Dim strconn, sql As String
        Dim objconn As SqlConnection
        Dim objcmd As SqlCommand
        Dim objcmd1 As SqlDataAdapter
        Dim objreader As SqlDataReader
        Dim ds As DataSet = New DataSet
        strconn = ConfigurationSettings.AppSettings("strconn")
        objconn = New SqlConnection
        objconn.ConnectionString = strconn
        objconn.Open()
        objcmd = New SqlCommand
        objcmd.Connection = objconn
 
            objcmd.CommandText = "select count(id) from subject where forum='" & Request.QueryString("forum") & "' and sort1='" & Request.QueryString("sort1") & "'"

        Dim totalcount As Integer
        totalcount = objcmd.ExecuteScalar
        AspNetPager1.RecordCount = totalcount
        AspNetPager1.PageSize = 30

            objcmd.CommandText = "select id,title,start_time,teacher,city,price,hit from subject where forum='" & Request.QueryString("forum") & "' and sort1='" & Request.QueryString("sort1") & "'"

        objcmd1 = New SqlDataAdapter(objcmd)
        objcmd1.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "subject")
        AspNetPager1.RecordCount = ds.Tables("subject").DefaultView.Count
        AspNetPager1.CustomInfoText = "记录总数：" & AspNetPager1

楼下的Lee，那个表的问题，我弄好了。谢谢！

斑竹：帮忙看看这个存储过程是哪里错了？怎么有重复的数据，谢谢
CREATE procedure Select_Product_ByCategory
(@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(Products.ProductId) from Products INNER JOIN
      ProductSKUs ON Products.ProductId = ProductSKUs.ProductId
else
begin
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
insert into @indextable(nid) select products.ProductId from Products INNER JOIN
      ProductSKUs ON Products.ProductId = ProductSKUs.ProductId order by Products.ProductId desc
SELECT Products.ProductId, Products.Name, Products.ShortDescription, Products.Deleted, 
      ProductSKUs.SKU, ProductSKUs.RetaiPrice, ProductSKUs.ActralPrice
FROM Products INNER JOIN
      ProductSKUs ON Products.ProductId = ProductSKUs.ProductId , @indextable t where Products.ProductId=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
set nocount off
GO