requires that mysql-connector-net-5.0.8.1 is installed and will not function otherwise...
please download that from www.seriussoft.com or redownload the latest version of SqlTools (all necessary files come with it)
Namespace:
SqlToolsAssembly: SqlTools (in SqlTools.dll) Version: 3.6.0.0 (3.6.0.0)
Syntax
| C# | Visual Basic | Visual C++ |
public class MySqlClass
Public Class MySqlClass
public ref class MySqlClass
Members
| All Members | Constructors  | Fields  | Properties  | Methods |
 Public Protected | Instance Static  | Declared Inherited | XNA Framework Only  .NET Compact Framework Only  |
| Member | Description | |
|---|---|---|
| MySqlClass()()() |
Empty constructor. Sets current conns to 0. instantiates list<string> errors
|
| MySqlClass(String) |
overloaded class initiator...for connecting at same step as initiation of class.
1 parameter(string).
exa. new MySqlClass("SERVER=%server%;UID=%userId%;PASSWORD=%pass%DATABASE=%db%;");
|
| MySqlClass(String, String, String) |
overloaded class initiator for initialzing connection
and class in one go. parameters(strings) server,userId,pass
|
| MySqlClass(String, Int32, String, String) |
overloaded class initiator for initialzing connection
and class in one go. parameters(strings) server,port,userId,pass
|
| MySqlClass(String, String, String, String) |
overloaded class initiator for initialzing connection
and class in one go. parameters(strings) server,userId,pass,db
|
| MySqlClass(String, Int32, String, String, String) |
overloaded class initiator for initialzing connection
and class in one go. parameters(strings) server,port,userId,pass,db
|
| changeDB(String) |
change the db to the supplied dbName
|
| command(String) |
execute a command (like update, insert, or delete). use getRows() to find number of rows effected
|
| conn |
the connection
|
| dataTable |
the table representation of the result set as SqlDataClass's
|
| disconn()()() |
disconnects if connected
|
| Equals(Object) | (Inherited from Object.) |
| errors | |
 | Finalize()()() |
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.) |
| free()()() |
call this everytime you plan to use a new query but don't wish to close the connection
|
| getColumns()()() |
gets number of columns at current rowSet
|
| getConn()()() |
gets the connection string
|
| GetHashCode()()() |
Serves as a hash function for a particular type.
(Inherited from Object.) |
| getRows()()() |
gets the number of rows in the resultSet
|
| GetType()()() |
Gets the Type of the current instance.
(Inherited from Object.) |
| getVar(Int32) |
returns value @ column(x) of current row or resultSet
|
| getVar(String) |
gets value at supplied column key of current row or resultSet and returns it
as a SqlDataClass
|
| getVar(Int32, Object%) |
gets value @ column(x) of current row or resultSet and stores it to
the referenced object
|
| getVar(String, Object%) |
gets variable at supplied column key, at the current row and stores it to
the referenced object
|
| isConnected()()() |
returns true/false if connected
|
| isOpen()()() |
returns whether or not the connection is open on the current MySqlClass
|
| lastInsertID |
int repesentation of the last Insert ID, will return -1 if you have not inserted anything yet
|
| makeCopyOf(MySqlClass) |
overloaded class initiator...for copying connection
to a new class so that more than one query can be
made with same connection
|
| MemberwiseClone()()() |
Creates a shallow copy of the current Object.
(Inherited from Object.) |
| mode |
gets or sets the mode of MySqlClass... fastest will not have an SqlDataArrayTable or SqlArrayTable, nor have a row count
wherease medium will have a rowcount and an SqlDataArrayTable, but no SqlArrayTable, taking a very small hit in speed
and full, which is default, will house all three of the above, but will take a small hit in speed.
|
 | mySqlConn | |
| mySqlQuery | |
| mySqlReader | |
| next()()() |
sets reader to next resultSet, returning true/false on success
|
| numErrors()()() |
gets the number of errors in list
|
| numQueries()()() |
gets the number of queries in list
|
| parseType(String) |
returns dType.(string/bool/int/double) of value
|
| pingData |
gets an array of strings. {ipAddress,port}
|
| queries | |
| query(String) |
issues a query. returns true/false for success of call
|
| reConn(MySqlClass%) |
reConnect the MySqlClass, returning true/false on success
|
| setConn(String) |
connects to db with supplied connection string in format
"SERVER=%server%;UID=%userId%;PASSWORD=%pass%;DATABASE=%dbName%;"
|
| setConn(String, String, String) |
connects to db with supplied parameters(strings) server,userId,pass
|
| setConn(String, Int32, String, String) |
connects to db with supplied parameters(strings) server,(int)port,userId,pass
|
| setConn(String, String, String, String) |
connects to db with supplied parameters(strings) server,userId,pass,dbName
|
| setConn(String, Int32, String, String, String) |
connects to db with supplied parameters(strings) server,(int)port,userId,pass,dbName
|
| setRow(Int32) |
setRow to desired row number if possible, returns false if impossible
|
| table |
the table representation of the result set as strings
|
| ToString()()() | (Inherited from Object.) |
| varIs(Int32) |
puts the type and value into a string
|
Inheritance Hierarchy
See Also
