How to format a rowfilter which includes quote characters...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DK - 16 May 2005 17:29 GMT

How canI format the text in a rowfilter expression for a DataView object
which contains a quote mark...is there a special escape character? or what?

For example, "Album = 'One's too many'"

Thanks

Reply to this Message

Elton W - 16 May 2005 18:30 GMT

Hi DK,

You can use double quotes to escape single quote.

Dataview.RowFilter = "Album = 'One''s too many'”

HTH

Elton Wang
elton_wang@hotmail.com

> How canI format the text in a rowfilter expression for a DataView object
> which contains a quote mark...is there a special escape character? or what?
>
> For example, "Album = 'One's too many'"
>
> Thanks

Reply to this Message

Cor Ligthert - 16 May 2005 19:15 GMT

What is in VBNet two quotes.

> You can use double quotes to escape single quote.
>
> Dataview.RowFilter = "Album = 'One''s too many'"

What is in VBNet two double quotes in the code.

Reply to this Message

Elton W - 17 May 2005 00:07 GMT

Hi Cor,

I don't understand your question.

If you mean following:

Dim str As String = "It's 2"" width."

The str is It's 2" width.

Elton

>-----Original Message-----
>What is in VBNet two quotes.
[quoted text clipped - 6 lines]
>
>.

Reply to this Message

Cor Ligthert - 17 May 2005 06:57 GMT

Elton,

Just wrong English.

A single quote has to be written in VBNet as 2 double quotes.

Thanks for pointing me on that.

Cor

Reply to this Message

How to format a rowfilter which includes quote characters...

Free Magazines