How to check and get zip files between date range from a folder and write it into combobox using C# winforms

Question

1.00/5 (2 votes)

See more:

Hello!!!
i need some help in C# winforms. I firstly want to use a Datetimepicker to set the date range in which l could weekly check if there is a new zip file on the folder. if that's the case i want to get this new zipfile (only the filename) in my combobox. And after i'm suppose to get all entries of the zip file on a datagridview.
How can i do this? can someone help me with any ideas?

Many thanks!!!

What I have tried:

// Show the OpenFileDialog.
        DialogResult result = ofd.ShowDialog();
        if (result == DialogResult.OK)
        {
            string fullPath = ofd.FileName;
            string directory;
            directory = fullPath.Substring(0, fullPath.LastIndexOf('\\'));

            textBox1.Text = directory;

            DateTime.Now.ToString("yyyyMMdd"); // ??? i don't know how i can query the date range so that it will be considered in my code

            if (File.Exists(fullPath))
            {
                string[] AllZipFiles = Directory.GetFiles(directory,"*.zip",SearchOption.AllDirectories); // Get all files from the folder

                foreach (string zipfile in AllZipFiles)
                {
                    this.comboBox1.Items.Add(zipfile); // it' working but with all the fullpath, but i only want to get the filename like test.zip
                }

            }
            else
                MessageBox.Show("There is not Zip File in this Folder");
        }

Posted 20-Feb-17 3:09am

Member 12558924

Updated 20-Feb-17 5:26am

Add a Solution

1 solution

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)

Maciej Los · Accepted Answer · 2017-02-20T05:26:00

Solution 1

Try this:

C#

string path = @"D:\Audiobooks"; //change initial path to your needs
string filter = "*.zip";
DateTime startdate = new DateTime(2012,1,1); //change dates to your needs
DateTime enddate = new DateTime(2016,12,31);

List<string> files = Directory.EnumerateFiles(path, filter, SearchOption.AllDirectories)
	.Where(x=>File.GetLastWriteTime(x)>=startdate && File.GetLastWriteTime(x)<=enddate)
	.Select(x=>Path.GetFileName(x))
	.ToList();

foreach(string zipfile in files)
{
    combobox1.Items.Add(zipfile);
}

For further details, please see:
Directory.EnumerateFiles Method (String, String, SearchOption) (System.IO)[^]
File.GetLastWriteTime Method (String) (System.IO)[^]
Path.GetFileName Method (String) (System.IO)[^]

Posted 20-Feb-17 5:26am

Maciej Los

Updated 20-Feb-17 5:28am

v2

Comments

Garth J Lancaster 20-Feb-17 18:10pm

sweet (similar to the 'pattern' I use for such) +5

Maciej Los 21-Feb-17 2:06am

Thank you, Garth.
Cheers
Maciej

Member 12558924 21-Feb-17 2:21am

Hey,
Many thanks!!! It works for the zip file, but is it possible to leave the choice to the user to enter his own date range whenever he needs it using the DateTimePicker Control on my Forms(Interface)? In addition I also want to be able to enter the exact time of the chosen date. That what i've tried does not work.
Any ideas? Thank you in advance.

Maciej Los 21-Feb-17 2:42am

Yes, you can do that. All you need to to is to set up startdate and enddate, for example:
DateTime startdate = DateTimePicker1.Value;

Please, accept an answer as a solution (green button).

Member 12558924 21-Feb-17 2:59am

It's done! should l made it in the code behind of the DateTimePicker Control or in the Button Control where i write all this code? I made it in the code behind of the DateTimePicker Control but i'm not sure. Thanks a lot.

Maciej Los 21-Feb-17 3:54am

Insert that code into Button_Click subroutine.

Member 12558924 21-Feb-17 6:06am

Thank you very much, it works very well !!! And how can I fill a new combobox2 with the entries of each zipfile? I mean, I select a zip file in my combobox1, its entries like test.txt will appear in the combobox2 and the entries of that test.txt will also appear in a datagridview as a table. How can I do that in the same code?
i've tried this to populate the new combobox2, but it's not working. I get an error and have to break the code when it run. concerning the datagridview i don't have idea.
ZipArchive zip = ZipFile.OpenRead(directory);
foreach (ZipArchiveEntry entry in zip.Entries)
{
comboBox2.Items.Add(entry.FullName);
}
It would be very nice to help me one last time.
thanks again an all

