DataTable.CaseSensitive Property

Definition

Indicates whether string comparisons within the table are case-sensitive.

public bool CaseSensitive { get; set; }
[System.Data.DataSysDescription("DataTableCaseSensitiveDescr")]
public bool CaseSensitive { get; set; }

Property Value

true 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.

Attributes

Examples

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();
    }
}

Remarks

The CaseSensitive property affects string comparisons in sorting, searching, and filtering.

Applies to

Product Versions
.NET Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9
.NET Framework 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard 2.0, 2.1

See also