MySqlCommand Class

Represents a SQL statement or stored procedure to execute against a MySQL database.

For a list of all members of this type, see MySqlCommand members.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DbCommand
            Devart.Common.DbCommandBase
               Devart.Data.MySql.MySqlCommand

Syntax

[Visual Basic]
Public Class MySqlCommand 
   Inherits DbCommandBase
   Implements IComponent, IDbCommand, ICloneable, IDisposable

[C#]
public class MySqlCommand : DbCommandBase, IComponent, IDbCommand, ICloneable, IDisposable

Remarks

The MySqlCommand class provides the following methods for executing commands against the MySQL database:
Item Description
ExecuteReader Executes commands that return rows.
ExecutePageReader Returns a specific subset of rows when paging through the results of a query.
ExecuteNonQuery Executes SQL commands such as INSERT, DELETE, UPDATE.
ExecuteScalar Retrieves a single value (for example, an aggregate value) from a database.

Item	Description
ExecuteReader	Executes commands that return rows.
ExecutePageReader	Returns a specific subset of rows when paging through the results of a query.
ExecuteNonQuery	Executes SQL commands such as INSERT, DELETE, UPDATE.
ExecuteScalar	Retrieves a single value (for example, an aggregate value) from a database.

If execution of the command results in a fatal MySqlException, the MySqlConnection may close. However, the user can reopen the connection and continue.

This class supports cross-form data binding with the InterForm Technology.

Example

The following example uses the ExecuteReader method of MySqlCommand, along with MySqlDataReader and MySqlConnection, to select rows from a table.

[C#]

public void ReadMyData(string myConnString) 
{ 
  string mySelectQuery = "SELECT * FROM Test.Dept"; 
  MySqlConnection myConnection = new MySqlConnection(myConnString); 
  MySqlCommand myCommand = new MySqlCommand(mySelectQuery,myConnection); 
  myConnection.Open(); 
  MySqlDataReader myReader = myCommand.ExecuteReader(); 
  try 
  { 
    while (myReader.Read()) 
    { 
      Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1)); 
    } 
  } 
  finally 
  { 
  // always call Close when done reading. 
  myReader.Close(); 
  // always call Close when done reading. 
  myConnection.Close(); 
  } 
}

[Visual Basic]

Public Sub ReadMyData(myConnString As String)
   Dim mySelectQuery As String = "SELECT * FROM Test.Dept"
   Dim myConnection As New MySqlConnection(myConnString)
   Dim myCommand As New MySqlCommand(mySelectQuery, myConnection)
   myConnection.Open()
   Dim myReader As MySqlDataReader = myCommand.ExecuteReader()
   Try
     While myReader.Read()
       Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _
         + myReader.GetString(1))
     End While
   Finally
       ' always call Close when done reading.
       myReader.Close()
       ' always call Close when done with connection.
       myConnection.Close()
   End Try
 End Sub

See Also

Language