I have couple of dropdown lists to filter data from gridview which works fine but I want to add Select Any where it shows the data without the filter.

http://i.imgur.com/zwIw23t.jpg

This is my SelectCommand in SQL datasource

SelectCommand="SELECT * FROM [Courses]
WHERE (([Language] = @Language) AND ([Level] = @Level)       
AND ([endDate] = @endDate) AND ([startDate] = @startDate))"

Related posts

Recent Viewed