Sample Code for VB.NET with QODBC Online

Sample Code of VB.NET to Create DataSet

Note: The following is the minimal code required to create a DataSet from the SQL statement and attach the dataset to a DataGrid.

Dim CNBC As System.Data.Odbc.OdbcConnection
Dim daQODBC As System.Data.Odbc.OdbcDataAdapter
Dim dsQODBC As System.Data.DataSet

cnQODBC = New System.Data.Odbc.OdbcConnection("DSN=QuickBooks Online Data")
cnQODBC.Open()
daQODBC = New System.Data.Odbc.OdbcDataAdapter("SELECT ListID, FullName, CompanyName FROM Customer", cnQODBC)
dsQODBC = New System.Data.DataSet

daQODBC.Fill(dsQODBC)
dgDataGrid.DataSource = dsQODBC
dgDataGrid.DataBind() 'May or may not be required depending on where you put this code.

Keywords: sample .net, sample, .net, Dot Net, VB.Net

Tags: QuickBooks Online, QBO, VB.NET, Sample VB.NET code