Aug 14, 2008

How to search a directory and getting the directory path to connection string : c#

private void ResetConnectionString()
        {
            string dbDir = this.GetDBDirectory()+  @"\JSNorthWind.MDB";
            this.nWindConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbDir + ";";

        }
        private string GetDBDirectory()
        {
            System.IO.DirectoryInfo currentDirectory = new System.IO.DirectoryInfo(Application.ExecutablePath).Parent;
            
            while (currentDirectory!=null)
            {
                System.IO.DirectoryInfo[] childDirectories = currentDirectory.GetDirectories();
                foreach(System.IO.DirectoryInfo childDir in childDirectories)
                {
                    if(childDir.Name=="Data")
                    {
                        return childDir.FullName;
                    }
                }
                currentDirectory = currentDirectory.Parent;
            }
            return "";
        }

Send instant messages to your online friends http://uk.messenger.yahoo.com