Database records filtering

[asad]

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/de...ClassTopic.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
"asad" <as**@discussions.microsoft.com> wrote in message
news:A9**********************************@microsof t.com...

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

[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.

-Brock
DevelopMentor
http://staff.develop.com/ballen

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