Database records filtering

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASP.NET with VB.NET sql statement for MS ACCESS 5
How to get row count in SqlDataSource 5
Excel Filter Listview userform VBA 0
Database record filtering 2
ASP.NET paging help 2
VBA: How can I use a string variable as autofilter criteria? 4
ASP.NET custom paging with next link 2
Macro to copy value in field and insert it into filter 2

Back
Top