DataView/DataTable Filtering and Case Sensitivity

See more:

C#

DataTable

Dataview

Hi. I have a DataSet which I convert to DataView in order to do filtering, distinct and sorting, however lowercase and uppercase (though same value) is not being distinct.

Here is sample value that does not make DISTINCT

AdjustmentCode | Adjustment
FLEXI-HOUSING | flexi- housing
Flexi-housing | flexi- housing
R-TRAVEL ALLOW | travel allowance
R-Travel Allow | travel allowance


Here is my code

DataSet ds = new DatSet();
DataSet = dsFiltered = new DataSet();
DataTable dT = new DataTable();
ds = //put value from function
dT=ds.Tables[0];
dT.CaseSensitive=false;
DataView dView = dT.DefaultView;

dView.Sort = "Adjustment";
dT = dView.ToTable(true,"AdjustmentCode","Adjustment");
dsFiltered.Tables.Add(dT);

grid.DataSource = dsFiltered;
grid.DataBind();

I would really appreciate someone who could help me!

Thanks!