C#

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

while (rdr.Read()) {

    String sName = rdr["orderID"].ToString();
    listBox1Montag.Items.Add(sName);
    listBox2Dienstag.Items.Add(sName);
    listBox3Mittwoch.Items.Add(sName);
    listBox4Donnerstag.Items.Add(sName);
    listBox5Freitag.Items.Add(sName);

}

while (rdr.Read()) {

    String sName = rdr["orderID"].ToString();
    DateTime StartDate = Convert.ToDateTime(rdr["DateField"]).ToString("dd/MM/yyyy");
    DateTime FinalDate = Convert.ToDateTime(rdr["FinalDate"]).ToString("dd/MM/yyyy");

    if ((StartDate <= MONDAY) && (FinalDate >= MONDAY)) { listBox1Montag.Items.Add(sName); }

    // You are going to need to figure this portion out
    // I would probably create a helper class for this

    if ((StartDate <= FRIDAY) && (FinalDate >= FRIDAY)) { listBox5Freitag.Items.Add(sName); }
}

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