MsSQLDriver

Home » Documentation » MsSQLDriver

MsSQLDriver

The MsSQLDriver allows for easy interaction with Microsoft SQL Servers.

Constructors

Name	Description
Constructor	Initializes a new instance of the MsSQLDriver class and optionally populates the connection string with the specified argument. Arguments: (void) (ConnectionString)

Destructors

Name	Description
Destructor	Closes all open connections on destruction of the object.

Methods

Name	Description
Close	Terminates the connection to the host.
Escape	Escapes special characters in the specified string for use in SQL statements. Arguments: (Value)
ExecuteNonQuery	Executes SQL statements that do not return data.
GetDataRow	Returns a data row containing data queried from the host.
GetDataSet	Returns a data set containing data queried from the host.
GetDataString	Returns data queried from the host. Arguments: (void) (RowSeperatedBy) (RowSeperatedBy, FieldsSeperatedBy) (RowSeperatedBy, FieldsSeperatedBy, FieldsEnclosedBy, ReturnHeaders) (RowSeperatedBy, FieldsSeperatedBy, FieldsEnclosedBy)
GetDataTable	Returns a data table containing data queried from the host.
GetFoundRows	Returns the number of found rows from the last query executed.
GetLastInsertID	Returns the last inserted auto increment column number.
Open	Opens a connection to the host.
SQLKey	Replaces a specified string with another within the SQLCommand property. Arguments: (Key, Value)

Properties

Name	Description
ConnectionString	Gets and sets the connection string used to connect to the host.
MyConnection	Stores the object used to interact with the host.
SQLCommand	Gets and sets the SQL statements used in this instance.

Notes

Please note This is object is only available in C# and Visual Basic.

Are you a robot?

Your Email:
Create a Username:
Create a Password:	Forgot Password?
Validate Text: