A small example adapted from
https://www.dotnetperls.com/dataset-vbnet[
^]
Public Class Form1
Public Sub New()
' This call is required by the designer.
InitializeComponent()
' Add any initialization after the InitializeComponent() call.
Module1.Main()
Me.DataGridView1.DataSource = set1.Tables(0)
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
set1.Tables(0).DefaultView.RowFilter = "name = 'sam'"
Me.DataGridView1.DataSource = set1.Tables(0)
End Sub
End Class
Module Module1
Public table1 As DataTable = New DataTable("patients")
Public table2 As DataTable = New DataTable("medications")
Public set1 As DataSet = New DataSet("office")
Sub Main()
' Two DataTables.
table1.Columns.Add("name")
table1.Columns.Add("id")
table1.Rows.Add("sam", 1)
table1.Rows.Add("mark", 2)
table2.Columns.Add("id")
table2.Columns.Add("medication")
table2.Rows.Add(1, "atenolol")
table2.Rows.Add(2, "amoxicillin")
' Create a DataSet. Put both tables in it.
set1.Tables.Add(table1)
set1.Tables.Add(table2)
' Visualize DataSet.
Debug.WriteLine(set1.GetXml())
End Sub
End Module