Select Query

Question

0.00/5 (No votes)

See more:

hi,

How to Load all the files from my Desktop.
i.e. I have to show my all files in the desktop by using any keyword in the select query

Posted 20-Oct-10 20:32pm

jasna ashraf

Add a Solution

4 solutions

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)

Sunasara Imdadhusen · Answer 1 · 2010-10-20T21:05:00

Hi Please update path as per your requirement

C#

private static string UPLOADFOLDER = "Uploads";
public void LoadUploadedFiles(ref GridView gv)
    {
        DataTable dtFiles = GetFilesInDirectory(HttpContext.Current.Server.MapPath(UPLOADFOLDER));
        gv.DataSource = dtFiles;
        gv.DataBind();
        if (dtFiles != null && dtFiles.Rows.Count > 0)
        {
            double totalSize = Convert.ToDouble(dtFiles.Compute("SUM(Size)", ""));
            if (totalSize > 0) lblTotalSize.Text = CalculateFileSize(totalSize);
        }
    }


 public DataTable GetFilesInDirectory(string sourcePath)
    {
        System.Data.DataTable dtFiles = new System.Data.DataTable();
        if ((Directory.Exists(sourcePath)))
        {
            dtFiles.Columns.Add(new System.Data.DataColumn("Name"));
            dtFiles.Columns.Add(new System.Data.DataColumn("Size"));
            dtFiles.Columns["Size"].DataType = typeof(double);
            dtFiles.Columns.Add(new System.Data.DataColumn("ConvertedSize"));
            DirectoryInfo dir = new DirectoryInfo(sourcePath);
            foreach (FileInfo files in dir.GetFiles("*.*"))
            {
                System.Data.DataRow drFile = dtFiles.NewRow();
                drFile["Name"] = files.Name;
                drFile["Size"] = files.Length;
                drFile["ConvertedSize"] = CalculateFileSize(files.Length);
                dtFiles.Rows.Add(drFile);
            }
        }
        return dtFiles;
    }

Please do let me know, if you have any doubt.

Please provide "Vote" if this would be helpful, and make "Accept Answer" if this would be correct answer.:rose:

Thanks,
Imdadhusen

Abhinav S · Answer 2 · 2010-10-20T20:51:00

Solution 1

Select queries are used to query a database - not the desktop.

Have you got a list of all the desktop files in a collection already?
You can use LINQ queries to filter out the collection then.

Posted 20-Oct-10 20:51pm

Abhinav S

Rajesh Anuhya · Answer 3 · 2010-10-20T20:56:00

Solution 2

use the system.io.directory.getfiles method for get the files list in the specified directory..,

go through the below link in Google., there are so many examples..,

Get File List.. [^]

you can't get file list in desktop using select query...

Posted 20-Oct-10 20:56pm

Rajesh Anuhya

Hiren solanki · Answer 4 · 2010-10-20T20:57:00

Hello,
If you want to get all the filelist from Desktop then It's not feasible with SQL server, It doesn't store your M/C file metadata.

Yes, But you could accomplish this using LINQ on FileInfo

i.e

C#

System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(@"C:\Documents and Settings\hiren.solanki\Desktop");
        IEnumerable<System.IO.FileInfo> files = dir.GetFiles();
        var FileCollection = from file in files
                             select new
                             {
                                 FileFullName = file.Name,
                             };
        foreach (var file in FileCollection)
        {
            Response.Write(file.FileFullName);
            Response.Write("<br/>");
        }

Replace your desktop path inside DirectoryInfo constructer.
Please vote and Accept Answer if it Helped.

Select Query

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0