If
.NET 3.5
or above is used then I think
LINQ
can be a better alternative as
Culture aware
comparison can be made with
LINQ
to get the desired rows from the
DataTable
.
If
.NET 2.0
is to be used then
DataTable.Select
method is to be used and the
DataTable.Select
method is not culture aware as reported here
DataTable.Select() method is not culture-aware[
^]
A work around for this issue is given here
Problem on DataTable's string comparison [
^]
Please see. It may be helpful.