Get The Specific Files From Directory

Hi,

      I have some some files names in SQL DATABASE but my actuall files are keep in a seperate folder. so please help me that becasue i dont know that how i can select the specific files from folder and fetch into the imageArray according to the database table. In my coding its get the all files from directory but i want to get from database with where class and then select from directory.

The structure of my table is

create table event_pic
(
  event_sub_id integer,
  event_pic_name varchar(50)
)


here is code below:

Sub displayMe()
 
    dim con as new SQLConnection("server=london-home; Database=tony; uid=rashid2; pwd=test; ")
    dim cmd as new SQLCommand("select * from event_pic where event_sub_id='5' ",con)
    
  con.open()
   
 dim SDR as SQLDataReader
 SDR = cmd.ExecuteReader()
  
 
  
  con.close()
   
 
        Dim imageArray() As String
        Dim i As Integer
       
        ' grab full path and file of images on server in images folder
        imageArray = Directory.GetFiles(Server.MapPath("upload/"), "*.*")
 

       ' remove the full path from the image filenames
        For i = 0 To (imageArray.Length - 1)
            imageArray(i) = Replace(imageArray(i), Server.MapPath("upload/"), "")
           
        Next
        
 
        ViewImages.DataSource = imageArray
        ViewImages.DataBind()
       
       
    End Sub