Is ToTable distinct casesensitive? It appears so. Is there a way to make it caseinsensitive?

Jak
Jak
Member
858 Points
132 Posts

Hi,

Is ToTable distinct casesensitive? It appears so. Is there a way to make it caseinsensitive?

Views: 10401
Total Answered: 1
Total Marked As Answer: 1
Posted On: 02-Feb-2015 22:17

Share:   fb twitter linkedin
Answers
NiceOne Team
NiceOne...
Editor
1382 Points
14 Posts
         

Hi, Rahul

Yes, the parent dataset can be case sensitive.You can set insensitive to that dataset.

DataTable
tempDataTable = new DataTable();
tempDataTable.CaseSensitive =
false;
 
DataTable tempDataTableDistinct = new DataTable();
 
DataView tempDataView = new DataView(tempDataTable);
tempDataTableDistinct = tempDataView.ToTable(
true, "ColumnName");
 
 
Posted On: 03-Feb-2015 10:01
 Log In to Chat