You can use the Directory.GetFiles method to get a list of file paths in a directory. It also allows you to filter based on the pattern of the file name, which would usually be by extension. You can then then use a For Each loop to go though that list of files. For each one, you can read the contents using the File class or, for more fine control, a StreamReader. ADO.NET can then be used to update your database. Finally, the File.Delete method will delete the file. You can find examples of any and all of those steps if you search the web. Don't expect an "example" of the entire process exactly as you want to do it because that's not an example. Examples show you how to do the bits and then you put the bits together to do what you want done.