CreateCommand Method (ZohoDeskConnection)

In This Topic

Creates and returns a ZohoDeskCommand object associated with the ZohoDeskConnection.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Function CreateCommand() As ZohoDeskCommand

public new ZohoDeskCommand CreateCommand()

Return Value

A ZohoDeskCommand object.

Remarks

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

Example

In this sample ZohoDeskCommand object is created. It is automatically associated with ZohoDeskConnection that created it.

csharp

public void CreateZohoDeskCommand(string myConnString)
{
  ZohoDeskConnection ZohoDeskConnection = new ZohoDeskConnection(myConnString);
  ZohoDeskCommand ZohoDeskCommand = ZohoDeskConnection.CreateCommand();
  ZohoDeskCommand.CommandText = "INSERT INTO Accounts (\"Account Name\", Phone) VALUES ('Test','555-555-555')";
  ZohoDeskConnection.Open();
  try
  {
    ZohoDeskCommand.ExecuteNonQuery();
  }
  finally
  {
    ZohoDeskConnection.Close();
  }
}

Visual Basic

Public Sub CreateZohoDeskCommand(ByVal myConnString As String)
  Dim ZohoDeskConnection As New ZohoDeskConnection(myConnString)
  Dim ZohoDeskCommand As ZohoDeskCommand = ZohoDeskConnection.CreateCommand()
  ZohoDeskCommand.CommandText = "INSERT INTO Accounts (\"Account Name\", Phone) VALUES ('Test','555-555-555')"
  ZohoDeskConnection.Open()
  Try
    ZohoDeskCommand.ExecuteNonQuery()
  Finally
    ZohoDeskConnection.Close()
  End Try
End Sub

Reference

ZohoDeskConnection Class
ZohoDeskConnection Members
ZohoDeskCommand Class

Send Feedback