26.2.3.7. The MySqlHelper Class
Helper class that makes it easier to work with the provider.
Developers can use the methods of this class to automatically
perform common tasks.
The MySqlHelper class has no properties.
The following methods are available:
ExecuteDataRow
: Executes a single SQL
command and returns the first row of the resultset. A new
MySqlConnection object is created, opened, and closed
during this method.
ExecuteDataset
: Executes a single SQL
command and returns the resultset in a DataSet. A new
MySqlConnection object is created, opened, and closed
during this method.
ExecuteNonQuery
: Executes a single
command against a MySQL database. The MySqlConnection is
assumed to be open when the method is called and remains
open after the method completes.
ExecuteReader
: Overloaded. Executes a
single command against a MySQL database.
ExecuteScalar
: Execute a single command
against a MySQL database.
UpdateDataSet
: Updates the given table
with data from the given DataSet.