Database records filtering

[Guest]

Hello, i want to filter my records in ASP.NET pls tell me how can i do it
thanks

 

[singh_angrez]

Hi,

You can use DataView class of .net framework to filter the rows. For
more info
http://msdn.microsoft.com/library/d...ef/html/frlrfSystemDataDataViewClassTopic.asp

Regards,
angrez

 

[Jeebu]

hi,
u can use the dataview filter property for filtering.
suppose ds is the name of the dataset.
create a view
dataview dv;
dv=ds.tables[0].defaultView;
dv.RowFilter="Name='joan'";
if u want to sort
dv.sort="Name ASC";

grid.datasource=dv;
grid.databind()

cheers
jeebu

 

[Brock Allen]

You can either build a where clause into your SQL or you use the DataView
(by setting the RowFilter property) on a DataTable when loading data into
a DataSet. Otherwise you're on your own if you use some other data storage
mechanism.