Need help, using VB 2005 Express and Access

[TOM22]

Ok, bear with me, this must be obvious to someone but I can not get it.

I'm writing an application in Visual Basic 2005 Express, and in my project I have an Access database added (.mdb) and the dataset (.xsd). What I need to do is in some functions I'm writing, retrieve information from a Table in said database, and I'm sure there must be some easy built-in functions for doing this but I don't know them.

For example for a constructor:


Code:

Public Sub New(ByVal intID As Integer) intClassVariable = some data from the table retrieved using the ID parameter


The ID parameter being the ID on the Table of course.

So how do I accomplish this? I noticed I can declare objects as DataSets...do I need to set a 'DataSet' object to refer to the .xsd part of my project?

thanks in advance
_________________
raccoon control parental control software

[Ommina]

The closest thing I can think of for 'easy' and 'built in' would be the code snippets for database access, but I don't know if the Express edition has those or not.

Try right-clicking on the code window, and look for "Insert Snippet...". If it is there, select "Data - Designer Features and ADO.NET" followed by "Read Access Data into a Dataset".

It will give you a five line, "fill-in-the-blank" style of thing.

If the snippets thing isn't available, well, here are the five lines:

Code:

Dim conn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=AccessFile.mdb;Persist Security Info=False"
        Dim cmd As String = "Select * from Topics"
        Dim adapter As New OleDbDataAdapter(cmd, conn)
        Dim topics As New DataSet
        adapter.Fill(topics)

At a minimum you'll have to change the Source in the connection string, along with the cmd String.

The xsd file is not required, although the designer enjoys making them.