![]()
Using DataView.RowFilter for filtering special characters.
Reply
![]() |
|
From:
![]() ![]() commander4u
|
I think Rowfilter property can take anything which can be specified in
a valid WHERE clause of an SQL query, except that you can not specify
a sub query or inner query in the rawfilter property.
What I mean is you can specify "ColumnName NOT LIKE '%<%>%'" as a
Dataview.RowFilter property, which will remove all the rows which have
both "<" and ">" in the value of the ColumnName column. Since < and >
are special characters used in SQL server, I am not sure above value
for the RowFilter property will work or not. If it doesn't work, try
enclosing the < and > symbols between the [ and ] brackets.
I hope this is the proper answer for your question. If you want any
clarification just reply me back.
On 5/13/05, Srinivas Jeebula <[EMAIL PROTECTED]> wrote:
> -----------------------------------------------------------
>
> New Message on dotNET User Group Hyd
>
> -----------------------------------------------------------
> From: Srinivas Jeebula
> Message 1 in Discussion
>
> Hi All, I just want to know whether it is possible to apply DataView.RowFilter property for filtering special charactered column data. For eg if i have a column data like "Srinivas<>" or "<>" or "Srinivas((".Can i apply RowFilter property to filter the above data. I have tried with enclosing all the special characters with "[]" in the LIKE clause, for eg. "ColumnName LIKE '*Srinivas[<][>]*' but i'm not successful.Please let me know whether any restrictions are there in using some special characters. Thanks, Srinivas.
>
> -----------------------------------------------------------
>
> To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings.
> http://groups.msn.com/dotNETUserGroupHyd/_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]
>
--
Thanks and Regards,
Commander
visit my blog at : http://dotnetcapsule.blogspot.com
|
|
View other groups in this category.
![Click Here]()
![]() |
To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings.
Need help? If you've forgotten your password, please go to Passport Member Services.
For other questions or feedback, go to our Contact Us page.
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.
Remove my e-mail address from dotNET User Group Hyd.
|
|
