Problem ADO.NET DataTable's parameters generated by Add Data Sourc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a lookup table with only one column which is a string and the primary
key like so:

JOBTITLES
------------
JobTitle (string) PRIMARY KEY


In another table, I reference the above table's primary column as a foreign
key like so:

PEOPLE
--------
ID (int)
Name (string)
JobTitle (string) FOREIGN KEY of JOBTITLES



Interestingly, the strongly typed DataTables that are created will correctly
type the foreign key field (PEOPLE.JobTitle) as a string. But the strongly
typed "AddRow" (AddPEOPLERow()) and Row (PEOPLERow) function defines the
parameters for the JobTitle column as a "DataRow" (JobTitlesRow) instead of a
"String" as I expected.

I have no idea why the wizard generates it in this format. SHould I just
work with it (I have no idea what pass) or should I be seting something else
up differently
 
Back
Top