90分求这段代码的正确分页,现在还有点BUG,如何改,请详细一点
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
If Not Me.IsPostBack Then
orderbind()
End If
End Sub
Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
orderbind()
End Sub
Sub orderbind()
Me.Label3.Text = Me.DropDownList1.SelectedItem.Text
Dim conn As New OleDbConnection("Data Source=""" & Me.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings("database")) & """;Provider=""Microsoft.Jet.OLEDB.4.0"";User ID=Admin")
Dim i As Integer = CInt(Me.DropDownList1.SelectedValue)
Dim mycom As String
If Me.DropDownList1.SelectedValue = 0 Or Me.DropDownList1.SelectedValue = 1 Then
'i = 3
mycom = "SELECT DISTINCT T_BookOrder.OrderID, T_BookOrder.Zonger, T_PaymentWay.PaymentWay, T_DeliveryWay.Way, T_BookOrder.OrderState, T_BookOrder.OrderTime, T_BookOrder.UserName FROM ((T_BookOrder INNER JOIN T_PaymentWay ON T_BookOrder.PaymentWayID = T_PaymentWay.PaymentWayID) INNER JOIN T_DeliveryWay ON T_BookOrder.WayID = T_DeliveryWay.WayID) WHERE (T_BookOrder.UserName = '16120300') ORDER BY T_BookOrder.OrderTime DESC"
Else
mycom = "SELECT DISTINCT T_BookOrder.OrderID, T_BookOrder.Zonger, T_PaymentWay.PaymentWay, T_DeliveryWay.Way, T_BookOrder.OrderState, T_BookOrder.OrderTime, T_BookOrder.UserName FROM ((T_BookOrder INNER JOIN T_PaymentWay ON T_BookOrder.PaymentWayID = T_PaymentWay.PaymentWayID) INNER JOIN T_DeliveryWay ON T_BookOrder.WayID = T_DeliveryWay.WayID) WHERE (T_BookOrder.UserName = '16120300') And (T_BookOrder.OrderState = '" & i & "') ORDER BY T_BookOrder.OrderTime DESC"
End If
Dim orderinfo As New OleDbDataAdapter(mycom, conn)
Dim ds As New DataSet
orderinfo.Fill(ds, "T_BookOrder")
Dim objPds As PagedDataSource = New PagedDataSource
objPds.DataSource = ds.Tables(0).DefaultView
objPds.AllowPaging = True
objPds.PageSize = 10
Dim CurPage As Integer
If Not Request.QueryString("Page") Is Nothing Then
CurPage = Convert.ToInt32(Request.QueryString("Page"))
Else
CurPage = 1
End If
Dim zcount As Integer = Math.Ceiling(ds.Tables(0).Rows.Count / objPds.PageSize)
Me.Label2.Text = zcount
objPds.CurrentPageIndex = CurPage - 1
Me.Label1.Text = ds.Tables(0).Rows.Count
lblCurrentPage.Text = CurPage.ToString()
If (Not objPds.IsFirstPage) Then
Me.HyperLink2.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1)
End If
If (Not objPds.IsFirstPage) Then
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1)
End If
If (Not objPds.IsLastPage) Then
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1)
End If
If (Not objPds.IsLastPage) Then
Me.HyperLink5.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(zcount)
End If
Me.DataGrid1.DataSource = objPds
Me.DataGrid1.DataBind()
End Sub
我用一个dropdownlist来改变datagrid订单状态(i的值),如果每次只改变dropdownlist,就不会发生错误。但是如果你点了下一页,然后再去改变订单状态,如果i的值不够分2页,就会发生错误。我想问一下怎么解决呢?
'在此处放置初始化页的用户代码
If Not Me.IsPostBack Then
orderbind()
End If
End Sub
Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
orderbind()
End Sub
Sub orderbind()
Me.Label3.Text = Me.DropDownList1.SelectedItem.Text
Dim conn As New OleDbConnection("Data Source=""" & Me.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings("database")) & """;Provider=""Microsoft.Jet.OLEDB.4.0"";User ID=Admin")
Dim i As Integer = CInt(Me.DropDownList1.SelectedValue)
Dim mycom As String
If Me.DropDownList1.SelectedValue = 0 Or Me.DropDownList1.SelectedValue = 1 Then
'i = 3
mycom = "SELECT DISTINCT T_BookOrder.OrderID, T_BookOrder.Zonger, T_PaymentWay.PaymentWay, T_DeliveryWay.Way, T_BookOrder.OrderState, T_BookOrder.OrderTime, T_BookOrder.UserName FROM ((T_BookOrder INNER JOIN T_PaymentWay ON T_BookOrder.PaymentWayID = T_PaymentWay.PaymentWayID) INNER JOIN T_DeliveryWay ON T_BookOrder.WayID = T_DeliveryWay.WayID) WHERE (T_BookOrder.UserName = '16120300') ORDER BY T_BookOrder.OrderTime DESC"
Else
mycom = "SELECT DISTINCT T_BookOrder.OrderID, T_BookOrder.Zonger, T_PaymentWay.PaymentWay, T_DeliveryWay.Way, T_BookOrder.OrderState, T_BookOrder.OrderTime, T_BookOrder.UserName FROM ((T_BookOrder INNER JOIN T_PaymentWay ON T_BookOrder.PaymentWayID = T_PaymentWay.PaymentWayID) INNER JOIN T_DeliveryWay ON T_BookOrder.WayID = T_DeliveryWay.WayID) WHERE (T_BookOrder.UserName = '16120300') And (T_BookOrder.OrderState = '" & i & "') ORDER BY T_BookOrder.OrderTime DESC"
End If
Dim orderinfo As New OleDbDataAdapter(mycom, conn)
Dim ds As New DataSet
orderinfo.Fill(ds, "T_BookOrder")
Dim objPds As PagedDataSource = New PagedDataSource
objPds.DataSource = ds.Tables(0).DefaultView
objPds.AllowPaging = True
objPds.PageSize = 10
Dim CurPage As Integer
If Not Request.QueryString("Page") Is Nothing Then
CurPage = Convert.ToInt32(Request.QueryString("Page"))
Else
CurPage = 1
End If
Dim zcount As Integer = Math.Ceiling(ds.Tables(0).Rows.Count / objPds.PageSize)
Me.Label2.Text = zcount
objPds.CurrentPageIndex = CurPage - 1
Me.Label1.Text = ds.Tables(0).Rows.Count
lblCurrentPage.Text = CurPage.ToString()
If (Not objPds.IsFirstPage) Then
Me.HyperLink2.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1)
End If
If (Not objPds.IsFirstPage) Then
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1)
End If
If (Not objPds.IsLastPage) Then
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1)
End If
If (Not objPds.IsLastPage) Then
Me.HyperLink5.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(zcount)
End If
Me.DataGrid1.DataSource = objPds
Me.DataGrid1.DataBind()
End Sub
我用一个dropdownlist来改变datagrid订单状态(i的值),如果每次只改变dropdownlist,就不会发生错误。但是如果你点了下一页,然后再去改变订单状态,如果i的值不够分2页,就会发生错误。我想问一下怎么解决呢?
...全文
相关推荐
java代码-例3-1 判断学生成绩是否为90分以上(含90分),若为真,屏幕显示A。
java代码-例3-1 判断学生成绩是否为90分以上(含90分),若为真,屏幕显示A。
c代码-输入某学生的成绩,经处理后给出学生的等级,等级分类如下: 90分以上(包括90): A 80至90分(包括80):B 70至80分(包括70):C 60至70分(包括60):D 60分以下:E
c代码-输入某学生的成绩,经处理后给出学生的等级,等级分类如下: 90分以上(包括90): A 80至90分(包括80):B 70至80分(包括70):C 60至70分(包括60):D 60分以下:E
d800&d90 操作软件改快门等
用在D800跟D90上的操作型软件,用在D800跟D90上的操作型软件大家看看麻
matinv.rar_fortran90_fortran求逆_求逆_矩阵求逆_矩阵求逆fortran
矩阵求逆,使用fortran语言编写,希望能对有需要的朋友有所帮助
JS解决IOS中拍照图片预览旋转90度BUG的问题
下面小编就为大家带来一篇JS解决IOS中拍照图片预览旋转90度BUG的问题。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧


