[Year 12 SofDev] MS Access and VB6 [Scanned]

[Brett Fitzsimmons]

Hi John

I'm using C# and the OleDb libs rather than binding sources. It's been a
long time since I've used VB but the same approach should work.

Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
        Dim dbConn As New
System.Data.OleDb.OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data
source=P:\\databases\\Sample.mdb")
        dbConn.Open()

        Dim dbCmd As New System.Data.OleDb.OleDbCommand("Select * From
EmployeeTbl", dbConn)
        Dim reader As System.Data.OleDb.OleDbDataReader
        reader = dbCmd.ExecuteReader()
        While reader.Read()
            Dim data = reader.GetValue(1)
        End While
    End Sub
End Class

Regards,

Brett Fitzsimmons
Brighton Grammar School

-----Original Message-----
From: sofdev-request at edulists.com.au
[mailto:sofdev-request at edulists.com.au] 
Sent: Wednesday, 23 July 2008 12:00 PM
To: sofdev at edulists.com.au
Subject: sofdev Digest, Vol 41, Issue 10 [Scanned]

Send sofdev mailing list submissions to
	sofdev at edulists.com.au

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.edulists.com.au/mailman/listinfo/sofdev
or, via email, send a message with subject or body 'help' to
	sofdev-request at edulists.com.au

You can reach the person managing the list at
	sofdev-owner at edulists.com.au

When replying, please edit your Subject line so it is more specific
than "Re: Contents of sofdev digest..."


Today's Topics:

   1. Access & VB 2008 Express Edition Help (EDWARDS. John)


----------------------------------------------------------------------

Message: 1
Date: Wed, 23 Jul 2008 11:14:20 +1000
From: "EDWARDS. John" <edwajoh1 at lavalla.sale.catholic.edu.au>
Subject: [Year 12 SofDev] Access & VB 2008 Express Edition Help
To: "Year 12 Software Development Teachers' Mailing List"
	<sofdev at edulists.com.au>
Message-ID:
	
<8DFC51B77EF4FC46878B730A09CBD34901937AC4 at LCC-MAIL-1.lavalla.local>
Content-Type: text/plain; charset="iso-8859-1"

Hi Everyone,
 
I am having real trouble finding tutes on vb 2008 express edition. I
have managed to interface with a MS Access database using a
BindingSource control so that the fields from the first record are
displayed in textboxes. The problem I am having is navigating forward
and back between records. I really just don't know where to start. I had
no problems with VB6 but this application is quite different. I would
appreciate any assistance.
 
Cheers,
John Edwards
Lavalla Catholic College
 
 

____________________________________________________________
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended
recipient
is prohibited. If you received this in error, please contact the sender
and
delete the material from any system and destroy and copies.

____________________________________________________________
This email has been scanned by MailMarshal, an email content filter.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://www.edulists.com.au/pipermail/sofdev/attachments/20080723/136ba45
4/attachment-0001.html

------------------------------

_______________________________________________
sofdev mailing list
sofdev at edulists.com.au
http://www.edulists.com.au/mailman/listinfo/sofdev


End of sofdev Digest, Vol 41, Issue 10
**************************************