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?