Assembly : System.Data (dans system.data.dll)
SyntaxePublic Property CaseSensitive As Boolean
Dim instance As DataTable Dim value As Boolean value = instance.CaseSensitive instance.CaseSensitive = value
public bool CaseSensitive { get; set; }
public: property bool CaseSensitive { bool get (); void set (bool value); }
/** @property */ public boolean get_CaseSensitive () /** @property */ public void set_CaseSensitive (boolean value)
public function get CaseSensitive () : boolean public function set CaseSensitive (value : boolean)
Valeur de la propriété
true si la comparaison respecte la casse ; sinon, false. La valeur par défaut est celle de la propriété CaseSensitive de l'objet DataSet parent, ou false si DataTable a été créé indépendamment de DataSet.
NotesLa propriété CaseSensitive affecte les comparaisons de chaînes en ce qui concerne le tri, la recherche et le filtrage.
ExempleL'exemple suivant appelle à deux reprises la méthode Select sur DataTable. La valeur false est affectée à la propriété CaseSensitive la première fois et la valeur true la deuxième.
Private Sub ToggleCaseSensitive() Dim t As DataTable Dim foundRows() As DataRow t = CreateDataSet().Tables(0) t.CaseSensitive = False foundRows = t.Select("item = 'abc'") ' Print out DataRow values. Row 0 contains the value we're looking for. PrintRowValues(foundRows, "CaseSensitive = False") t.CaseSensitive = True foundRows = t.Select("item = 'abc'") PrintRowValues(foundRows, "CaseSensitive = True") End Sub Public Function CreateDataSet() As DataSet ' Create a DataSet with one table, two columns Dim ds As New DataSet Dim t As New DataTable("Items") ' Add table to DataSet ds.Tables.Add(t) ' Add two columns Dim c As DataColumn ' First column c = t.Columns.Add("id", Type.GetType("System.Int32")) c.AutoIncrement = True ' Second column t.Columns.Add("item", Type.GetType("System.String")) ' Set primary key t.PrimaryKey = New DataColumn() {t.Columns("id")} For i As Integer = 0 To 9 t.Rows.Add(New Object() {i, i.ToString()}) Next t.Rows.Add(New Object() {11, "abc"}) t.Rows.Add(New Object() {15, "ABC"}) CreateDataSet = ds End Function Private Sub PrintRowValues(ByRef rows As DataRow(), ByVal label As String) Console.WriteLine() Console.WriteLine(label) If rows.Length <= 0 Then Console.WriteLine("no rows found") Return End If For Each r As DataRow In rows For Each c As DataColumn In r.Table.Columns Console.Write(vbTab & " {0}", r(c)) Next Console.WriteLine() Next End Sub
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(); } }
Plates-formesWindows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile pour Pocket PC, Windows Mobile pour Smartphone, Windows Server 2003, Windows XP Édition Media Center, Windows XP Professionnel Édition x64, Windows XP SP2, Windows XP Starter Edition
Le .NET Framework ne prend pas en charge toutes les versions de chaque plate-forme. Pour obtenir la liste des versions prises en charge, consultez Configuration requise.
Informations de version
Outils (masquer)
S'enregistrer
Liste des Membres
Qui est en ligne?
FAQ