Filtering Dataview [Strange Problem]

[anup_daware]

Abstract: I want to filter a dataview with a value where column name have a SPACE.

Description:-

I bind a dataview to a datagrid,

The query which is fetching the results in Dataset is something like this:-

Select POSTAL_ADDRESS as "Postal Address" from Emp where ....

Now the column name in Dataview is "Postal Address" which is having a space, with this column name when I am filtering the Dataview like:-

DataViewAddress.RowFilter = "Postal Address LIKE '*Bel1*'"

which throws following exception:-

System.Data.SyntaxErrorException: Syntax error: Missing operand after 'Address' operator.

I tried

DataViewAddress.RowFilter = "\"Postal Address\" LIKE '*Bel1*'"

I also tried the EncodedColumnName which replaces spaces with _x0020_

like:

DataViewAddress.RowFilter = "Postal_x0020_ Address LIKE '*Bel1*'" but nothing worked and got the same exception every time..

 

I searched the net but I didnt get anything on it...

Any help will be Very-Much Helpful..

Thanks and Regards,

Anup Daware

[Nerseus]

Try square brackets:

[vb

DataViewAddress.RowFilter = "[Postal Address] LIKE '*Bel1*'"

[/code]

 

-ner