dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlCommand Class / Parameters Property
Example

On this page
    Parameters Property
    On this page
    Gets or sets the MySqlParameterCollection.
    Syntax
    'Declaration
     
    Public Shadows ReadOnly Property Parameters As MySqlParameterCollection
    public new MySqlParameterCollection Parameters {get;}

    Property Value

    The parameters of a SQL statement or a stored procedure. The default value is an empty collection.
    Remarks
    By default, you have to construct this collection and provide values for it manually. However, if you choose to use autosynchronization mode by setting ParameterCheck property to true you can have the collecton adjusted automatically. Please refer to article Using Parameters in dotConnect for MySQL for detailed information on using this mode.

    dotConnect for MySQL supports named and unnamed parameters.

    Example
    The following example creates a MySqlConnection, MySqlCommand, fills its parameters and displays them. An UPDATE statement with the parameters involved is executed then.
    static void CreateCommand(MySqlConnection mySqlConnection, string mySelectQuery, MySqlParameter[] myParamArray)
    {
      MySqlCommand mySqlCommand = new MySqlCommand(mySelectQuery, mySqlConnection);
      string myMessage = "";
      for (int i = 0; i < myParamArray.Length; i++)
      {
        mySqlCommand.Parameters.Add(myParamArray[i]);
        myMessage += mySqlCommand.Parameters[i].ToString() + "\n";
      }
      Console.Write(myMessage);
      try
      {
        mySqlConnection.Open();
        mySqlCommand.ExecuteNonQuery();
      }
      finally
      {
        mySqlConnection.Close();
      }
    }
    
    static void Main(string[] args)
    {
      MySqlParameter[] myParams = new MySqlParameter[] 
        {
          new MySqlParameter("DeptNo", 10),
          new MySqlParameter("DName", "COUNTING")
        };
      MySqlConnection mySqlConnection1 = new MySqlConnection(
          "User Id=root;Host=localhost;Database=Test;");
      CreateCommand(mySqlConnection1,"UPDATE Test.Dept SET DName = :DName WHERE DeptNo = :DeptNo",myParams);
    }
    Public Sub CreateCommand(ByVal mySqlConnection As Devart.Data.MySql.MySqlConnection, _
     ByVal mySelectQuery As String, ByVal myParamArray() As Devart.Data.MySql.MySqlParameter)
      Dim mySqlCommand As New Devart.Data.MySql.MySqlCommand(mySelectQuery, mySqlConnection)
      Dim myMessage As String = ""
      Dim i As Integer
      For i = 0 To (myParamArray.Length - 1)
        mySqlCommand.Parameters.Add(myParamArray(i))
        myMessage = String.Concat(myMessage, " ", mySqlCommand.Parameters(i).ToString())
      Next
      Console.WriteLine(myMessage)
      Try
        mySqlConnection.Open()
        mySqlCommand.ExecuteNonQuery()
      Finally
        mySqlConnection.Close()
      End Try
    End Sub
    
    Sub Main()
      Dim myP1 As New Devart.Data.MySql.MySqlParameter
      myP1.ParameterName = "DeptNo"
      myP1.Value = 10
      Dim myP2 As New Devart.Data.MySql.MySqlParameter
      myP2.ParameterName = "DName"
      myP2.Value = "ACCOUNTING"
      Dim myParams(1) As Devart.Data.MySql.MySqlParameter
      myParams(0) = myP1
      myParams(1) = myP2
      Dim mySqlConnection1 As New Devart.Data.MySql.MySqlConnection( _
          "User Id=root;Host=localhost;Database=Test;")
      CreateCommand(mySqlConnection1, "UPDATE Test.Dept SET DName = :DName WHERE DeptNo = :DeptNo", myParams)
    End Sub
    See Also