Next/Previous Record

[jmprescott]

Hello again, and happy monday!

Well I'm getting better with this and learning a lot. I've come to another road block. I'm trying to figure out a way to "scroll" through records in my Access table, one by one. It's a little different than recordsets, it seems.

Here's the code I used to guess how it might work... and it doesn't lol.

I'm guessing I'm not loading the datatable correctly, but any help would be appreciated as always :)

Jesse

Protected Sub NextBN_Click(ByVal sender As Object, ByVal e As EventArgs) Handles NextBN.Click
        Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\WebRMS_Mobile\WebRMS.mdb")
        Dim dbcomm As New OleDbCommand("SELECT PageURL FROM ArmyRootURLPages", cn)
        Dim dr As OleDbDataReader
        Try
            cn.Open()
            dr = dbcomm.ExecuteReader
            Dim dt As New DataTable("ArmyRootURLPages")
            dt.Load(dr)
            If dr.HasRows() Then
                While (dr.Read)
                    PageURL.Text = dr("PageURL")
                End While
            End If
        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            cn.Close()
        End Try
 
 
    End Sub

[Frinavale]

I'm really not sure what you're trying to do??

You have an Access Database and you want to display records to the end user.
I see that you're filling a table (manually) with each record from the Access Database but don't see any indication of what control you're using to display the records.

What are you trying to do?
What controls are you using?
Are you sure you want to "scroll" through the records? Do you maybe want to "page" through them (with next/previous buttons)?



-Frinny

[ThatThatGuy]

Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\WebRMS_Mobile\WebRMS.mdb");

The reference to the MDB file is incorrect...when you're developing any web application...the path to it's resources should reside inside the project directory....
In this case.... you could have used something like this....
Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Server.MapPath("App_Data\\WebRMS.mdb");

Usually the database files are inside App_Data folder which is inbuilt in Asp.net
Web Applications can't access resources on the system....

Server.MapPath()

will Attach the preceeding url of your website...or whatever..
Correct this one first youll get the result....ask in me for more scroll queries...

[ThatThatGuy]

One more advice don't put &nbsp 's for spaces just put up space....your code was too unreadable....

[Frinavale]

??
  is HTML for space.....

Where did you see this?

[jmprescott]

lol, I was wondering that too.

Anyways, problem resolved.

[Frinavale]

Glad you fixed it :)

[ThatThatGuy]

Actually frinavale when i was viewing the code part of the post it was showing  's between Dim and the variable names.....Might be some browser problem......think so....Any ways did the solution proved to be useful enough

[jmprescott]

No, it had nothing to do with the paths.

Just had to read up on datareaders and datatables, and such.