Wednesday, September 12, 2007

DataTable Select Method

The Select method is really handy for filtering and sorting the rows you need from a strongly typed dataTable. It has 3 overloads Select() for returning all the rows as an array select(stringFilter) for returning the rows with out sorting and Select(stringFilter,stringSort) for returning rows with sorting. Here is quick way to fire everyone with the first name of bob in your employee management application.

EmployeeDataSet.PeopleRow[] people = peopleDataTable.Select("FirstName = bob AND Fired = 0", "LastName") as EmployeeDataSet.PeopleRow[];

 foreach (EmployeeDataSet.PeopleRow person in people)
 {
     person.Fired = true;
 }

more Info:
MSDN
even better example

Comments [3]

Tuesday, June 09, 2009 3:06:34 PM (GMT Standard Time, UTC+00:00)

I have a column where file paths are stored. I want to see if the file path exists. The select method is havning trouble parsing all the slashes and the colon.

So then I replaced them with nothing and it still puked out because one of the folders was "1100." So right in the middle of my search string was 1100 which I thought was no big deal. It says it can't parse that as well.

Jesse Seger

Sunday, June 21, 2009 11:32:01 AM (GMT Standard Time, UTC+00:00)

Good evening. They can conquer who believe they can. Help me! Help to find sites on the: Lamisil oral tablets. I found only this - buy Lamisil. Eicosanoid receptor agonists and antagonists. Cisplatin global directory of cisplatin supplier containing detailed information ocallplatin, tegafur, terbinafine hydrochloride, isosorbide monoltrate. THX :-(, Caspar from Singapore.

Caspar

Saturday, June 27, 2009 11:23:46 AM (GMT Standard Time, UTC+00:00)

Hi everyone. It is wonderful how quickly you get used to things, even the most astonishing. Help me! Need information about: Prograf patient assistance programs. I found only this - Prograf mr astellas fda approval. Inks, cartridges toners canon ink cartridges toners canon image prograf from graphic design supplies ltd graphic design supplies ltd of. Recall first of all if you experienced the tinnitus even before you began taking the medicine. :-) Thanks in advance. Abram from East.

Abram

Name
E-mail	(will show your gravatar icon)
Home page

	Remember Me
Comment (Some html is allowed: `a@href@title, strike`) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview