I have a BarTender document that pulls data from an SQL Server database.

This is what I am doing now: I use the BarTender interface to create a connection to the database. I save the document with this connection established. From my .NET app, I change the DatabaseConnection.SQLStatement property to filter for the records I need to print. Tested and working.

But sometimes I need to not only change the SQLStatement but change the dataabse being used by the document. How do I create a database connection for a document through the SDK at run time? I do not want to use the BarTender interface to create database connections.