filtering on gridview control VS-2008
<p>This is what I am working with to get back to the web  dev world</p>

<p>ASP.Net with VS2008</p>

<p>Subsonic as Data Access Layer</p>

<p>SqlServer DB</p>

<p>Home Project description:
I have a student registration system. I have a web page which should display the student records. </p>

<p>At present I have a gridview control which shows the records</p>

<p>The user logs on and gets to the view students page. The gridview shows the students in the system, where one of the columns is the registration status of open, pending, complete.</p>

<p>I want the user to be able to apply dynamic sorting or filters on the result returned so as to obtain a more refined result they wish to see. I envisioned allowing user to filter the results by applying where clause or like clause on the result returned, via a dataset interface by a subsonic method. I do not want to query the databse again to apply the filter</p>

<p>example: initial query </p>

<pre><code>Select * from studentrecords where date = convert(varchar(32,getdate(),101)
</code></pre>

<p>The user then should be able to applly filter on the resultset returned so that they can do a last name like '%Souza%'</p>

<p>Is this even possible and is binding a datasource to a gridview control the best approach or should i create a custom collection inheriting from collectionbase and then binding that to the gridview control?</p>

<p>PS: Sorry about the typo's. My machine is under the influence of tea spill on my laptop </p>
