See Also

OracleConnection Class  | OracleConnection Members  | OracleCommand Class

Language

Visual Basic

C#

Show All

See AlsoLanguagesDevart.Data.OracleSend comments on this topic.

CreateCommand Method

Devart.Data.Oracle Namespace > OracleConnection Class : CreateCommand Method (OracleConnection)

Creates and returns a OracleCommand object associated with the OracleConnection.

[Visual Basic]
Public Function CreateCommand() As OracleCommand
[C#]
public OracleCommand CreateCommand();

Return Type

A OracleCommand object.

Remarks

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

Example

In this sample OracleCommand object is created. It is automatically associated with OracleConnection that created it.

[C#] 

public void CreateOracleCommand(string myConnString) 
{ 
  OracleConnection myConnection = new OracleConnection(myConnString); 
  OracleCommand myCommand = myConnection.CreateCommand(); 
  myCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"; 
  myConnection.Open(); 
  try 
  { 
    myCommand.ExecuteNonQuery(); 
  } 
  finally 
  { 
    myConnection.Close(); 
  } 
} 

[Visual Basic] 

Public Sub CreateOracleCommand(ByVal myConnString As String)
  Dim myConnection As New OracleConnection(myConnString)
  Dim myCommand As OracleCommand = myConnection.CreateCommand()
  myCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
  myConnection.Open()
  Try
    myCommand.ExecuteNonQuery()
  Finally
    myConnection.Close()
  End Try
End Sub

See Also

OracleConnection Class  | OracleConnection Members  | OracleCommand Class

 

 

© 2002 - 2013 Devart. All Rights Reserved.