RESOLVED: URGENT please, select from datatable?

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

Hi.

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

Quote:

---

Originally posted by pax
Hi.

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

---

Not working.
Anybody else?

regard j

I think either one will work

VB Code:

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

Quote:

---

Originally posted by Jaiboy
I think either one will work

VB Code:

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

---

This is a solution, just like in MSSQL Server.

regard j