HighTechTalks DotNet Forums  

How to sort data?

Dotnet VJSharp microsoft.public.dotnet.vjsharp


Discuss How to sort data? in the Dotnet VJSharp forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Christian-Josef Schrattenthaler
 
Posts: n/a

Default How to sort data? - 06-12-2005 , 08:56 AM






Hi!

I get data from a file, and send them to a table. Is it possible to sort the
data?

Greetings,
Christian.



Reply With Quote
  #2  
Old   
Christian-Josef Schrattenthaler
 
Posts: n/a

Default Re: How to sort data? - 06-12-2005 , 12:13 PM






Hi!

I found it.
It's verry simple.
Only add "... ORDER BY xyz" in the SQL-Statement.
The most times, I think to difficult...

Greeting,
christian.



Reply With Quote
  #3  
Old   
Christian-Josef Schrattenthaler
 
Posts: n/a

Default Re: How to sort data? - 06-14-2005 , 03:00 AM



Hi Lars-Inge!

Quote:
You can also sort on more than one row by adding the columns like
this:
"SELECT * FROM Table ORDER BY LastName, FirstName"
Thanks! I forgot this to do in my code, because I need first the
POSTLEITZAHL and then the NAME.

Greetings,
Christian.



Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.