The WIDBUtil type exposes the following members.

Constructors

  NameDescription
Public methodWIDBUtil
Main constructor

Methods

  NameDescription
Public methodAddParameter(String, array<Byte>[]()[][])
Provides a method of adding a byte array as a parameter
Public methodAddParameter(String, array<Char>[]()[][])
Provides a method of adding a char array as a parameter
Public methodAddParameter(String, Image)
Provides a method of adding an image as a parameter
Public methodBracketName(String)
Place square brackets, single quote, etc around table and column names
Public methodStatic memberBracketName(String, eDatabaseType)
Place square brackets, single quote, etc around table and column names
Public methodClose
Closes the database connection and database reader
Public methodExecuteStatement(String)
Runs a SQL statement that does not provide a result set
Public methodExecuteStatement(String, Int32%)
Runs a SQL statement that does not provide a result set
Public methodExecuteTransaction(Collection<(Of <<'(String>)>>))
Preform a SQL Transaction on a collection of SQL statements
Public methodExecuteTransaction(String)
Preform a SQL Transaction on a SQL statement
Public methodExecuteTransaction(Collection<(Of <<'(String>)>>), Collection<(Of <<'(Int32>)>>)%)
Preform a SQL Transaction on a collection of SQL statements
Public methodExecuteTransaction(String, Int32%)
Preform a SQL Transaction on a SQL statement
Public methodGetColumnIndex
Get the Ordinal/index of a column name
Public methodOpen
Open connection to database based on databaseInfo settings
Public methodOpenServer
Connect to a server not a specific database based on databaseInfo settings
Public methodStatic memberPrepareSQLVariable
Prepare string for database insertion. Fixes quotes and other special characters.
Public methodReadBool
Reads a boolean from a record in the field specified by idx
Public methodReadBytes
Reads a byte array from a record in the field specified by idx
Public methodReadChar
Reads a Char from a record in the field specified by idx
Public methodReadDate
Reads a Date from a record in the field specified by idx
Public methodReadDecimal
Reads a Decimal value from a record in the field specified by idx
Public methodReadDouble
Reads a double from a record in the field specified by idx
Public methodReadImage
Reads an Image from a record in the field specified by idx
Public methodReadInt
Reads an integer from a record in the field specified by idx
Public methodReadLong
Reads a long from a record in the field specified by idx
Public methodReadRow()()()()
Reads a row from the Database
Public methodReadRow(Boolean)
Reads a row from the Database
Public methodReadShort
Reads a short from a record in the field specified by idx
Public methodReadStream
Reads a stream from a record in the field specified by idx
Public methodReadString
Reads a string from a record in the field specified by idx

Fields

  NameDescription
Public fieldCommandText
Low level access to database Command Text
Public fieldDBCommand
Low level access to database Command
Public fieldDBConnection
Low level access to database connection
Public fieldLastError
Error Code from last operation performed
Public fieldLastErrorMessage
Error Message from last operation performed. Normally an exception message
Public fieldReader
Low level access to database Reader

Properties

  NameDescription
Public propertyDatabaseType
Type of database working with

See Also