String format different than..

Question

0.00/5 (No votes)

See more:

Hello

Im trying to filter a datatable, i´m using this and it works:

C#

DataRow[] rowsTarget = dt3.Select(string.Format("CodigoKitDC={0}", row["Items"]));

but now i need to have the rest of the data,

how can i make a string format with the different, something like this:

C#

string.Format("CodigoKitDC != {0}", row["Items"]));

but it not Works.help please

What I have tried:

string.Format("CodigoKitDC != {0}", row["Items"]));

string.Format("CodigoKitDC <> {0}", row["Items"]));

Posted 10-Jul-18 1:28am

drvfn

Updated 10-Jul-18 2:27am

CHill60

v5

Add a Solution

Comments

Kornfeld Eliyahu Peter 10-Jul-18 8:15am

What do you mean 'not works'?
Any error?

3 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)

F-ES Sitecore · Answer 1 · 2018-07-10T02:28:00

Solution 3

I googled "datatable select not equal" and this was the first result

datatable - c# How do I specify a not in a select statement? - Stack Overflow[^]

Please do basic research such as searching before you ask a question.

Posted 10-Jul-18 2:28am

F-ES Sitecore

OriginalGriff · Answer 2 · 2018-07-10T02:27:00

Solution 2

That's because the filter uses "<>" not "!=" for "not equal to".
Try

string.Format("CodigoKitDC <> {0}", row["Items"]));

Posted 10-Jul-18 2:27am

OriginalGriff

Comments

Kornfeld Eliyahu Peter 10-Jul-18 8:44am

Actually T-SQL knows both != and <>...
The problem is with the .NET layer that knows only standard...

OriginalGriff 10-Jul-18 8:53am

I know: did I mention SQL? :laugh:

#realJSOP · Answer 3 · 2018-07-10T02:25:00

Since the expression is in a string literal, you have to use SQL syntax, thus "<>" is the correct inequality operator.

Saying "but it not work" does not give us enough information to help you further. Put your code into a try/catch block so you can see the exception being generated (if any).

Go here for a complete list of valid operators for the Select method expression. You'll need to scroll about halfway down the page:

DataColumn.Expression Property (System.Data)[^]