namespace MissingImages
{
    public partial class frmImages : Form
    {
        public frmImages()
        {
            InitializeComponent();
        }
 
        private void btnGetDirFiles_Click(object sender, EventArgs e)
        {
 
 
 
                DirectoryInfo dirCustom = new DirectoryInfo("\\\\disk2\\images\\Missing Images");
 
                FileInfo[] filCustom;
 
                filCustom = dirCustom.GetFiles(); 
 
 
 
        }
 
        private void btnOBJTable_Click(object sender, EventArgs e)
 
        {
            SqlCommand cmd = new SqlCommand();
 
             {
                frmImages rd = new frmImages();
                rd.SimpleRead();
             }
        }
 
		public void SimpleRead()
		{
 
			SqlDataReader rdr = null;
 
			SqlConnection conn = new SqlConnection( "Server=TSQLTVS;UID=notreal;PWD=alsonotreal;Database=Flowtiva");
 
			SqlCommand cmd = new SqlCommand("select FILENAME, SOID from obj", conn);
 
			conn.Open();
 
			rdr = cmd.ExecuteReader();        		        
 
 
 
        }
 
 
    }
}

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.IO;
 
public class Program {
    private readonly string SERVER_PATH = @"\\server\directory";
    private readonly string LOCAL_PATH = @"C:\users\username\documents\images";
    private readonly string CONNECTION_STRING = "@some;sql=connection; string";
 
    [STAThread]
    public static int Main( string[ ] args ) {
        List<string> filesInDatabase = GetDatabaseFileName();
        List<string> filesOnServer = GetServerFileNames();
 
        foreach ( string fileName in filesOnServer ) {
            if ( !filesInDatabase.Contains(fileName) ) {
                // do copy code here which might look something like
                // the file names include the fullpath
                if ( File.Exists(fileName) ) {
                    try {
                        File.Copy(fileName, LOCAL_PATH + Path.GetFileName(fileName));
                    } catch ( Exception exception ) {
                        // Display some error notification here
                    }
                }
            }
        }
    }
 
    protected static List<string> GetDatabaseFileName( ) {
        List<string> returnValue = new List<string>();
 
        using ( SqlConnection connection = new SqlConnection(CONNECTION_STRING) ) {
            connection.Open();
 
            try {
                using ( SqlCommand command = connection.CreateCommand() ) {
                    command.CommandType = CommandType.Text;
                    command.CommandText = @"Place your SQL query here";
 
                    using ( SqlDataReader dataReader = command.ExecuteReader(CommandBehavior.CloseConnection) ) {
                        while ( dataReader.Read() ) {
                            returnValue.Add(dataReader.GeString(0));
                        }
                    }
                }
            } catch ( Exception exception ) {
                throw exception;
            } finally {
                connection.Close();
            }
        }
 
        return returnValue;
    }
 
    protected static List<string> GetServerFileNames( ) {
        List<string> returnValue = new List<string>();
 
        if ( Directory.Exists(SERVER_PATH) ) {
            string[ ] files = Directory.GetFiles(SERVER_PATH);
            returnValue.AddRange(files);
        }
 
        return returnValue;
    }
}

        List<string> SOIDs;
        List<string> filesInDatabase = GetDatabaseFileName(out SOIDs);
       List<string> filesOnServer = GetServerFileNames();
 
        foreach ( string fileName in filesOnServer ) 
 
        {
            string fileOnly = Path.GetFileNameWithoutExtension(fileName).ToString();
 
            if ( filesInDatabase.Contains(fileOnly) ) 
            {
 
                int index = filesInDatabase.IndexOf(fileOnly);
                if (index >= 0)
                {
                    if ( !File.Exists(SOIDs[index]) ) 
                    {
 
 
                        txtFiles.AppendText(fileOnly + "   " + SOIDs[index] + "\r\n");
 
 
                    }
                }
            }
        }
 
    }
 
    protected static List<string> GetDatabaseFileName( out List<string> SOID) 
    {
        List<string> returnValue = new List<string>();
        SOID = new List<string>();
        using ( SqlConnection connection = new SqlConnection(@"Server=TSQLTVS;UID=*****;PWD=**********;Database=Flowtiva")) 
        {
            connection.Open();
 
 
                using ( SqlCommand command = connection.CreateCommand() ) 
                {
                    command.CommandType = CommandType.Text;
                    command.CommandText = @"SQL query here";
 
                    using ( SqlDataReader dataReader = command.ExecuteReader(CommandBehavior.CloseConnection) ) 
                    {
                        while ( dataReader.Read() ) 
                        {
                            returnValue.Add(dataReader.GetString(0));
 
                            SOID.Add(dataReader.GetString(1));
                        }
                    }
                }
 
        }
 
        return returnValue;
        }
 
        protected static List<string> GetServerFileNames()
        {
            List<string> returnValue = new List<string>();
 
            if (Directory.Exists("\\\\disk2\\images\\Missing Images"))
            {
                string[] files = Directory.GetFiles("\\\\disk2\\images\\Missing Images");
 
                returnValue.AddRange(files);
 
            }
            return returnValue;
 
        }
 
 
 
 
    }