Reply to thread

Message

<blockquote data-quote="Tmuldoon" data-source="post: 6915" data-attributes="member: 2656"><a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbcode/html/vbtskCodePagingInDataGridWebControlVisualBasic.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbcode/html/vbtskCodePagingInDataGridWebControlVisualBasic.asp</a>I still have some issues.&nbsp; I used the MSDN code and it sort of works.Now the paging works, but when I hit the number - it does not show myrecords until I hit the search button again.&nbsp; I thought it would go tothe next records automatically.&nbsp; Not sure why?&nbsp; Do I need to do somesort of refresh at the button level?&nbsp; WHY DOESN'T IT PAGE AUTOMATICALLY!???[Plus I also do not understand this line:dsQuery = CType(Session(&quot;dataset&quot;), DataSet1).&nbsp;&nbsp; I already have adataset defined at design time - what does this do?&nbsp; ]Here is my code:- my dataset is called 'ds'Private Sub Page_Load(ByVal sender As System.Object, ByVal e AsSystem.EventArgs) Handles MyBase.Load&nbsp; &nbsp; &nbsp; &nbsp; 'Put user code to initialize the page here&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; With dg&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .AllowPaging = True&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .PagerStyle.Mode = PagerMode.NumericPages&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .PageSize = 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .PagerStyle.PageButtonCount = 5&nbsp; &nbsp; &nbsp; &nbsp; End With&nbsp; &nbsp; &nbsp; &nbsp; If IsPostBack Then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ds = CType(Session(&quot;dataset&quot;), DataSet1)&nbsp; &nbsp; &nbsp; &nbsp; Else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; daQuery.Fill(ds)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session(&quot;dataset&quot;) = ds&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataBind()&nbsp; &nbsp; &nbsp; &nbsp; End If&nbsp; &nbsp; End SubThe button code-&gt;filters out data with a dataview.&nbsp; So after the pagebutton is pressed - one gets a blank screen untill the button ispressed again - then it moves to the next results.Private Sub btn_Click(ByVal sender As System.Object, ByVal e AsSystem.EventArgs) Handles btn.Click&nbsp; &nbsp; &nbsp; &nbsp; Dim Count As Integer&nbsp; &nbsp; &nbsp; &nbsp; Dim dv As DataView = ds.Tables(&quot;DB&quot;).DefaultView&nbsp; &nbsp; &nbsp; &nbsp; dv.RowFilter = &quot;Title like '%&quot; &amp; txt.Text &amp; &quot;%' OR Address like'%&quot; &amp; txt.Text &amp; &quot;%'&quot;&nbsp; &nbsp; &nbsp; &nbsp; Count = dv.Count&nbsp; &nbsp; &nbsp; &nbsp; dg.DataSource = dv&nbsp; &nbsp; &nbsp; &nbsp; dg.DataBind()&nbsp; &nbsp; &nbsp; &nbsp; lblCount.Text = Count&nbsp; &nbsp; End SubPaging:- Hide quoted text -- Show quoted text -Private Sub dg_PageIndexChanged(ByVal source As Object, ByVal e AsSystem.Web.UI.WebControls.DataGridPageChangedEventArgs) Handlesdg.PageIndexChanged&nbsp; &nbsp; &nbsp; &nbsp; dg.CurrentPageIndex = e.NewPageIndex&nbsp; &nbsp; &nbsp; &nbsp; dg.DataBind()&nbsp; &nbsp; End Sub</blockquote>

[QUOTE="Tmuldoon, post: 6915, member: 2656"] [url="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbcode/html/vbtskCodePagingInDataGridWebControlVisualBasic.asp"]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbcode/html/vbtskCodePagingInDataGridWebControlVisualBasic.asp[/url] I still have some issues. I used the MSDN code and it sort of works. Now the paging works, but when I hit the number - it does not show my records until I hit the search button again. I thought it would go to the next records automatically. Not sure why? Do I need to do some sort of refresh at the button level? WHY DOESN'T IT PAGE AUTOMATICALLY!??? [Plus I also do not understand this line: dsQuery = CType(Session("dataset"), DataSet1). I already have a dataset defined at design time - what does this do? ] Here is my code: - my dataset is called 'ds' Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here With dg .AllowPaging = True .PagerStyle.Mode = PagerMode.NumericPages .PageSize = 5 .PagerStyle.PageButtonCount = 5 End With If IsPostBack Then ds = CType(Session("dataset"), DataSet1) Else daQuery.Fill(ds) Session("dataset") = ds DataBind() End If End Sub The button code->filters out data with a dataview. So after the page button is pressed - one gets a blank screen untill the button is pressed again - then it moves to the next results. Private Sub btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn.Click Dim Count As Integer Dim dv As DataView = ds.Tables("DB").DefaultView dv.RowFilter = "Title like '%" & txt.Text & "%' OR Address like '%" & txt.Text & "%'" Count = dv.Count dg.DataSource = dv dg.DataBind() lblCount.Text = Count End Sub Paging: - Hide quoted text - - Show quoted text - Private Sub dg_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles dg.PageIndexChanged dg.CurrentPageIndex = e.NewPageIndex dg.DataBind() End Sub [/QUOTE]

Verification