Hi,

I have a .net winforms application that exports excel files into the database. I have to modify the code so that the files are loaded in a specific order according to their file names.
The format of the file name is as follows: date_name.xls. The date part changes but not the name.
I have to first load for example 080807_Venues.xls followed by 080807_Seminar.xls and then 080807_Employees.xls etc.

How do i tell the code the order by which to load the files?

Thanks for the help

How are you selecting what files to deal with? Is the user selecting these files? Is the program picking them up automatically from somewhere?

I noticed that the list you provided is in descending alphanumeric order. Is this relevant or coincidence?

-Peter

You can probably try

string[] names = new string[] {"Venues", "Seminar", "Employees"};

foreach(string name in names)
{
    FileInfo[] xlfiles = dir.GetFiles("*" + name + ".xls");
    //Your file processing code here
}

Mujahid Khaleel
Web designing, development, E-commerce applications.