Help with GridView

[nomad]

Hi,

I have a grid which has a datasource of a table in my database. I
want to be able to filter it based on what someone selects from either
an option or a text box. If they select from an option it will look
at all records for that day, if the text box it will look for all
records within the last x minutes. Is this possible to do?

Appreciate any help on this

 

[Eliyahu Goldin]

You can filter either in the database select statement or on the DataTable
object that contains the data loaded from the database. In the former case
you may want to use SqlDataSource control with some ControlParameters. In
the latter case you will need to load data first into a DataTable, then
create a DataView with your filtering conditions and to databind the grid to
the DataView. The first approach is simpler to implement.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

 

[David Wier]

Check out these code samples:
http://www.aspnet101.com/aspnet101/aspnet/codesample.aspx?code=searchGridView
http://www.aspnet101.com/aspnet101/aspnet/codesample.aspx?code=ddlSearchGridview

David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup
http://cg.augustwind.com - ControlGrouper - new ASP.Net control from
AugustWind