DataSourceOdbc is a specialized DataSource for importing data from an ODBC database. This class is used to manipulate existing DataSourceOdbc objects.
To create a new DataSource use TFORMer Designer or Project.AddDataSource.

The main properties to characterize a DataSourceOdbc are:

  • The DSN
    The DSN represents the name of the database connection as defined in the Microsoft Windows Control Panel. Please keep in mind that the DSN is a part of the connection string and thus a complete specification is required.
  • The user name
    It depends on the database connection if the user-name is required or not.
  • The password
    It depends on the database connection if the password is required or not.
  • The SQL SELECT statement
    The column names returned by the SQL SELECT statement should match the names of the DataFields in the FormLayout. Use SQL aliases if required.

Modifying an Existing ODBC DataSource

Sample source code for modifying an existing ODBC-DataSource:

// Retrieve the global Project
// DataSources are defined in a Project or a global Project
Project project = repository.GlobalProject;
// Retrieve the DataSource by name
// Since we know the type of the DataSource, we can cast it to DataSourceOdbc
DataSourceOdbc dataSource = (DataSourceOdbc) (project.GetDataSource("ODBC"));
// Modify some DataSource properties
dataSource.User = "";
dataSource.Password = "";

© 2006-2023 - all rights reserved by TEC-IT Datenverarbeitung GmbH
Generated on Thu Dec 28 2023 18:45:19 for TFORMer SDK - NET with doxygen 1.9.4