DataTable.CaseSensitive Property
.NET Framework (current version)
Indicates whether string comparisons within the table are case-sensitive.
Assembly: System.Data (in System.Data.dll)
Property Value
Type: System.Booleantrue if the comparison is case-sensitive; otherwise false. The default is set to the parent DataSet object's CaseSensitive property, or false if the DataTable was created independently of a DataSet.
The CaseSensitive property affects string comparisons in sorting, searching, and filtering.
The following example calls the Select method twice on a DataTable. The first time, the CaseSensitive property is set to false, the second, to true.
private static void ToggleCaseSensitive() { DataTable t; DataRow[] foundRows; t = CreateDataSet().Tables[0]; t.CaseSensitive = false; foundRows = t.Select("item = 'abc'"); // Print out DataRow values. PrintRowValues(foundRows, "CaseSensitive = False"); t.CaseSensitive = true; foundRows = t.Select("item = 'abc'"); PrintRowValues(foundRows, "CaseSensitive = True"); } public static DataSet CreateDataSet() { // Create a DataSet with one table, two columns DataSet ds = new DataSet(); DataTable t = new DataTable("Items"); // Add table to dataset ds.Tables.Add(t); // Add two columns DataColumn c; // First column c = t.Columns.Add("id", typeof(int)); c.AutoIncrement = true; // Second column t.Columns.Add("item", typeof(string)); // Set primary key t.PrimaryKey = new DataColumn[] { t.Columns["id"] }; // Add twelve rows for (int i = 0; i < 10; i++) { t.Rows.Add(new object[] { i, i.ToString() }); } t.Rows.Add(new object[] { 11, "abc" }); t.Rows.Add(new object[] { 15, "ABC" }); return ds; } private static void PrintRowValues(DataRow[] rows, string label) { Console.WriteLine(); Console.WriteLine(label); if (rows.Length <= 0) { Console.WriteLine("no rows found"); return; } foreach (DataRow r in rows) { foreach (DataColumn c in r.Table.Columns) { Console.Write("\t {0}", r[c]); } Console.WriteLine(); } }
.NET Framework
Available since 1.1
Available since 1.1
Show: