C#

const string query = "SELECT answer FROM AnswersToAllQuestions WHERE question LIKE @question";    
    using (MySqlCommand dbCmd = new MySqlCommand(query, dbCon)) {
        dbCmd.Parameters.AddWithValue("@question", "%"+question+"%");

Super Lloyd wrote:

But now if fails

Super Lloyd wrote:

maybe the sysadmin change some AD setting?

catch (System.UnauthorizedAccessException uax)
{
    if (uax.Message.Contains("$Recycle.Bin"))
    {
        // ignore trashcan
    }
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

exception handler does not work. And I don't know how to use object.ForEach.

I have also tried to use LINQ like this but it does work.

string[] originalFiles = Directory.GetFiles(sourceFolder, "*", SearchOption.AllDirectories).Where(f => !f.Contains("System Volume Information").ToString())

Is it possible in this case to use LINQ?

Member 14055879 wrote:

exception handler does not work.

Member 14055879 wrote:

And I don't know how to use object.ForEach.

Member 14055879 wrote:

Is it possible in this case to use LINQ?

public Form1()
{
    InitializeComponent();
    string[] originalFiles = GetNonSystemFiles(@"C:\");
    foreach (string originalFileLocation in originalFiles)
    {
        // stuff
    }
}

string[] GetNonSystemFiles(string path)
{
    DirectoryInfo di = new DirectoryInfo(path);

    // reserve list for result
    List<string> result = new List<string>();

    // get folders
    IEnumerable<DirectoryInfo> folders = null;
    try
    {
        folders = di.EnumerateDirectories("*", SearchOption.TopDirectoryOnly);
    }
    catch (System.UnauthorizedAccessException uax)
    {
        System.Diagnostics.Debug.WriteLine("Unauthorized folder for: {0}, ex: {1}", di.Name, uax.Message);
    }

    if (null != folders)
        foreach (DirectoryInfo folder in folders)
        {
            result.Add(folder.FullName);

            // get this folders' contents and add it to the result too
            if ((folder.Attributes & FileAttributes.System) != FileAttributes.System // skip system folders
            && (folder.Attributes & FileAttributes.Hidden) != FileAttributes.Hidden) // skip hidden folders
                result.AddRange(GetNonSystemFiles(folder.FullName).ToList());
        }

    // get files for this folder
    IEnumerable<FileInfo> fileInfos = null;
    try
    {
        fileInfos = di.EnumerateFiles("*", SearchOption.TopDirectoryOnly);
    }
    catch (UnauthorizedAccessException uax)
    {
        System.Diagnostics.Debug.WriteLine("Unauthorized file for: {0}, ex: {1}", di.Name, uax.Message);
    }
    if (fileInfos != null)
        foreach (FileInfo fileInfo in fileInfos)
        {
            result.Add(fileInfo.FullName);
        }

    return result.ToArray();
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.