Maciej Los 21-Feb-17 6:21am

You have to provide full file name of zip file.

Member 12558924 21-Feb-17 8:19am

This works, but only for the first selected filename! So when I select another zip file in my combobox1, my code does not populate the combobox2 with the elements of the newly selected file. It is always the same data in combobox2. How do I change my code to work? Thanks

Maciej Los 21-Feb-17 9:17am

Have you closed zip file before further processing?

Member 12558924 22-Feb-17 2:14am

Morning Maciej and thank you for help. I can't close the zip file however a tried to close zipfile or zip. I get an error like:"string or ZipArchive does not contain a definition for 'close' and no extension method 'close' accepting a first argument of type string or ZipArchive could be found." This is all the code in the method, you can maybe find why is not working. Thank again!!!

My Code:
private void button1_Click_1(object sender, EventArgs e)
{
// Create an Instance of FolderBrowserDialog Class
OpenFileDialog ofd = new OpenFileDialog();

// Set an Initial SelectedPath property
ofd.InitialDirectory = @"\\servername";
string filter = "*.zip";

// Show the OpenFileDialog.
DialogResult result = ofd.ShowDialog();
if (result == DialogResult.OK)
{
string fullPath = ofd.FileName;
string directory;
directory = fullPath.Substring(0, fullPath.LastIndexOf('\\'));

// Write the Selectedpath to the TextBox nearby the Button
textBox1.Text = directory;

if (File.Exists(fullPath))
{
List<string> files = Directory.EnumerateFiles(directory, filter, SearchOption.AllDirectories)
.Where(x => File.GetLastWriteTime(x) >= startDate && File.GetLastWriteTime(x) <= endDate)
.Select(x => Path.GetFileName(x))
.ToList();

comboBox1.Items.Clear();
foreach (string zipfile in files)
{
this.comboBox1.Items.Add(zipfile); // fill cbx1 with *.zip files
// zipfile.Close(); cuz not working
}

comboBox2.Items.Clear();
ZipArchive zip = ZipFile.OpenRead(fullPath);
foreach (ZipArchiveEntry entry in zip.Entries)
{
comboBox2.Items.Add(entry.FullName); // fill cbx2 with *.csv files
// zip.Close(); also not working
}
}
}
}

Maciej Los 22-Feb-17 2:35am

Hello!
A save way to open zip file and enumerate its content is:

using (System.IO.Compression.ZipArchive archive = System.IO.Compression.ZipFile.OpenRead(fullPath))
{
    foreach (System.IO.Compression.ZipArchiveEntry entry in archive.Entries)
    {
		Console.WriteLine("{0}", entry.FullName);
	}
        archive.Dispose();
}

For further details, please see: ZipArchive Class

Member 12558924 28-Feb-17 8:54am

Hello,
how can i check the contents of zip file before read it? i tried with File.Exist(fullpath), but no check is done. fullpath contains the directory and the zip filename. thank for your time

Maciej Los 28-Feb-17 9:37am

You can't. You have to open it to be able to read its content. The same as you doing it in real. ;)

Member 12558924 28-Feb-17 9:56am

I wanted to program a message that tells me if there is one or more cvs file present in the zip file and gives me the number of files contained in this zip. Is not that possible? i tried this:
var = comboBox1.SelectedItem.ToString();
fullpath = fbd.SelectedPath + "\\"+ var;

comboBox2.Items.Clear();
if (File.Exists(fullpath))
{
ZipArchive zip = ZipFile.OpenRead(fullpath);
MessageBox.Show(Directory.EnumerateFileSystemEntries(fullpath, "*.csv").ToList<string>().Count + " csv file(s) present"); // get error here
foreach (ZipArchiveEntry entry in zip.Entries)
{
comboBox2.Items.Add(entry.FullName); // fill comboBox2 with *.csv files from selected zip file
}
zip.Dispose();
}
else
{
MessageBox.Show("no csv file(s) present");
}

Maciej Los 28-Feb-17 11:02am

Ok, but you have to ask another question.

Member 12558924 1-Mar-17 2:34am

ok it's done. Thanks