CreateCommand Method (MagentoConnection)

On this page

Creates and returns a MagentoCommand object associated with the MagentoConnection.

Syntax

Visual Basic
C#


'Declaration Public Shadows Function CreateCommand() As MagentoCommand


public new MagentoCommand CreateCommand()

Return Value

A MagentoCommand object.

Remarks

You can use this method as an alternative to common MagentoCommand constructors.

Example

In this sample MagentoCommand object is created. It is automatically associated with MagentoConnection that created it.

csharp


public void CreateMagentoCommand(string myConnString) { MagentoConnection adobe commerceConnection = new MagentoConnection(myConnString); MagentoCommand adobe commerceCommand = adobe commerceConnection.CreateCommand(); adobe commerceCommand.CommandText = "INSERT INTO Customers (email, firstname, lastname) VALUES ('[email protected]', 'John', 'Smith')"; adobe commerceConnection.Open(); try { adobe commerceCommand.ExecuteNonQuery(); } finally { adobe commerceConnection.Close(); } }

public void CreateMagentoCommand(string myConnString)
{
  MagentoConnection adobe commerceConnection = new MagentoConnection(myConnString);
  MagentoCommand adobe commerceCommand = adobe commerceConnection.CreateCommand();
  adobe commerceCommand.CommandText = "INSERT INTO Customers (email, firstname, lastname) VALUES ('[email protected]', 'John', 'Smith')";
  adobe commerceConnection.Open();
  try
  {
    adobe commerceCommand.ExecuteNonQuery();
  }
  finally
  {
    adobe commerceConnection.Close();
  }
}

Visual Basic


Public Sub CreateMagentoCommand(ByVal myConnString As String) Dim adobe commerceConnection As New MagentoConnection(myConnString) Dim adobe commerceCommand As MagentoCommand = adobe commerceConnection.CreateCommand() adobe commerceCommand.CommandText = "INSERT INTO Customers (email, firstname, lastname) VALUES ('[email protected]', 'John', 'Smith')" adobe commerceConnection.Open() Try adobe commerceCommand.ExecuteNonQuery() Finally adobe commerceConnection.Close() End Try End Sub

Public Sub CreateMagentoCommand(ByVal myConnString As String)
  Dim adobe commerceConnection As New MagentoConnection(myConnString)
  Dim adobe commerceCommand As MagentoCommand = adobe commerceConnection.CreateCommand()
  adobe commerceCommand.CommandText = "INSERT INTO Customers (email, firstname, lastname) VALUES ('[email protected]', 'John', 'Smith')"
  adobe commerceConnection.Open()
  Try
    adobe commerceCommand.ExecuteNonQuery()
  Finally
    adobe commerceConnection.Close()
  End Try
End Sub

Reference

MagentoConnection Class
MagentoConnection Members
MagentoCommand Class

Send Feedback