If I am reading from a .csv file like so:

               da = new OleDbDataAdapter("SELECT * FROM " +
Path.GetFileName(strFile),csvConnection);
               da.Fill(ds);

The data comes back in the same order that it read it.

If you then filter like so:

                   DataRow[] drs = dt.Select("FieldName is not null");

The data will be sorted by that column.

How can I tell it to not sort it and just give me the data back in the same
order as the table?

Thanks,

Tom