Setting the RowFilter of DataView to perform Case Insensitve filter

K

K Balusu

Hi,
Is there anyway to filter a dataview in a case-insensitive way. The
DataView's RowFilter doesn't support the "LOWER" function. Is there a
way with out setting the DataSet.CaseSensitive property.

TIA,
K Balusu
 
G

Guest

The default is case insensitive. So u do not have to do anything.

The. foll. is given in the MSDN help and RowFilter works that way only.

"Whether string comparisons are case-sensitive or not is determined by the value of the DataSet class's CaseSensitive property. However, you can override that value with the DataTable class's CaseSensitive property."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing DataView to sort/filter without calling Control.DataBind? 2
DataView Filter Problem 2
Limit rows in a DataView to those used in a relation with RowFilter? 0
"There is no Original data to access." ?? 1
DataView Constructor RowFilter Doesn't Work? 1
DataView RowFilter does not work with mulitple conditions 2
DataView RowFilter and Sort properties 7
Manually adding to DataView / Custom RowFilter 6

Top