Limit combo box choice according to database created in folder

shinyhui · #1 21-Feb-2005, 19:28

i creating database by month, so every month i got a database to store the data.. in my application i would like to have a combo box to select which database i would like to display according to month and year...

how can i code my combo box to only display database that have created in my folder? example: in my folder i have Jan05, Feb05 and Mar05 database so my combo box only have the choice of Jan05, Feb05 and Mar05 for me to selected.

Max Payne · #2 21-Feb-2005, 20:20

i guess you are using MFC, so you should use CFileFind class to get the file names in your folder and display it in the combo box. since I currently don't hav a VC++6.0, so can't post the exact program that works, but here is a guide...

CFileFind has the member function to find filed in a folder based on the file name pattern passed to the function, for example:

FindFile(_T("*.txt"))) will find file with '.txt' extensions, so in your case,
FindFile(_T("*.mdb"))) will find files with the mdb extensions for the data base, or if you your data base is of other type, then use accordingly..

here is a code saple which gts all the files in a directory:

CPP / C++ / C Code:

   CFileFind finder;
   BOOL bWorking = finder.FindFile("*.*");
   while (bWorking)
   {
      bWorking = finder.FindNextFile();
      CString MyFileName =   finder.GetFileName() ;
      // then insert the filename to your combo box
   }

the above sample code gets all the file, so do a litle editing so that it gets only the database file, i use '.mdb' here for my database:

CPP / C++ / C Code:

   CFileFind finder;
   BOOL bWorking = finder.FindFile("*.mdb");
   while (bWorking)
   {
      bWorking = finder.FindNextFile();
      CString MyFileName =   finder.GetFileName() ;
      // then insert the filename to your combo box
   }

BTW: if you want to post MFC related question, plase post in the MFC or Visual C++ Forum.

shinyhui · #3 21-Feb-2005, 20:38

Quote:

Originally Posted by Max Payne

i guess you are using MFC, so you should use CFileFind class to get the file names in your folder and display it in the combo box. since I currently don't hav a VC++6.0, so can't post the exact program that works, but here is a guide...

CFileFind has the member function to find filed in a folder based on the file name pattern passed to the function, for example:

FindFile(_T("*.txt"))) will find file with '.txt' extensions, so in your case,
FindFile(_T("*.mdb"))) will find files with the mdb extensions for the data base, or if you your data base is of other type, then use accordingly..

here is a code saple which gts all the files in a directory:

CPP / C++ / C Code:

   CFileFind finder;
   BOOL bWorking = finder.FindFile("*.*");
   while (bWorking)
   {
      bWorking = finder.FindNextFile();
      CString MyFileName =   finder.GetFileName() ;
      // then insert the filename to your combo box
   }

the above sample code gets all the file, so do a litle editing so that it gets only the database file, i use '.mdb' here for my database:

CPP / C++ / C Code:

   CFileFind finder;
   BOOL bWorking = finder.FindFile("*.mdb");
   while (bWorking)
   {
      bWorking = finder.FindNextFile();
      CString MyFileName =   finder.GetFileName() ;
      // then insert the filename to your combo box
   }

BTW: if you want to post MFC related question, plase post in the MFC or Visual C++ Forum.

if MyFileName = abc_Jan05.mdb
but i just want Jan05 show in my combo box how can i limit it?

Max Payne · #4 21-Feb-2005, 21:58

Quote:

Originally Posted by shinyhui

if MyFileName = abc_Jan05.mdb
but i just want Jan05 show in my combo box how can i limit it?

that you need to chop the string your self...
is all your files would hav the same filename format, like the above 'abc_Jan05.mdb'??

the a litle CString oprations could do what you want:

CPP / C++ / C Code:

CString strAfter;
CString strFileName = "abc_Jan05.mdb";

int nLeft = strFileName.Find('_');
int nRight = strFileName.Find('.');

strAfter = strFileName.Mid(nLeft,nRight);

strAfter would have 'Jan05'..

hope that helps...

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Yet another CD burner problem: Lite-On LSC-24082K	Erwin	Computer Hardware Forum	1	22-May-2004 11:28