How to sort files in a directory by integer in C#

Question

0.00/5 (No votes)

See more:

HI
I want to sort files in a directory containing .sql files named as

1.sql
2.sql
3.sql
....
....
....
n.sql

I want to sort filed by number

I have written this code

C#

string sqlConnectionString = cn.ConnectionString.ToString();
            SqlConnection conn = new SqlConnection(sqlConnectionString);
            string script = string.Empty;
            Server server = new Server(new ServerConnection(conn));
            MessageBox.Show(server.Information.Version.ToString());
            bool IsFailed = false;
            string mappath = Path.Combine(Application.StartupPath.ToString(), "Scripts");
            //var files1 = from file in Directory.GetFiles(mappath)
            //            orderby file 
            //            select file;
            //var biggest = files1.First();
            //var files = Directory.GetFiles(@"" + mappath + "", "*.sql").OrderBy(f => new FileInfo(f).Name);
            var files = Directory.GetFiles(@"" + mappath + "", "*.sql").OrderBy(n => n);
            string[] filePaths = Directory.GetFiles(@"" + mappath + "", "*.sql");

Would you please resolve this error

Posted 30-Jul-15 19:26pm

TarunKumarSusarapu

Updated 30-Jul-15 20:00pm

Patrice T

v4

Add a Solution

Comments

DamithSL 31-Jul-15 1:44am

what is the issue with
Directory.GetFiles(mappath, "*.sql").OrderBy(f => f) ?

TarunKumarSusarapu 31-Jul-15 1:53am

It is not getting with appropriate result after 1.sql it is showing 10.sql

3 solutions

Solution 2

The problem is in your OrderBy(n => n), is does an alpha sort.

You need to convert the n to the num value.
Try to sort on something like Convert.ToInt32(n) rather than on n

Posted 30-Jul-15 20:10pm

Patrice T

Solution 1

I have written this code Now it is getting Correctly

C#

var files = Directory.GetFiles(@"" + mappath + "", "*.sql").OrderBy(f=>int.Parse(Path.GetFileNameWithoutExtension(f)));

Posted 30-Jul-15 20:08pm

TarunKumarSusarapu

Comments

Suvendu Shekhar Giri 31-Jul-15 2:19am

Perfect !
Good to see that you have not stopped trying after posting the question here.

5ed for that :)

TarunKumarSusarapu 31-Jul-15 2:29am

Thank a lot

Matt T Heffron 31-Jul-15 13:04pm

Just a side question:
Why do you do
@"" + mappath + ""
This accomplishes nothing!
mappath is already a string and concatenating an empty string at each end does nothing.
(Also, Application.StartupPath is already a string, so there's no need to use .ToString())

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Accepted Answer · 2015-07-30T20:16:00

If your file names contains only numeric values then try this-

C#

var files = Directory.GetFiles(@"" + mappath + "", "*.sql").OrderBy(n => Convert.ToInt16(Path.GetFileNameWithoutExtension(n)));

Else you can write a function based on the logic shared here
http://stackoverflow.com/a/5093939/1006297[^]

C#

var files = Directory.GetFiles(@"" + mappath + "", "*.sql").OrderBy(n => PadNumericPortion(n));

Hope, it helps :)