Open topic with navigation

Database.UserId Property

ClosedDescription

Sets and returns the database user identification.

ClosedSyntax

Database.UserId = ID

Where ID is the user name that is required for access to the database.

ClosedRequirements

Version

BarTender 2016 or higher

Edition

Automation, Enterprise

ClosedRemarks

The Database.UserId property can be used with database types that support password protection, including SQL Server, Oracle, Informix, DB2, ODBC, and OLE DB. If a user ID does not exist, then an empty string will be returned.

ClosedVB.NET Example

'Declare a BarTender application variable

Dim btApp As BarTender.Application

'Declare a BarTender document variable

Dim btFormat As New BarTender.Format

'Declare BarTender database variable

Dim btDb As BarTender.Database

'Create a new instance of BarTender

btApp = New BarTender.Application

'Set the BarTender application visible

btApp.Visible = True

'Open a BarTender document

btFormat = btApp.Formats.Open("c:\Format1.btw", False, "")

'Select the database

btDb = btFormat.Databases.GetDatabase(1)

'Set the user ID

btDb.UserId = "Administrator"

'Set the password

btDb.Password = "12345";

'End the BarTender process

btApp.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges)

ClosedC# Example

// Declare a BarTender application variable

BarTender.Application btApp;

// Declare a BarTender document variable

BarTender.Format btFormat;

// Declare a BarTender database variable

BarTender.Database btDb;

// Create a new instance of BarTender

btApp = new BarTender.Application();

// Set the BarTender application visible

btApp.Visible = true;

// Open a BarTender document

btFormat = btApp.Formats.Open("c:\\Format1.btw", false, "");

// Select the database

btDb = btFormat.Databases.GetDatabase(1);

// Set the user ID

btDb.UserId = "Administrator";

// Set the password

btDb.Password = "12345";

// End the BarTender process

btApp.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges);

Related Topics