Home
Assembly: SqlTools (in SqlTools.dll) Version: 3.6.0.0 (3.6.0.0)
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
|