StrataFrame Forum » .NET Forums » General .NET Discussion » Adding Items to ComboBox

Adding Items to ComboBox

Tim Dol — Mon, 27 Aug 2007 10:35:16 GMT

I need to add some functionality similar to the new user-defined category that you added to the DDT. I also believe the same functionality exists in the permissions editor. I added a new field to my table to store the category value.

What technique did you guys use to populate the category combobox with unique category values and drop the cateogry when it was no longer in use. Did you create another table to maintain these values?

Thanks

TIm

RE: Adding Items to ComboBox

Greg McGuffey — Mon, 27 Aug 2007 10:35:16 GMT

I think the key would be to have an index on the category (or whatever column your doing the select distinct on). Otherwise, there will be temp tables and table scans and it gets ugly fast.

RE: Adding Items to ComboBox

StrataFrame Team — Mon, 27 Aug 2007 08:25:40 GMT

We haven't had it slow down perceptively. If it ever does, you could certainly cache off the values in a Shared business object somewhere. I'm sure you might be able to find something on Google about the performance of a SELECT DISTINCT.

RE: Adding Items to ComboBox

Tim Dol — Fri, 24 Aug 2007 10:36:35 GMT

Will this be slow on large tables?

RE: Adding Items to ComboBox

StrataFrame Team — Fri, 24 Aug 2007 09:43:49 GMT

Actually, when we allow the user to manually type the category, we just fill the combo box by using

SELECT DISTINCT category FROM MyTable ORDER BY category

which just retrieves all of the values. When all of the records using the category are removed or moved to another category, it just no longer appears in the list because it's no longer in the table and therefore doesn't get picked up by the query.