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

Expand|Select|Wrap|Line Numbers

 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....

Quote:

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.

Next/Previous Record

re: Next/Previous Record

re: Next/Previous Record

re: Next/Previous Record

re: Next/Previous Record

re: Next/Previous Record

re: Next/Previous Record

re: Next/Previous Record

re: Next/Previous Record

Similar ASP.NET bytes

/bytes/development

/bytes/it

/bytes/about