client Constructor

Create new client.

[Visual Basic]
Public Sub New( _
   ByVal String As String, _
   ByVal Type As Type, _
   ByVal Type As Type, _
   ByVal Type As Type, _
   ByVal Type As Type _
)

[C#]
public client(
   String connectionString,
   Type connectionType,
   Type commandType,
   Type dataAdapterType,
   Type commandBuilderType
);

Parameters

connectionString: Connection string. See connectionString property for details.
connectionType: Connection by type.
commandType: Command by type.
dataAdapterType: DataAdapter by type.
commandBuilderType: CommandBuilder by type

Remarks

Component recognize five major types of native or odbc dataproviders: MS SQL Server, MA Access, MySQL, Oracle and DB2. In the case of use some other database manualy set sqlDialect object. Use of any database native or odbc provider (except for SQL Server) require project reference to assembly. For example: Data.Odbc provider (can be downloded from: http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=data%20.net%20odbc%20provider%20&DisplayLang=en) copy to your bin folder and then right click to "reference" in solution explorer and choose "Add reference". Browse to downloaded dll and select it.

Example

Examples for different providers:

MS SQL native client: 
client = New Indoo.Data.Client(connectionString, GetType(SqlClient.SqlConnection), GetType(SqlCommand), GetType(SqlDataAdapter), GetType(SqlCommandBuilder))

ODBC client: 
client = New Indoo.Data.Client(connectionString, GetType(OdbcConnection), GetType(OdbcCommand), GetType(OdbcDataAdapter), GetType(OdbcCommandBuilder))

MySQL native client: 
client = New Indoo.Data.Client(connectionString, GetType(MySql.Data.MySqlClient.MySqlConnection), GetType(MySql.Data.MySqlClient.MySqlCommand), GetType(MySql.Data.MySqlClient.MySqlDataAdapter), GetType(MySql.Data.MySqlClient.MySqlCommandBuilder))

Oracle client for asp 1.1 (downloaded from oracle.com): 
client = New Indoo.Data.Client(connectionString, GetType(Oracle.DataAccess.Client.OracleConnection), GetType(Oracle.DataAccess.Client.OracleCommand), GetType(Oracle.DataAccess.Client.OracleDataAdapter), GetType(Oracle.DataAccess.Client.OracleCommandBuilder))

Oracle client for asp 2.0 (built-in oracle client): 
client = New Indoo.Data.Client(connectionString, GetType(System.Data.OracleClient.OracleConnection), GetType(System.Data.OracleClient.OracleCommand), GetType(System.Data.OracleClient.OracleDataAdapter), GetType(System.Data.OracleClient.OracleCommandBuilder))

etc.

or use some of available shortcuts: to get client with System.Data.SqlClient provider use of getMsSql function, for client with Data.Odbc use getOdbc function

client Constructor

Parameters

Remarks

Example

See Also