Solved

Combo Box Contents

Posted on 1998-08-17
7
259 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008.  These same feature are in the MFC libraries that come with Visual …
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 is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

717 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