Items from database

I'm using TouchListBox to make guided search in a table of my database.

I have "Product Table" with the followings information

code, description, brand, Families ,type

and i would to use three steps to show list of brand, list of family (filtered by brand) and list of type (filtered by brand and family)

When the search form is loaded, i query my database for populate the TouchListBox with "list of brands on my product table"

When the user click one item i show second page and than the third

( Brands --> Famils --> Type)

For all page i make query to local sqlmobile database even for "next page" and "previous page" event

It's possible to save the state of TouchListBox avoiding to reload every time the listbox's item ?

Kind Regards

any suggestions ?

How many rows are in your table ?

(22-03-2010 20:28)PhillipMorris Wrote:  How many rows are in your table ?

For the first level about 50 records ... second level 30 records

You could store 3 List<TouchListItem> lists in memory for each level.

Then you just need to assign the list to the TouchListBox:

touchListBox1.Items = myStoredList;

(23-03-2010 12:30)Sascha Lange Wrote:  You could store 3 List<TouchListItem> lists in memory for each level.

Then you just need to assign the list to the TouchListBox:

touchListBox1.Items = myStoredList;

mmm...but the Items collection of touchListBox1 is readonly ??

Sorry my fault.

With TC2 it will be possible.

With TC 1.x: You could store the information in your own structure and just need to fill the list while changing the filter.

(23-03-2010 16:59)Sascha Lange Wrote:  With TC 1.x: You could store the information in your own structure and just need to fill the list while changing the filter.

No problem Sascha, thanks for the reply

Can you post a little example for store information ?

(23-03-2010 17:24)s_d_o Wrote:  Can you post a little example for store information ?

up