I have a simple, non-related table that has a primary key and a foreing key like this:

pkProductID fkCategoryID
1 1
2 1
3 1
4 2
5 2

and soforth.

both of these fields are integers in the database, but ADO.NET sees them as text in my dataset because it is not typed. So, if I try to sort by pkProductID I get...

1
10
11
12
...
2
21

and soforth.

How then can I capture the datatype from the original database on just these two columns? Do I need to create an XML schema for the whole dataset? Do I have to use XSD.exe?

Thanks guys. I figured this out. You have to use the dataset.FillSchema method before you call the fill method. Took me a while, but I found the anwer online. Thanks anyway.

Aaron