I'm using a TableAdapter and the query looks similar to the following:
SELECT * FROM Table WHERE Type In (@type)
From my ASP.NET page, the type can either be All, A, B, or C (All should incorporate A, B, & C). The query works with a single parameter (meaning A, B or C) but when I select the "All" option the query doesn't return any rows.
Does anyone have any suggestions on how to query the table using a drop down list with the values "All", A, B, or C?