Hi there
Is there a way to use LINQ to filter a DataTable for rows that contain particular character but in a "Accent Insensitive" way?
Search over the web I came with something like this:
Code:Dim dt As DataTable = CType(BindingSource1.DataSource, DataTable) Dim SearchVAlue As String SearchVAlue = "e" Dim Result = From Src In dt.AsEnumerable() Where Src.Field(Of String)("Rue").IndexOf(SearchVAlue, StringComparison.InvariantCultureIgnoreCase) > -1 _ Select Src Dim dv As DataView dv = Result.AsDataView BindingSource1.DataSource = dvBut it is not working in the way I wish, the above method return me only those with "e" not those with "é".Code:In a table that contain this ID Rue 1 "Carré" 2 "Carre" 3 "Triangle" 4 "Bag" 5 "Laptop"
Is there a way to get LINQ return me
Many thank!Code:1 "Carré" 2 "Carre" 3 "Triangle"
in advance!





Reply With Quote
