CreateCommand Method (BigcommerceConnection)

In This Topic

Creates and returns a BigcommerceCommand object associated with the BigcommerceConnection.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Function CreateCommand() As BigcommerceCommand

public new BigcommerceCommand CreateCommand()

Return Value

A BigcommerceCommand object.

Remarks

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

Example

In this sample BigcommerceCommand object is created. It is automatically associated with BigcommerceConnection that created it.

csharp

public void CreateBigcommerceCommand(string myConnString)
{
  BigcommerceConnection bigcommerceConnection = new BigcommerceConnection(myConnString);
  BigcommerceCommand bigcommerceCommand = bigcommerceConnection.CreateCommand();
  bigcommerceCommand.CommandText = "INSERT INTO customers (firstname, lastname, email) VALUES ('John','Smith','[email protected]')";
  bigcommerceConnection.Open();
  try
  {
    bigcommerceCommand.ExecuteNonQuery();
  }
  finally
  {
    bigcommerceConnection.Close();
  }
}

Visual Basic

Public Sub CreateBigcommerceCommand(ByVal myConnString As String)
  Dim bigcommerceConnection As New BigcommerceConnection(myConnString)
  Dim bigcommerceCommand As BigcommerceCommand = bigcommerceConnection.CreateCommand()
  bigcommerceCommand.CommandText = "INSERT INTO customers (firstname, lastname, email) VALUES ('John','Smith','[email protected]')"
  bigcommerceConnection.Open()
  Try
    bigcommerceCommand.ExecuteNonQuery()
  Finally
    bigcommerceConnection.Close()
  End Try
End Sub

Reference

BigcommerceConnection Class
BigcommerceConnection Members
BigcommerceCommand Class

Send Feedback