RESOLVED: URGENT please, select from datatable?

[janis]

I have one datatable DT (id, name) and I want with dataview DW to select records:
dim DW =new DataView(DT)
dw.RowFilter="name='exp's'"

I got error because in rowfiler has apostrophe ( in datatable there is names with apostrophe). How to present apostrophe in rowfilter string?

Thanks in advance.

regard j

[pax]

Hi.

Not sure, but try this : dw.RowFilter="[exp's]"

[janis]

Originally posted by pax
Hi.

Not sure, but try this : dw.RowFilter="[exp's]"

Not working.
Anybody else?

regard j

[Jaiboy]

I think either one will work

dw.RowFilter="name='exp''s'"
 
or
 
dw.RowFilter="name=""exp's"""

[janis]

Originally posted by Jaiboy
I think either one will work

dw.RowFilter="name='exp''s'"

This is a solution, just like in MSSQL Server.

regard j