How do I display files upload in a folder when string path saved to sql server

I have code that dynamically create a directory and saves the path in to a sql server table.

How do I query the sql server table to reference the path that was saved in the database to display all files in that folder.

example: 

directory.create = somefolder

then I save this new folder(somefolder) path location into my database table.

folderUrl = c:\somefolder

what I need to do now is 

query the sql server database table and display all files located in that folderUrl path

c:\somefolder.

so if the path c:\somefolder  has a total of 6 files.

in a grid the files will show up and not the path.