Re: Fast Load?
From: buzz (buzz_at_buzz.com)
Date: 08/16/04
- Next message: Eli Tucker: "Integrity Violation when syncing with SQL CE, but not MSDE"
- Previous message: Amy Yuan [MS]: "RE: How to check existance of table in sql ce"
- In reply to: John: "Fast Load?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 16 Aug 2004 19:34:40 -0400
John wrote:
> I posted this in the pocketpc.developer newsgroup but maybe this is the
> place to ask....
>
> I have created a VB.NET CE Pocket Pc 2002 application, and I need to load a
> combobox really fast from the SQL CE database...
>
> I have tried the DataAdapter.Fill(Dataset), and also the DataReader While
> Wend.
> They seem to take about the same amount of time to load (a few seconds)
>
> I have Three Tables, Books, Codes, and Book_Codes
>
> Codes is loaded into a Combobox and when the user selects a Code;
> Books Combobox is Loaded: Select * From Books, Book_Codes Where
> Book_Codes.BookID = Books.BookID
>
>
> Any one have a faster way of loading the combobox...
>
>
> Thanks,
>
> JO
>
>
You might want to look at the Redraw method of the combo box. Turn it
off while loading, then turn it back on. May also help with loading
performance.
- Next message: Eli Tucker: "Integrity Violation when syncing with SQL CE, but not MSDE"
- Previous message: Amy Yuan [MS]: "RE: How to check existance of table in sql ce"
- In reply to: John: "Fast Load?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
