C#

string[] files = Directory.GetFiles(@"D:\Test Data", "*.*", SearchOption.AllDirectories);
string[] sortedFiles = files.OrderBy(f => Path.GetFileNameWithoutExtension(f)).ToArray();
myListBox.Items.AddRange(sortedFiles);

string[] files = Directory.GetFiles(@"D:\Test Data", "*.*", SearchOption.AllDirectories)
                          .OrderBy(f => Path.Getdirectory(f))
                          .ThenBy(f => Path.GetFileNameWithoutExtension(f))
                          .ToArray();

sunsher wrote:

Is it possible to do so, as the UId is varchar.

SELECT MIN(numericBit), MAX(numericBit), Class
FROM MyTable
GROUP BY Class

-- just setting up a table so I could illustrate the necessary sql
IF OBJECT_ID('tempdb..#fruits') IS NOT NULL
    DROP TABLE #fruits

CREATE TABLE #fruits
(
    ID nvarchar(10),
    Fruit nvarchar(16)
)

insert into #fruits (ID, Fruit)
VALUES ('1', 'Apple'),
 ('2', 'Apple'),
 ('3', 'Apple'),
 ('3a', 'Apple'),
 ('4', 'Orange'),
 ('4a', 'Orange'),
 ('4b', 'Orange'),
 ('5', 'Orange')

--///////////////////////////////////////////////////////////////
-- this is the code that does what you want
--///////////////////////////////////////////////////////////////

SELECT MIN([ID]) AS MinID, MAX([ID]) AS MaxID, [Fruit] FROM [#fruits] GROUP BY [Fruit]

-- or if you want to strip the non-numeric chars
-- (warning - somewhat nasty sql ahead)

SELECT MIN(substring([ID], PATINDEX('%[0-9]%', [ID]), 1+PATINDEX('%[0-9][^0-9]%', [ID]+'x')-PATINDEX('%[0-9]%', [ID]))) AS MinID,
       MAX(substring([ID], PATINDEX('%[0-9]%', [ID]), 1+PATINDEX('%[0-9][^0-9]%', [ID]+'x')-PATINDEX('%[0-9]%', [ID]))) AS MaxID,
       [Fruit] 
FROM [#fruits] 
GROUP BY [Fruit]

SELECT 
    MIN(N.JustNumeric) AS MinID,
    MAX(N.JustNumeric) AS MaxID,
    F.[Fruit] 
FROM 
    [#fruits] As F
    CROSS APPLY ( SELECT substring(F.[ID], PATINDEX('%[0-9]%', F.[ID]), 1 + PATINDEX('%[0-9][^0-9]%', F.[ID] + 'x') - PATINDEX('%[0-9]%', F.[ID])) ) As N (JustNumeric)
GROUP BY 
    F.[Fruit]
;

From all the expert adivces I get here, I think I should not do what I intend to do. As it is a ASP.NET Webforms application using VB.NET, I retrieved all the records from the table, and inserted into a dictionary, then played with it. So now I get the result I want.

CONVERT(int, SUBSTRING(F.[ID], PATINDEX('%[0-9]%', F.[ID]), etc))

John Simmons / outlaw programmer wrote:

I actually got an 'F' for the assignment) for the content of the string

namespace Golf.Components
{
  public class SkorekortDetailViewComponent : ViewComponent
  {
    public readonly GolfContext _db;

    public SkorekortDetailViewComponent(GolfContext context)
    {
      _db = context;
    }


    public async Task<IViewComponentResult> InvokeAsync(int SkorekortID)
    {
      var items = await GetItemsAsync(SkorekortID);
      return View(items);
    }

    private async Task<List<SkorekortDetailViewModel>> GetItemsAsync(int SkorekortID)
    {
      
      return (from s in _db.SkoreKort
              from k in _db.Klub
              from b in _db.Bane
              where (s.SkorekortID == SkorekortID &&
                     s.BaneKlubID == k.KlubID &&
                     s.BaneID == b.BaneID)
              select new {
                s.SkorekortID,
                k.DGUKlubNr,
                s.SkoreDato,
                s.SpillerHCP,
                k.KlubNavn,
                b.BaneNavn,
                b.TeeNavn,
                b.HerreDame,
                b.BaneID,
                k.KlubID          
              }).AsQueryable() 
                               .Select(x => new SkorekortDetailViewModel {
                                 SkorekortID = x.SkorekortID,
                                 DGUKlubNr = x.DGUKlubNr,
                                 SkoreDato = x.SkoreDato,
                                 SpillerHCP = x.SpillerHCP,
                                 KlubNavn = x.KlubNavn,
                                 BaneNavn = x.BaneNavn,
                                 TeeNavn = x.TeeNavn,
                                 HerreDame = x.HerreDame,                                 
                                 SkoreListe = await GetSkorekortSkore(x.SkorekortID)
                               }).ToListAsync();
      
    }

    public async Task<List<SkorekortSkore>> GetSkorekortSkore(int SkorekortID)
    {


      return await (from s in _db.SkoreKortSkore
                    where s.SkorekortID == SkorekortID
                    select s).ToListAsync();
     
    }