I filtered a Repeater using a database over other database as explained on this tutorial:
Everything works nicely until I stumbled on a problem to display all products unfiltered.
Now I have 2 questions:
1. Since the displayed menus are based on database, how to add an option in the table named "ALL" that display all items unfiltered?
2. Sort of displayed item is based on database sorting set. I want to sort an option named: "ALL" on the top of the list, followed by "INDONESIA" on the second, and then the rest sort by alphabetic.
How can I do a manual sorting?
Thank you for your kind support.