Cool

Thanks again Trent, that was the problem. Still learning new stuff every day!

Edhy Rijo

Change the binding property to Text instead of the SelectedValue. Bet that is your problem

Here are some screenshots.

Edhy Rijo

I have setup my combobox and get the data OK, but if I type in the Category instead of selecting from the combobox it does not persist and is never saved. In other words, I cannot enter any value in the combobox.



What am I missing?

Edhy Rijo

No problem

Understood! thanks again

Edhy Rijo

Actually I created a sproc to update all of the categories at once then I reload the BO. That way there are fewer changes and queries going back and forth. I did it as you had mentioned originally, but it was so slow the larger the project became that I did it in a single query, requeried, then set the index back on the changed item.

Great, it is in fact simple.



One more question, in the Tree shortcut menu there is an option to "Rename" the categories, I guess in your case you will just filter out the BO for this category and rename them all in a one pass, right? or is there another more efficient trick?

Edhy Rijo

Sure. It really isn't that complicated. It is just another VarChar field in the same table. Then the combo populates with the Distinct values for the project. This way it doesn't "bleed" into other projects where the category is not defined. If you prefer to show all distinct categories across all projects (using this example) then you would not add a WHERE to filter out the categories for the project.



So generally I will create a FillWithDistinctCategories method in the BO that has the category field and then populate the combo from there.



Let me know if you need more explanation.