Filter GridView using CheckBoxes and Sql Query in ASP.Net

hi im new to ms sql server, i need a query for multiple selection of check boxes  like flipkart. The below images shows how the filters works suppose if we selected fastrack, fcuk in Brand and price as rs 1001 - rs 2000 and strap as leather only that selected check box will be show. if all are unchecked all brands and prices will show same like that ms sql query filters i need it. thanks in advance