[usamah_g]

I have a problem in the sequence of records in the Dataset

Hi
I have a table with autonumber and when I add records it added in the database correctly but when I view the records in my program change order of records
The program works correctly for a period
Example

In the table
1
2
3
4

In the program
1
4
3
2

My database is access
and I use vb.net

[Atli]

Can you show us the code you use to fetch those records?

Generally speaking, for SQL databases, you use an ORDER BY clause to tell your database in which order you want the records to be returned.

[usamah_g]

Thank You

Its done when I use ORDER BY

[June7]

Show the code procedure.