DISPLAY DATABASE DATA IN TO TEXT BOXES USING FIRST NEXT PREVIOUS LAST BUTTONS CLICK EVENTS

Question

1.00/5 (3 votes)

See more:

HI FRIENDS I TO WANT DISPLAY DATABASE DATA IN TO TEXT BOXES HERE IAM USING FIRST NEXT PREVIOUS LAST BUTTONS..

I HAVE WRITTEN THE CODE BUT ITS NOT WORKING PROPERLY IT WORKS FOR FIRST AND LAST BUTTONS CLICK EVENTS IT DISPLAYS DATABASE DATA INTO TEXT BOXES BUT WHEN IAM CLICK NEXT AND PREVIOUS BUTTONS IT DOES NOT WORK PROPERLY IT WORKS ONLY DISPLAYS FIRST TIME CORRECTLY SECOND TIME IAM CLICKING PREVIOUS BUTTON IT DOES NOT DISPLAY PREVIOUS RECORD IN THE TEXTBOXES IT DISPLAYS SAME RECORD IN TEXTBOX.

HERE IS MY CODE PLEASE HELP ME FOR THIS PROBLEM..

THANKING YOU FRIENDS....

VB

Dim rno As Integer
        cmd.CommandText = " select * from customerr"
        Dim da As New SqlDataAdapter
        Dim dt As New DataTable
        da.SelectCommand = cmd
        cmd.Connection = connection
        da.Fill(dt)

        rno = dt.Rows.Count - 1
        If rno > 0 Then
            rno -= 1
            If dt.Rows.Count > "0" Then
                txtcustid.Text = dt.Rows(rno)(0).ToString()
                txtcustname.Text = dt.Rows(rno)(1).ToString()
                txtcustaddress.Text = dt.Rows(rno)(2).ToString()
                
            End If
        End If



        cmd.CommandText = "select * from customerr"
        Dim da As New SqlDataAdapter
        Dim dt As New DataTable
        da.SelectCommand = cmd
        cmd.Connection = connection
        da.Fill(dt)
       
        rno = dt.Rows.Count - 1
        If rno < dt.Rows.Count - 1 Then
            rno += 1
            If dt.Rows.Count > 0 Then
                txtcustid.Text = dt.Rows(rno)(0).ToString()
                txtcustname.Text = dt.Rows(rno)(1).ToString()
                txtcustaddress.Text = dt.Rows(rno)(2).ToString()
               
            End If
        End If

Posted 4-Sep-14 19:58pm

chandugg

Updated 4-Sep-14 21:56pm

v3

Add a Solution

Comments

Sinisa Hajnal 5-Sep-14 2:08am

Commonly, capital letters on the web means you're shouting. Please quiet down. ;)

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sinisa Hajnal · Answer 1 · 2014-09-04T20:17:00

Your solution would work for first and last customer only because you're always looking at
rno = dt.Rows.Count -1 (i.e. you're never going forward or backward)

What you need is put a variable into member variable (say _currentRowIndex) which you would then increase / decrease.

You would load the table ONCE and set _currentRow to zero and show dt.Rows(0). Then on Next click you would

VB

' This will prevent your next from going over last item (alternatively you can set it to zero and not return thus starting from the first)
        If _currentRow +1 > dt.Rows.Count - 1 Then return

        _currentRow += 1
        With dt.Rows(0)
             txtcustid.Text = .Item("customer_id").ToString()
             txtcustname.Text = .Item("customer_name").ToString()
             txtcustaddress.Text = .Item("customer_addresss).ToString()
        End With

With Prev button you do the same, except you're comparing with zero instead of dt.rows.count-1

NOTE: I used column names instead of indexes filling fields. This has several advantages:
- you don't have to remember which index is which (in your case textbox names give a clue, but what happens when you add new field or change the order of the existing ones?)
- when you get back to it in several months, you will not have to recheck your field order - especially if there are more then those three.

chandugg · Answer 2 · 2014-09-04T21:07:00

Solution 2

FRIEND here _currentRow is "0" or "1"

Posted 4-Sep-14 21:07pm