-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: LovedJohnySmith
Message 3 in Discussion
Yogesh: If you want to do direct filter records for your selection criteria
without XPath Querying over Dataset, then please prefer DataSet.Select option.
Basically we can achive this in two ways... First thing, You need to Filter
your records using DataSet.Select Statement(e.g., ds.Tables[0].Select("<< Your
Condition >>") or You can easily achive this by using DataView..... Dim
myView as DataView
myView = ds.Tables("Type").DefaultView Next, let's say you wanted to filter
out all but those TypeName from a particular TypeID. Here, you would use the
RowFilter property of the DataView. Think of the RowFilter property in the same
way you would use a 'WHERE clause' in your SQL statements. You would assign
data to the RowFilter proprety something like this:
myView.RowFilter = "ItemName = 'item5'" <--- Please put your criteria over
here....
This would return all TypeID, ItemID from the Item5 or Item6 or whatever your
condition. Naturally, you could, similarly, use any of the operators which are
available in a 'Where clause', like =, >, <. <>, etc. And, naturally, you can
use the Sort and RowFilter properties together in order to create a more
powerful combination. Please have a look at the following URLs, you can get
better idea about RowFilter and Filter with Dataset concepts.
http://aspnet101.com/aspnet101/tutorials.aspx?id=31
http://www.akadia.com/services/dotnet_filter_sort.html
Thanx,
Smith
http://spaces.msn.com/members/johnysmith
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
