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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Primary and Foreign Keys Question 1
Adding a row with null columns to a typed dataset in ADO.NET 2.0 3
How to get meta data info in ADO.NET 2
How to insert rows into tables with Autonumber PKey by using DataSet and DataAdapter? 11
Saving Master-Detail bound form - primary key is identity column 2
Primary Key, Identity Column - Problem adding row to strongly typed data table - "Column 'ShipmentID 0
Generated Strongly Typed Dataset and AutoNumber 1
Using UpdateDataSet from Enterprise Library January 2006 2

Top