Sample Code for VB.NET with QODBC

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 cnQODBC 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 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.

Please click here to download a sample VB.Net project.

Using a 64-bit system, you can specify x86 as Target CPU in Visual Studio.

Change project properties | Advanced Compile Options... | Target CPU | x86

To use it as a 64-bit, you need to use QRemote 64-bit DSN “QuickBooks Data 64-bit QRemote” in the connection string.

QODBC Edition Related

     The difference between the Desktop and the Server Edition is that for running Service based application Server Edition license is required. The service-based application is active in the Server Edition, which allows applications that call through a Windows Service (such as IIS, ColdFusion. MS SQL Server) to use QODBC and QuickBooks. So QODBC Server Edition should be chosen when using. NET.

     See also: http://www.qodbc.com/qodbcfree.htm for more about the differences between the Desktop and Server Edition.

IE Hanging Problem

     Sometimes one could get the problem when opening the QODBC connection, but the IE hangs. To resolve this, use QRemote DSN "QuickBooks Data QRemote" instead of "QuickBooks Data" DSN See: How to use QRemote for more.

Please click here for How to build a QuickBooks IIS Web application using QODBC Driver and Microsoft ASP.NET (Video)

Please click here for the Sample code for the ASP C# QODBC connection.

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