Say you have a search form, and it is detailed. The user fills out all kinds of possibilities, that when the query string is built, it has a load of if/else's etc.
Now you want to implement that behavior in a table adapter. Table adapters require a set query string or a stored procedure don't they? How would you implement the if/else behavior required to build the query string within a table adapter?