Archive

Posts Tagged ‘DataTable’

DataTable.DefaultView Property – Gets a customized View of the Table that may include a Filtered View, or a Cursor position.

Gets a customized view of the table that may include a filtered view, or a cursor position.
The DefaultView property returns a DataView you can use to sort, filter, and search a DataTable.

The following example sets a property of the DataTable object’s DataView through the DefaultView property. The example also shows the binding of a DataGridView control to a DataTable named “Suppliers” that includes a column named “CompanyName.”

Private Sub BindDataGrid()
   Dim table As New DataTable

   ' Insert code to populate a DataTable with data.

   ' Bind DataGrid to DataTable
   DataGrid1.DataSource = table
End Sub 

Private Sub ChangeRowFilter()
   Dim gridTable As DataTable = _
       CType(dataGrid1.DataSource, DataTable)

   ' Set the RowFilter to display a company names 
   ' that begin with A through I.
   gridTable.DefaultView.RowFilter = "CompanyName < 'I'"
End Sub



Advertisements
Categories: Database, VB.NET Tags: ,

Creating DataTable in Memory

October 16, 2010 Leave a comment

Dim dtDataTable As DataTable = Nothing
Dim dtRow As DataRow

dtDataTable.Columns.Add("LastName", GetType(String))
dtDataTable.Columns.Add("FirstName", GetType(String))
dtDataTable.Columns.Add("Age", GetType(Integer))

dtRow= dtDataTable.NewRow()
dtRow.Item("LastName") = "Smith"
dtRow.Item("FirstName") = "John"
dtRow.Item("Age") = 25
dtDataTable.Rows.Add(dtRow)

Categories: Database Tags: