Click here to Skip to main content
Search within:




Next

Navigation Code through records of a database
Sign Up to vote bad
good
See more: VB.NET
I have created a next button with this code to lead me through the records of the database:
Protected Sub btnNext_Click(sender As Object, e As EventArgs) Handles btnNext.Click
       If (inc <> (MaxRows - 1)) Then
 
           inc = inc + 1
 
           Next()
 
       End If
   End Sub
where
MaxRows = dst.Tables("TableName").Rows.Count
 
Private Sub Next()
txt_kodi.Value = dst.Tables("TableName").Rows(inc).Item(1)
       txt_pershkrimi.Valuedst.Tables("TableName").Rows(inc).Item(1)
When I click the next button it always save the first value I give to variable inc.
so it always leads me to the second row and that's all. I can't move to the third or the fourth.
Posted 10-Nov-12 1:15am
Amelia1252
Edited 10-Nov-12 2:12am
André Kraak52K
v2
Add a Solution


1 solution

If this is Web based, then yes, that is what I would expect - your variables are not preserved while the page is displayed, they are re-created each time as a Page Load event occurs when the user causes a post-back.
 
If you want to keep a value and increment it, then you either need to keep it on the page (as a visible of hidden control) or save it in the Session and retrieve it each time you wish to move on to the next record.
 
If this isn't web based, then you need to provide more information as to what else affects the value of inc
  Permalink  
Posted 10-Nov-12 3:30am
OriginalGriff753K
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Christian Graus 538
1 Ron Beyer 286
2 samadhan_kshirsagar 229
3 Tadit Dash 213
4 OriginalGriff 198
0 Sergey Alexandrovich Kryukov 7,017
1 Prasad_Kulkarni 3,815
2 OriginalGriff 3,557
3 _Amy 3,372
4 CPallini 3,010


Advertise | Privacy | Mobile
Web04 | 2.6.130619.1 | Last Updated 10 Nov 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid