Protected Sub GridView2_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView2.PageIndexChanging
GridView2.PageIndex = e.NewPageIndex
Dim sql As String = "select item_type,item_name,item_size,item_page,item_company,sum(item_num)as item_num,convert(varchar,item_time,2)as item_time,item_price,sx from yding where intotime>='" & TextBox5.Text & "'and intotime<='" & TextBox1.Text & "' group by item_type,item_name,item_size,item_page,item_company,item_time,item_price,sx order by item_company"
' Dim sql As String = "select * from cailiao"
Dim conn As String = System.Configuration.ConfigurationManager.ConnectionStrings("znhConnectionStringall").ToString Dim adapter As New SqlDataAdapter(sql, conn)
Dim dataset As New DataSet adapter.Fill(dataset) GridView2.DataSource = dataset.Tables(0)
GridView2.DataBind()
End Sub
GridView2.PageIndex = e.NewPageIndex
Dim sql As String = "select item_type,item_name,item_size,item_page,item_company,sum(item_num)as item_num,convert(varchar,item_time,2)as item_time,item_price,sx from yding where intotime>='" & TextBox5.Text & "'and intotime<='" & TextBox1.Text & "' group by item_type,item_name,item_size,item_page,item_company,item_time,item_price,sx order by item_company"
' Dim sql As String = "select * from cailiao"
Dim conn As String = System.Configuration.ConfigurationManager.ConnectionStrings("znhConnectionStringall").ToString Dim adapter As New SqlDataAdapter(sql, conn)
Dim dataset As New DataSet adapter.Fill(dataset) GridView2.DataSource = dataset.Tables(0)
GridView2.DataBind()
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货