The RSSBus ADO.NET providers are easy-to-use, standards based controls that can be used from any platform or development technology that supports Microsoft .NET, including Sybase PowerBuilder. In this article we show how to use the RSSBus ADO.NET Provider for QuickBooks in PowerBuilder. A similar approach can be used from PowerBuilder with other RSSBus ADO.NET Data Providers to access data from Salesforce, SharePoint, Dynamics CRM, Google, OData, etc.

In this article we will show how to create a basic PowerBuilder application that performs CRUD operations using the RSSBus ADO.NET Provider for QuickBooks.

• Step 1: Open PowerBuilder and create a new WPF Window Application solution.

• Step 2: Add all the Visual Controls needed for the connection properties.
• Step 3: Add the DataGrid control from the .NET controls.

• Step 4:Configure the columns of the DataGrid control as shown below. The column bindings will depend on the table.

<DataGrid AutoGenerateColumns="False" Margin="13,249,12,14" Name="datagrid1" TabIndex="70" ItemsSource="{Binding}">
<DataGrid.Columns>
    <DataGridTextColumn x:Name="idColumn" Binding="{Binding Path=ID}" Header="ID" Width="SizeToHeader" />
    <DataGridTextColumn x:Name="nameColumn" Binding="{Binding Path=Name}" Header="Name" Width="SizeToHeader" />
		...
	</DataGrid.Columns>
</DataGrid>

• Step 5:Add a reference to the RSSBus ADO.NET Provider for QuickBooks assembly.

• Step 6:Optional: Set the QBXML Version to 6. Some of the tables in QuickBooks require a later version of QuickBooks to support updates and deletes. Please check the help for details.

Connect the DataGrid:

Once the visual elements have been configured, developers can use standard ADO.NET objects like Connection, Command, and DataAdapter to populate a DataTable with the results of a SQL query:

System.Data.RSSBus.QuickBooks.QuickBooksConnection conn 
conn = create System.Data.RSSBus.QuickBooks.QuickBooksConnection(connectionString)

System.Data.RSSBus.QuickBooks.QuickBooksCommand comm 
comm = create System.Data.RSSBus.QuickBooks.QuickBooksCommand(command, conn)

System.Data.DataTable table
table = create System.Data.DataTable

System.Data.RSSBus.QuickBooks.QuickBooksDataAdapter dataAdapter
dataAdapter = create System.Data.RSSBus.QuickBooks.QuickBooksDataAdapter(comm)
dataAdapter.Fill(table)	
datagrid1.ItemsSource=table.DefaultView

The code above can be used to bind data from any query (set this in command), to the DataGrid. The DataGrid should have the same columns as those returned from the SELECT statement.

PowerBuilder Sample Project

The included sample project includes the steps outlined in this article. You will also need the QuickBooks ADO.NET Data Provider to make the connection. You can download a free trial here.