Create database connection from the .NET SDK
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.