By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,703 Members | 1,400 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,703 IT Pros & Developers. It's quick & easy.

Dataset question: having issues with specific tables

P: n/a
Hello -

Im new to ADO.NET so bear with me here.

I have an Access DB, simplified as follows:

TABLE Person
person_ID autonumber PK
last_name text
first_name text
person_type number FK
TABLE Person_Types
person_type number PK
person_type_desc text

The second table is just a Lookup table, in which I have all the
possible "person types". It has only 7 rows, while the person table
has several thousand.

My problem is as follows: When I create an OledbDataAdapter and
DataSEt on the Person_types table, no problems. THe dataset is
correctly populated. But, when I do the same on the Person table, I
get ZERO rows in the dataset. What gives here? Is there some sort of
primary key issue that Im missing here?

FWIW, Ive tested the adapter functionality on all the tables in my DB.
Everything is fine with the lookup tables, but all other tables give
me an empty dataset.

Please help me understand why this is happening!!!

Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
"Brian" <br*********> schrieb
Hello -

Im new to ADO.NET so bear with me here.

I do :-) but for ADO.NET specific questions, you should turn to

This group is for VB.NET language specific questions.

Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.