Consider Northwind Database as a sample,
<
asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CategoryID"
DataSourceID="SqlDataSource1" AutoGenerateDeleteButton="true">
<Columns>
<asp:BoundField DataField="CategoryID" HeaderText="CategoryID" SortExpression="CategoryID" />
<asp:BoundField DataField="CategoryName" HeaderText="CategoryName" SortExpression="CategoryName" />
<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT * FROM [Categories]" FilterExpression="CategoryID={0}" >
<FilterParameters>
<asp:QueryStringParameter ConvertEmptyStringToNull="true" QueryStringField="Fid"
DbType="Int32" />
</FilterParameters>
</asp:SqlDataSource>
You can able to use the grid view using SQL Data Source to automatically filtering the categories.