Sorting a table

[Ronny]

I'm a beginner with database programming so please forgive me if my question
is too foolish or not relevant at all...
I'd like to sort a hole table. do I have to read all data into a dataset or
is there some short way to do it?
Regards
Ronny

 

[Miro]

When you run your select statement, you can sort it in your select statment

Select * from emp
order by bla

The configuration wizard can help you with the sorting as well.

If you are displaying it in the datagridview - you can set the column
programmatically to sort for you
( keep in mind though - the underlying dataset data is not sorted )

Can you give an example of what your doing now ( how you fetch your data
into your table ) ?

Miro

 

[Ronny]

Thanks,
Actually I haven yet done that- I simply use the built in database that
comes with the product.
Regards
Ronny