The WIDBUtil type exposes the following members.
Constructors
Name | Description | |
---|---|---|
![]() | WIDBUtil |
Main constructor
|
Methods
Name | Description | |
---|---|---|
![]() | AddParameter(String, array<Byte>[]()[][]) |
Provides a method of adding a byte array as a parameter
|
![]() | AddParameter(String, array<Char>[]()[][]) |
Provides a method of adding a char array as a parameter
|
![]() | AddParameter(String, Image) |
Provides a method of adding an image as a parameter
|
![]() | BracketName(String) |
Place square brackets, single quote, etc around table and column names
|
![]() ![]() | BracketName(String, eDatabaseType) |
Place square brackets, single quote, etc around table and column names
|
![]() | Close |
Closes the database connection and database reader
|
![]() | ExecuteStatement(String) |
Runs a SQL statement that does not provide a result set
|
![]() | ExecuteStatement(String, Int32%) |
Runs a SQL statement that does not provide a result set
|
![]() | ExecuteTransaction(Collection<(Of <<'(String>)>>)) |
Preform a SQL Transaction on a collection of SQL statements
|
![]() | ExecuteTransaction(String) |
Preform a SQL Transaction on a SQL statement
|
![]() | ExecuteTransaction(Collection<(Of <<'(String>)>>), Collection<(Of <<'(Int32>)>>)%) |
Preform a SQL Transaction on a collection of SQL statements
|
![]() | ExecuteTransaction(String, Int32%) |
Preform a SQL Transaction on a SQL statement
|
![]() | GetColumnIndex |
Get the Ordinal/index of a column name
|
![]() | Open |
Open connection to database based on databaseInfo settings
|
![]() | OpenServer |
Connect to a server not a specific database based on databaseInfo settings
|
![]() ![]() | PrepareSQLVariable |
Prepare string for database insertion. Fixes quotes and other special characters.
|
![]() | ReadBool |
Reads a boolean from a record in the field specified by idx
|
![]() | ReadBytes |
Reads a byte array from a record in the field specified by idx
|
![]() | ReadChar |
Reads a Char from a record in the field specified by idx
|
![]() | ReadDate |
Reads a Date from a record in the field specified by idx
|
![]() | ReadDecimal |
Reads a Decimal value from a record in the field specified by idx
|
![]() | ReadDouble |
Reads a double from a record in the field specified by idx
|
![]() | ReadImage |
Reads an Image from a record in the field specified by idx
|
![]() | ReadInt |
Reads an integer from a record in the field specified by idx
|
![]() | ReadLong |
Reads a long from a record in the field specified by idx
|
![]() | ReadRow()()()() |
Reads a row from the Database
|
![]() | ReadRow(Boolean) |
Reads a row from the Database
|
![]() | ReadShort |
Reads a short from a record in the field specified by idx
|
![]() | ReadStream |
Reads a stream from a record in the field specified by idx
|
![]() | ReadString |
Reads a string from a record in the field specified by idx
|
Fields
Name | Description | |
---|---|---|
![]() | CommandText | Low level access to database Command Text |
![]() | DBCommand | Low level access to database Command |
![]() | DBConnection | Low level access to database connection |
![]() | LastError | Error Code from last operation performed |
![]() | LastErrorMessage | Error Message from last operation performed. Normally an exception message |
![]() | Reader | Low level access to database Reader |
Properties
Name | Description | |
---|---|---|
![]() | DatabaseType | Type of database working with |