The DB Browse binding is easy to get started, and helps create queries for you. Let's get started.
In the DB Browse binding, you can also do ordering of data in the table. There is a Sort button that allows you to sort in ascending and descending order. Using the same example, let's have the area column of our table be the key column so you can only see the entries for area B, and return all the operators, siteid, and supervisors columns in the table. We'll also order the data by the number of operators at each site in ascending order.
Confirm the binding by clicking OK to produce the specified data in the table. Only area B rows are shown, and our data is being sorted in ascending order of our operators column.
This example only had one key and one order column, but you can add as many as you want. Just select a second column and hit the Key or Sort buttons.
DB Browse bindings also give the ability to bind a property to the key column to allow for dynamic filtering of the returned data. This allows you to give the operators some control over the data they are seeing. This example is using a list of companies that has their respective city and state.