How to check particular datacolumn contains given value with out looping

Question

0.00/5 (No votes)

See more:

.NET3.5

C#

.NET

hi,
How to i check particular datacolumn contains given value with out looping, datacolumn from a datatable,

Posted 14-Sep-11 3:17am

Marikani P

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Answer 1 · 2011-09-14T03:58:00

Use DataTable's Select(String expression) method. This method returns an array of DataRows (DataRow[]). So all you have to do is to check if the Length property of said returned array is greater than zero and your done.

Here is the MSDN reference: http://msdn.microsoft.com/en-us/library/det4aw50%28v=VS.90%29.aspx[^].

Best Regards,

—MRB

dave.dolan · Answer 2 · 2011-09-14T03:59:00

Solution 2

You really can't... You can write LINQ code that effects a where clause to filter it, but even if YOU aren't looping IT is. Loops are a basic, nearly inescapable prospect in programming. If you're looking for magic, I'm afraid you'll have to keep looking.

var rowsWithTheValue = myTable.Rows.Where(a => a["Column"] == value);

Posted 14-Sep-11 3:59am

dave.dolan

Comments

Manfred Rudolf Bihy 14-Sep-11 10:02am

I think this is what OP was after: Trying to avoid to explicitely loop through the data table. 5+