DataTable.CaseSensitive Property
.NET Framework 4.5
Indicates whether string comparisons within the table are case-sensitive.
Namespace: System.Data
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 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(); } }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
