Results 1 to 2 of 2

Thread: database querying problem

  1. #1
    Member
    Join Date
    Dec 11
    Posts
    45

    database querying problem

    I have an access (jet) database that I am trying to pull data from using a windows form made with vb2010 express. I have tried using the dataset and binding adapters from the 'toolbox'. I can get this to work but I have several controls and I want some to only show distinct data, while others need to show all data. I have figured out how to add multiple query's to the dataset (one for distinct and one for all data), but when I try to use them it says something about schema is different.


    If someone can please point me in the right direction.

    Do I need a different data set for each query? That is what I am thinking, but that seems like way to much for this simple task. If the dataset contains all the columns in the table, shouldn't I be able to pull and display the data as needed?

    thanks for the help, Victor.

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 02
    Location
    Bristol, UK
    Posts
    35,548

    Re: database querying problem

    Thread moved to the 'Database Development' forum

Posting Permissions

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