Here is a very good GridView tutorial on MSDN:
Table of Contents: GridView Examples for ASP.NET 2.0[
^]
You can write a stored procedure which will accept 'status' and 'discipline' as a parameter and get the filtered data from the database into a
DataTable
. Bind your
GridView
to the
DataTable
. Depending on the usage and amount of data, you may also get all data at a time and use a DataView to filter them on the server side. Check out which of option gives you a better performance.
Hope this helps! :thumbsup: