Solved

I  want  to  exclude  values  which  contains  string  which has "<"

Posted on 2015-01-29
2
75 Views
Last Modified: 2016-02-17
Here  DTQCResult  is  a  DataTable.
Some  time  it  happens  that  ResultValue comes  as ">50" or "<40" etc  so  I  want  to  exclude  those  values  which contains operators ">" or "<". I  was  successful  in  exclusing  ResultValue  that  comes  "NA". Please  help.
Following is  line  where  I  have  to  do  it.So  that  in  deSelectect  does  not  have  values  with ">" or this "<"

DataRow[] drSelectect = DTQCResult.Select("CheckCol=1 AND ResultValue <> 'NA'");

Open in new window


Please  it little  bit  urgent
0
Comment
Question by:enthurao
2 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40577189
HI,

pls try

DataRow[] drSelectect = DTQCResult.Select("CheckCol=1 AND ResultValue <> 'NA'" AND ResultValue NOT LIKE '*<*' AND ResultValue  NOT LIKE '*>*'");



Regards
0
 

Author Closing Comment

by:enthurao
ID: 40577204
Thank you very  much  it  worked  perfectly
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now