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 =
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!