GridView.Sort <> SQL 'ORDER BY'. what's up with that?!?

  • Thread starter Thread starter Ryan H
  • Start date Start date
R

Ryan H

Given 2 records with 1 'Name' column (varchar):
"Tri-Star"
"Triangle"

GridView.Sort("Name", SortDirection.Ascending) will sort the records like
so:
1. "Triangle"
2. "Tri-Star"

While a standard SQL 'SELECT * FROM MyTable ORDER BY Name ASC' will sort the
records like so:
1. "Tri-Star"
2. "Triangle"

This is lame. Is there a fix for this?
 
Sort in SQL? :-)

Currently, I know of no other fix for the problem.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*********************************************
Think outside the box!
*********************************************
 
Oh well. I like your books btw.



Cowboy (Gregory A. Beamer) said:
Sort in SQL? :-)

Currently, I know of no other fix for the problem.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*********************************************
Think outside the box!
*********************************************
Click to expand...
 
Back
Top