I have a textbox use to filter a Gridview.
The sql collation is set to French_CI_AI.
The search result when I write a select query in SQL server management studio works fine, it return all the records with accent or not. But the result using a sqldatasource with ASP.NET 2.0 is case sensitive.
I absolutly need to have a case insensitive search.
Any experts here who know the solution. It must be very simple, I just don't know where to look for.
Protected Sub txtFilter_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtFilter.TextChanged
FilterHiddenField.Value = "%" & txtFilter.Text & "%"
bFilterChanged = True
Session("bSelectionChanged") = True
RaiseEvent SelectionChanged(Me, e)
Session("CustID") = Nothing
gvDisplayNames.SelectedIndex = -1