本文整理匯總了VB.NET中System.Data.DataTable.CaseSensitive屬性的典型用法代碼示例。如果您正苦於以下問題:VB.NET DataTable.CaseSensitive屬性的具體用法?VB.NET DataTable.CaseSensitive怎麽用?VB.NET DataTable.CaseSensitive使用的例子?那麽, 這裏精選的屬性代碼示例或許可以為您提供幫助。您也可以進一步了解該屬性所在類System.Data.DataTable
的用法示例。
在下文中一共展示了DataTable.CaseSensitive屬性的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的VB.NET代碼示例。
示例1: ToggleCaseSensitive
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