DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: mdb connection problem

  1. #1
    Join Date
    Apr 2006

    Talking mdb connection problem

    Hello, everyone!

    I have a problem with oleDBconnection.
    I could not find a way how to configure dataset and dataAdapter to be able to use several tables from my Access database.
    When I create DataAdapter and OleDBConnection and generate Dataset, it merges all rows from three tables into one.
    Do I need to create separate dataadapters for every table I use?

    Thank you beforehand.

  2. #2
    Join Date
    Dec 2003
    Not sure if I understand your exact problem. Are you saying that all tables are merged into a single DataTable?
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Apr 2006
    I cannot view information from multy tables from Access db.
    I create DataAdapter through Wizard. When it asks me for an SQL query I use Query Builder and there choose all tables I have (3), the SQL is generated but shows errors with update and Insert commands.
    Then I click Data/Generate dataset. It is created. Then I want to bind my textbox on a form to the row of a table. In properties of textbox I choose Data/Text. In drop down menu the dataset shows only one table consisting of all rows from all three tables.

  4. #4
    Join Date
    Jan 2006
    No, you can use the same data adapter and just change the SQL query on the fly... but do it if you're quite familiar with SQL query, otherwise creating 3 data adapters for 3 different table will work much easier (the drawback is, if you have more than 3 tables, then you'll need to create more adapters which is just not feasible to do).
    My opinion is: you'll always need to know SQL query when working with DB (even if you use the more advance framework). I personally rarely use the wizard of data adapter, cause most of the time it generates the code I don't want.
    Btw, this question suppose to be in .Net forum, isn't it ?

Similar Threads

  1. Jdbc Connection Problem
    By shamshami in forum Java
    Replies: 4
    Last Post: 09-04-2006, 03:22 PM
  2. problem in adding Data Connection
    By Thomas in forum ASP.NET
    Replies: 1
    Last Post: 03-11-2002, 04:19 PM
  3. Connection Problem with Oracle
    By shailendra in forum VB Classic
    Replies: 1
    Last Post: 10-18-2001, 09:25 AM
  4. Replies: 1
    Last Post: 09-28-2001, 10:15 AM
  5. Facing Problem with Database connection
    By Venkat in forum ASP.NET
    Replies: 0
    Last Post: 07-04-2001, 12:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center