Home

The MySqlClass type exposes the following methods.

Methods

 Public

 Protected
 Instance

 Static
 Declared

 Inherited
 XNA Framework Only

 .NET Compact Framework Only

 MemberDescription
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)
Determines whether the specified Object is equal to the current 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()()()
Returns a String that represents the current Object.
(Inherited from Object.)
varIs(Int32)
puts the type and value into a string

See Also