Dataset question: having issues with specific tables

[Brian]

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!!!

THanks
Brian

 

[Armin Zingler]

Hello -

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

I do but for ADO.NET specific questions, you should turn to
microsoft.public.dotnet.framework.adonet

This group is for VB.NET language specific questions.