Click here to Skip to main content
15,918,343 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
My program work properly when i use FileSystemWatcher to watch files outside FileTable. When i watch files on FileTable, no any event occur. Who can tell me why?

// Create a new FileSystemWatcher and set its properties.
FileSystemWatcher watcher = new FileSystemWatcher();
watcher.Path = @"\\Dicthanhkha\sqlexpress\DiTranFiles\DiTranslator";
/* Watch for changes in LastAccess and LastWrite times, and
   the renaming of files. */
watcher.NotifyFilter = NotifyFilters.LastWrite | NotifyFilters.FileName;

// Only watch text files.
watcher.Filter = "*.txt";

// Add event handlers.
watcher.Changed += new FileSystemEventHandler(OnChanged);
watcher.Created += new FileSystemEventHandler(OnChanged);
watcher.Deleted += new FileSystemEventHandler(OnChanged);
watcher.Renamed += new RenamedEventHandler(OnRenamed);

// Begin watching.
watcher.EnableRaisingEvents = true;

// Define the event handlers.
private static void OnChanged(object source, FileSystemEventArgs e)
    // Specify what is done when a file is changed, created, or deleted.
    Console.WriteLine("File: " + e.FullPath + " " + e.ChangeType);

private static void OnRenamed(object source, RenamedEventArgs e)
    // Specify what is done when a file is renamed.
    Console.WriteLine("File: {0} renamed to {1}", e.OldFullPath, e.FullPath);
Updated 14-Apr-16 3:20am
Gautham Prabhu K 14-Apr-16 8:29am    
Please share the error or exception message.

1 solution

Directory change notifications are not supported in FileTable directories:

File System Functionality Supported in FileTables:
Directory change notifications: No

You'll need to use a SQL trigger on the table instead.
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900