PDA

View Full Version : [important]rowfilter in visual studio.net V1.1


ahooi
07-12-2005, 1:05 AM
Hi,
can anyone please try to filter the following data using rowfilter and see whether it works or not.
Note: Have to escape [ and ].So, [ is written as [[] and ] is written as []]. All the data is stored as NVARCHAR not VARCHAR.

i'm using visual basic.net V1.1.

When the data are stored as unicode, the rowfilter works properly. However, when tehd ata are stored
as NVARCHAR, the rowfilter is not working properly. Is is it because the data are stored as
NVARCHAR that makes rowfilter doesn't works properly?

Three records in the database are:
1# [1222 -2201 ภาษาไทยเพื่อการสื่อสาร]
3# [1212 - 2200 วิทยาศาสตร์พื้นฐาน ]
12# [1122 - 3201 วิถีธรรมวิถีไทย ]

Let say i want to get the third record with one of the string below, i can get the desired data.
'%12%'
'%12#%'
'%[[]%'
'%[]]%'
'%[[]1122%'
'%[[]1122 - 3201 วิถีธรรมวิถีไทย []]%'
'%#%'
'%-%'
'%วิถีธรรมว%'


However, i can't get the third record if i use one of thestring below.
'%# %' (a space after #)
'%# [[]%'
'%12# [[]%'
'%12# %' (a space after #)
'%# [[]1122%'
'%12# [[]1122 - 3201 วิถีธรรมวิถีไทย []]%'


Can you help me?:(

Please reply to my gmail account heng81@gmail.com.
Thanks