Databases
StackOverflow2013
Postsdbo
POHow to add a large amount of records from Microsoft Office Access 2007 database into a list box control using the native C++ WIN32 API
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to add a large amount of records from Microsoft Office Access 2007 database into a list box control using the native C++ WIN32 API
    primarykey
    data
    text
    <h2>How to add a large amount of records from <em>Microsoft Office Access 2007</em> database into a <em>list box</em> control using the <em>native C++ WIN32 API</em>?</h2> <p>Hello friends! I want to make a dictionary like Microsoft Encarta English Dictionary using the native C++ WIN32 API. My database is Microsoft Office Access 2007 format database which has 21,364 records (filled with vocabularies and their meanings). I want to add the vocabularies into a list box control using the "<code>CreateWindow</code>" function with the "<code>listbox</code>" window class name as fast as possible so that no one will get annoyed of waiting. </p> <p>I am very much interested in the <strong>OLE DB</strong> database connection method as it is said to be the fastest of all other methods. I followed the OLE DB tutorial as given in this link: <a href="http://msdn.microsoft.com/en-us/library/office/ff965871%28v=office.14%29" rel="nofollow">http://msdn.microsoft.com/en-us/library/office/ff965871%28v=office.14%29</a>. Following the tutorial, I successfully connected to the database of <strong>Microsoft Office Access 2007</strong> format having 21,364 records and added the vocabularies into the list box using the "<code>SendMessage</code>" function with the "<code>LB_ADDSTRING</code>" message type within a "<code>for</code>" loop. </p> <p>However, I feel that adding the <strong>21,364 records</strong> into the <strong>list box</strong> using the "<code>for</code>" loop takes a bit longer than someone could patiently wait. On the contrary, I am sure the <em>Microsoft Encarta English Dictionary</em> should be having millions of vocabularies and they all added into a list box so fast that someone would burst out with joy!</p> <p>Can anyone please kindly tell me, guide me, show me with code examples how to speed up my adding <em>huge amount</em> of <strong>Microsoft Office Access 2007</strong> database records into a <strong>list box</strong> using the <strong>native C++ WIN32 API</strong>? I shall be very thankful!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USBhaddiya Tanchangya
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COMaybe they won't get annoyed at waiting, but anybody would be annoyed at having to scroll through 21,364 items in a single listbox. You may wish to consider changing the design of your user interface to make it more user friendly.
      singulars
      1. POHow to add a large amount of records from Microsoft Office Access 2007 database into a list box control using the native C++ WIN32 API
      1. USGreg Hewgill
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload