DataView.Rowfilter String Problem

[Paul Meller]

Hi,

I am having a bit of trouble with a string used to filter a dataview in
ASP.NET.

Although the code I have works perfectly in almost all instances, there is a
problem when using a string in the rowfilter that include 2 consecutive
spaces. For example a Unique code, "T8H EZ(.^ " - where there are 2 spaces
after the H.

The reason I need this to work is that the database uses a primary key that
is a randomly generated code, which may (and has) involved two consectutive
spaces.

The code is:

SearchString = "UNIQUE_ID <> '"& myReader.GetString(1)
TaskView.Rowfilter = SearchString

Thanks
Paul