Solved

Combo Box Contents

Posted on 1998-08-17
7
237 Views
Last Modified: 2013-11-20
I want the combo box data in the dropdown list to come from a database.. In the sense if I increased the database contents the dropdown box should show the added items.. How do you do this..
A sample code will be very helpful..

thanks

0
Comment
Question by:guranimo
  • 6
7 Comments
 
LVL 8

Accepted Solution

by:
Answers2000 earned 20 total points
ID: 1320931
Bind a CComboBox variable to the combo box using the class wizard (say m_combo)

To fill the combo do

m_combo.ResetContents() ;
CString strItem ;
while ( _GetRecord(strItem) )
{
    m_combo.AddString( strItem ) ;
}

You'll have to change _GetRecord to the appropriate function based on what database access technology you're using.  Call this function in WM_INITDIALOG (OnInitDialog) or after the user adds to the database.

If you mean - how do I do it such that whenever somebody else (multi user) updates the database, the combo auto updates, you'd have to
(i) Either create a timer message, periodically query the database, cache the last set of results, compare the new results.  If they don't match, refill the combo
or
(ii) When the combo gains the focus update it (you could be clever and put in a dummy item saying "*Please make a selection*" or something

0
 

Author Comment

by:guranimo
ID: 1320932
The ResetContent() and AddString (), while compiling are given as error and that they are not members of CSting..
0
 

Author Comment

by:guranimo
ID: 1320933
The ResetContent() and AddString (), while compiling are given as error and that they are not members of CSting..
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:guranimo
ID: 1320934
The ResetContent() and AddString (), while compiling are given as error and that they are not members of CSting..
0
 

Author Comment

by:guranimo
ID: 1320935
The ResetContent() and AddString (), while compiling are given as error and that they are not members of CSting..
0
 

Author Comment

by:guranimo
ID: 1320936
The ResetContent() and AddString (), while compiling are given as error and that they are not members of CSting..
0
 

Author Comment

by:guranimo
ID: 1320937
I have it initialized to CComboBox type variable but when I excecute the program it crashes at the line
m_combo.AddString(stringitem);
which leads to an assertion failure in line 751 of afxwin2.inl file where the addstring is described..
please help


thanx
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction: Load and Save to file, Document-View interaction inside the SDI. Continuing from the second article about sudoku.   Open the project in visual studio. From the class view select CSudokuDoc and double click to open the header …
Introduction: Hints for the grid button.  Nested classes, templated collections.  Squash that darned bug! Continuing from the sixth article about sudoku.   Open the project in visual studio. First we will finish with the SUD_SETVALUE messa…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now