The MySqlClass type exposes the following methods.
Methods
 Public Protected | Instance Static | Declared Inherited | XNA Framework Only .NET Compact Framework Only |
| Member | Description | |
|---|---|---|
 | 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
|
| disconn()()() |
disconnects if connected
|
| Equals(Object) | (Inherited from Object.) |
 | 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
|
 | 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.) |
| 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
|
| 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
|
| ToString()()() | (Inherited from Object.) |
| varIs(Int32) |
puts the type and value into a string
|
See Also
