VB.Net Tutorial/Database ADO.net/DataView

Find a value in DataView

<source lang="vbnet">Imports System.Windows.Forms Imports System.Data Imports System.Data.OleDb public class FindAValueInDataView

  public Shared Sub Main
       Application.Run(New Form1)
  End Sub

End class

Public Class Form1

   Private Sub Form1_Load(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles MyBase.Load
       Dim contacts_table As New DataTable("Contacts")
       " Add columns.
       contacts_table.Columns.Add("FirstName", GetType(String))
       contacts_table.Columns.Add("LastName", GetType(String))
       contacts_table.Columns.Add("Street", GetType(String))
       contacts_table.Columns.Add("City", GetType(String))
       contacts_table.Columns.Add("State", GetType(String))
       contacts_table.Columns.Add("Zip", GetType(String))
       contacts_table.Rows.Add(New Object() {"A", "A", _
           "1234", "B", "A", "11111"})
       contacts_table.Rows.Add(New Object() {"B", "B", _
           "22", "B", "C", "22222"})
       contacts_table.Rows.Add(New Object() {"C", "C", _
           "3", "P", "K", "33333"})
       contacts_table.Rows.Add(New Object() {"", "D", _
           "4", "P", "KS", "44444"})
       grdAll.DataSource = contacts_table
       grdAll.CaptionText = "All Records"
       
       Dim dv_name As New DataView(contacts_table)
       dv_name.RowFilter = "FirstName >= "A""
       grdName.DataSource = dv_name
       grdName.CaptionText = "LastName >= E"
       dv_name.Sort = "FirstName, LastName"
       MessageBox.Show(dv_name.Find(New String() {"A", "A"}).ToString)
   End Sub

End Class <Global.Microsoft.VisualBasic.rupilerServices.DesignerGenerated()> _ Partial Public Class Form1

   Inherits System.Windows.Forms.Form
   "Form overrides dispose to clean up the component list.
   <System.Diagnostics.DebuggerNonUserCode()> _
   Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
       If disposing AndAlso components IsNot Nothing Then
           components.Dispose()
       End If
       MyBase.Dispose(disposing)
   End Sub
   "Required by the Windows Form Designer
   Private components As System.ruponentModel.IContainer
   "NOTE: The following procedure is required by the Windows Form Designer
   "It can be modified using the Windows Form Designer.  
   "Do not modify it using the code editor.
   <System.Diagnostics.DebuggerStepThrough()> _
   Private Sub InitializeComponent()
       Me.SplitContainer1 = New System.Windows.Forms.SplitContainer
       Me.SplitContainer2 = New System.Windows.Forms.SplitContainer
       Me.grdAll = New System.Windows.Forms.DataGrid
       Me.grdCO = New System.Windows.Forms.DataGrid
       Me.grdName = New System.Windows.Forms.DataGrid
       Me.SplitContainer1.Panel1.SuspendLayout()
       Me.SplitContainer1.Panel2.SuspendLayout()
       Me.SplitContainer1.SuspendLayout()
       Me.SplitContainer2.Panel1.SuspendLayout()
       Me.SplitContainer2.Panel2.SuspendLayout()
       Me.SplitContainer2.SuspendLayout()
       CType(Me.grdAll, System.ruponentModel.ISupportInitialize).BeginInit()
       CType(Me.grdCO, System.ruponentModel.ISupportInitialize).BeginInit()
       CType(Me.grdName, System.ruponentModel.ISupportInitialize).BeginInit()
       Me.SuspendLayout()
       "
       "SplitContainer1
       "
       Me.SplitContainer1.Dock = System.Windows.Forms.DockStyle.Fill
       Me.SplitContainer1.Location = New System.Drawing.Point(0, 0)
       Me.SplitContainer1.Name = "SplitContainer1"
       Me.SplitContainer1.Orientation = System.Windows.Forms.Orientation.Horizontal
       "
       "SplitContainer1.Panel1
       "
       Me.SplitContainer1.Panel1.Controls.Add(Me.grdAll)
       "
       "SplitContainer1.Panel2
       "
       Me.SplitContainer1.Panel2.Controls.Add(Me.SplitContainer2)
       Me.SplitContainer1.Size = New System.Drawing.Size(519, 485)
       Me.SplitContainer1.SplitterDistance = 180
       Me.SplitContainer1.TabIndex = 2
       Me.SplitContainer1.Text = "SplitContainer1"
       "
       "SplitContainer2
       "
       Me.SplitContainer2.Dock = System.Windows.Forms.DockStyle.Fill
       Me.SplitContainer2.Location = New System.Drawing.Point(0, 0)
       Me.SplitContainer2.Name = "SplitContainer2"
       Me.SplitContainer2.Orientation = System.Windows.Forms.Orientation.Horizontal
       "
       "SplitContainer2.Panel1
       "
       Me.SplitContainer2.Panel1.Controls.Add(Me.grdCO)
       "
       "SplitContainer2.Panel2
       "
       Me.SplitContainer2.Panel2.Controls.Add(Me.grdName)
       Me.SplitContainer2.Size = New System.Drawing.Size(519, 301)
       Me.SplitContainer2.SplitterDistance = 173
       Me.SplitContainer2.TabIndex = 0
       Me.SplitContainer2.Text = "SplitContainer2"
       "
       "grdAll
       "
       Me.grdAll.DataMember = ""
       Me.grdAll.Dock = System.Windows.Forms.DockStyle.Fill
       Me.grdAll.HeaderForeColor = System.Drawing.SystemColors.ControlText
       Me.grdAll.Location = New System.Drawing.Point(0, 0)
       Me.grdAll.Name = "grdAll"
       Me.grdAll.Size = New System.Drawing.Size(519, 180)
       Me.grdAll.TabIndex = 0
       "
       "grdCO
       "
       Me.grdCO.DataMember = ""
       Me.grdCO.Dock = System.Windows.Forms.DockStyle.Fill
       Me.grdCO.HeaderForeColor = System.Drawing.SystemColors.ControlText
       Me.grdCO.Location = New System.Drawing.Point(0, 0)
       Me.grdCO.Name = "grdCO"
       Me.grdCO.Size = New System.Drawing.Size(519, 173)
       Me.grdCO.TabIndex = 1
       "
       "grdName
       "
       Me.grdName.DataMember = ""
       Me.grdName.Dock = System.Windows.Forms.DockStyle.Fill
       Me.grdName.HeaderForeColor = System.Drawing.SystemColors.ControlText
       Me.grdName.Location = New System.Drawing.Point(0, 0)
       Me.grdName.Name = "grdName"
       Me.grdName.Size = New System.Drawing.Size(519, 124)
       Me.grdName.TabIndex = 1
       "
       "Form1
       "
       Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
       Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
       Me.ClientSize = New System.Drawing.Size(519, 485)
       Me.Controls.Add(Me.SplitContainer1)
       Me.Name = "Form1"
       Me.Text = "Contacts"
       Me.SplitContainer1.Panel1.ResumeLayout(False)
       Me.SplitContainer1.Panel2.ResumeLayout(False)
       Me.SplitContainer1.ResumeLayout(False)
       Me.SplitContainer2.Panel1.ResumeLayout(False)
       Me.SplitContainer2.Panel2.ResumeLayout(False)
       Me.SplitContainer2.ResumeLayout(False)
       CType(Me.grdAll, System.ruponentModel.ISupportInitialize).EndInit()
       CType(Me.grdCO, System.ruponentModel.ISupportInitialize).EndInit()
       CType(Me.grdName, System.ruponentModel.ISupportInitialize).EndInit()
       Me.ResumeLayout(False)
   End Sub
   Friend WithEvents SplitContainer1 As System.Windows.Forms.SplitContainer
   Friend WithEvents grdAll As System.Windows.Forms.DataGrid
   Friend WithEvents SplitContainer2 As System.Windows.Forms.SplitContainer
   Friend WithEvents grdCO As System.Windows.Forms.DataGrid
   Friend WithEvents grdName As System.Windows.Forms.DataGrid

End Class</source>