Why is ADO.net treating my integer field as text? from the following code

drArray = ds.Tables("Products").Select("fkCategory=1", "intOrderOfAppearance ASC")

I get records sorted by intOrderOfAppearance, except instead of

{1,2,3,4,5,6,7,8,9,10,11,12 etc.}

I get

{1,10,11,12,13,14,15,16,17,18,19,2,20,21 etc.}

Do I need to strongly type my whole dataset just to have it treat my integers as integers??? It seems like a lot of trouble (what I've read so far about creating strongly-typed datasets makes it seem like a bit of an ordeal).

Thanks in advance.

Aaron

Thanks guys.

I figured this out. You have to call the DataSet.FillSchema method before you call the Fill method. Thanks anyway.

Aaron