Need help, using VB 2005 Express and Access

Discussion in 'Database' started by MOON, Oct 24, 2007.

  1. MOON

    MOON New Member

    Joined:
    Oct 24, 2007
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    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
     
    Last edited by a moderator: Oct 24, 2007
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Express edition is free to download from the Microsoft website and you need to be buying the Access.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice