dcsimg
Results 1 to 4 of 4

Thread: How do I Connect to, and reading from Access

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 2007
    Posts
    159

    Question How do I Connect to, and reading from Access

    I have searched and found a fair few pages but they all relate to VS 2005 and VS 2008 only.

    What I need to do, using VS 2010, is connect to an Access 2000 (mdb) database.

    I then need to access a table called "technicians" that has about 30 fields, but I am only interested in 2 of them - "name" and "isdisabled".

    What I want to do is populate an array using the values from "name" if "isdisabled" is set to "0"

    Can anyone give me some instructions or point me in the direction of a VB 2010 tutorial?

    Thank you.
    If my post helped you, please rate it. Thanks.

  2. #2
    Banned
    Join Date
    Mar 2009
    Posts
    764

    Re: How do I Connect to, and reading from Access

    download my book it has a walkthrough about mining data in an access database

  3. #3
    Hyperactive Member
    Join Date
    Jun 2009
    Posts
    307

    Re: How do I Connect to, and reading from Access

    I don't think anything has changed regarding accessing an Access Database between 2005, 2008, and 2010. Those tutorials should still work for you. You can also check out this site:

    http://www.homeandlearn.co.uk/NET/nets12p1.html

  4. #4
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    103,444

    Re: How do I Connect to, and reading from Access

    There are various ways to work with databases in .NET. You can use raw ADO.NET, a typed DataSet or the Entity Framework, just to name those available for Access out of the box. I'd probably suggest starting with a typed DataSet.

    To that end, you might like to folllow the Data Walkthroughs link in my signature, which includes one on using Access. That Home & Learn tutorial also uses a typed DataSet, if I'm not mistaken.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width