Home
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
|