OracleCommand Construtores
Definição
Inicializa uma nova instância do OracleCommand.Initializes a new instance of the OracleCommand.
Sobrecargas
| OracleCommand() |
Inicializa uma nova instância do OracleCommand.Initializes a new instance of the OracleCommand. |
| OracleCommand(String) |
Inicializa uma nova instância da classe OracleCommand com o texto da consulta.Initializes a new instance of the OracleCommand class with the text of the query. |
| OracleCommand(String, OracleConnection) |
Inicializa uma nova instância da classe OracleCommand com o texto da consulta e um objeto OracleConnection.Initializes a new instance of the OracleCommand class with the text of the query and an OracleConnection object. |
| OracleCommand(String, OracleConnection, OracleTransaction) |
Inicializa uma nova instância da classe OracleCommand com o texto da consulta, um objeto OracleConnection e um OracleTransaction.Initializes a new instance of the OracleCommand class with the text of the query, an OracleConnection object, and an OracleTransaction. |
OracleCommand()
Inicializa uma nova instância do OracleCommand.Initializes a new instance of the OracleCommand.
public:
OracleCommand();
public OracleCommand ();
Public Sub New ()
Exemplos
O exemplo a seguir cria um OracleCommand e define algumas de suas propriedades.The following example creates an OracleCommand and sets some of its properties.
public void CreateOracleCommand()
{
OracleCommand command = new OracleCommand();
command.CommandType = CommandType.Text;
}
Public Sub CreateOracleCommand()
Dim command As New OracleCommand()
command.CommandType = CommandType.Text
End Sub
Comentários
O construtor base inicializa todos os campos com seus valores padrão.The base constructor initializes all fields to their default values. A tabela a seguir mostra os valores de propriedade inicial para uma instância do OracleCommand .The following table shows initial property values for an instance of OracleCommand.
| PropriedadesProperties | Valor inicialInitial Value |
|---|---|
| CommandText | Cadeia de caracteres vazia ("")empty string ("") |
| CommandType | Text |
| Connection | nullnull |
Aplica-se a
OracleCommand(String)
Inicializa uma nova instância da classe OracleCommand com o texto da consulta.Initializes a new instance of the OracleCommand class with the text of the query.
public:
OracleCommand(System::String ^ commandText);
public OracleCommand (string commandText);
new System.Data.OracleClient.OracleCommand : string -> System.Data.OracleClient.OracleCommand
Public Sub New (commandText As String)
Parâmetros
- commandText
- String
O texto da consulta.The text of the query.
Aplica-se a
OracleCommand(String, OracleConnection)
Inicializa uma nova instância da classe OracleCommand com o texto da consulta e um objeto OracleConnection.Initializes a new instance of the OracleCommand class with the text of the query and an OracleConnection object.
public:
OracleCommand(System::String ^ commandText, System::Data::OracleClient::OracleConnection ^ connection);
public OracleCommand (string commandText, System.Data.OracleClient.OracleConnection connection);
new System.Data.OracleClient.OracleCommand : string * System.Data.OracleClient.OracleConnection -> System.Data.OracleClient.OracleCommand
Public Sub New (commandText As String, connection As OracleConnection)
Parâmetros
- commandText
- String
O texto da consulta.The text of the query.
- connection
- OracleConnection
Um objeto OracleConnection que representa a conexão com um banco de dados.An OracleConnection object that represents the connection to a database.
Exemplos
O exemplo a seguir cria um OracleCommand .The following example creates an OracleCommand.
public void CreateOracleCommand()
{
OracleConnection connection = new OracleConnection("Data Source=Oracle8i;Integrated Security=yes");
string queryString = "SELECT * FROM Emp ORDER BY EmpNo";
OracleCommand command = new OracleCommand(queryString, connection);
}
Public Sub CreateOracleCommand()
Dim connection As New OracleConnection _
("Data Source=Oracle8i;Integrated Security=yes")
Dim queryString As String = _
"SELECT * FROM Emp ORDER BY EmpNo"
Dim command As New OracleCommand(queryString, connection)
End Sub
Aplica-se a
OracleCommand(String, OracleConnection, OracleTransaction)
Inicializa uma nova instância da classe OracleCommand com o texto da consulta, um objeto OracleConnection e um OracleTransaction.Initializes a new instance of the OracleCommand class with the text of the query, an OracleConnection object, and an OracleTransaction.
public:
OracleCommand(System::String ^ commandText, System::Data::OracleClient::OracleConnection ^ connection, System::Data::OracleClient::OracleTransaction ^ tx);
public OracleCommand (string commandText, System.Data.OracleClient.OracleConnection connection, System.Data.OracleClient.OracleTransaction tx);
new System.Data.OracleClient.OracleCommand : string * System.Data.OracleClient.OracleConnection * System.Data.OracleClient.OracleTransaction -> System.Data.OracleClient.OracleCommand
Public Sub New (commandText As String, connection As OracleConnection, tx As OracleTransaction)
Parâmetros
- commandText
- String
O texto da consulta.The text of the query.
- connection
- OracleConnection
Um objeto OracleConnection que representa a conexão com um banco de dados.An OracleConnection object that represents the connection to a database.
O OracleTransaction no qual o OracleCommand é executado.The OracleTransaction in which the OracleCommand executes.
Exemplos
O exemplo a seguir cria um OracleCommand e define algumas de suas propriedades.The following example creates an OracleCommand and sets some of its properties.
public void CreateOracleCommand(string connectionString)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
OracleTransaction transaction = connection.BeginTransaction();
string queryString = "SELECT * FROM Emp ORDER BY EmpNo";
OracleCommand command = new OracleCommand(queryString, connection, transaction);
command.CommandType = CommandType.Text;
}
}
Public Sub CreateOracleCommand(ByVal connectionString As String)
Using connection As New OracleConnection(connectionString)
connection.Open()
Dim transaction As OracleTransaction = connection.BeginTransaction()
Dim queryString As String = _
"SELECT * FROM Emp ORDER BY EmpNo"
Dim command As New OracleCommand(queryString, connection, transaction)
command.CommandType = CommandType.Text
End Using
End Sub
Comentários
A tabela a seguir mostra os valores de propriedade inicial para uma instância dessa implementação do OracleCommand .The following table shows initial property values for an instance of this implementation of the OracleCommand.
| PropriedadesProperties | Valor inicialInitial Value |
|---|---|
| CommandText | cmdText |
| CommandType | Text |
| Connection | Um novo OracleConnection que é o valor para o connection parâmetro.A new OracleConnection that is the value for the connection parameter. |
Você pode alterar o valor de qualquer um desses parâmetros definindo a propriedade related.You can change the value for any of these parameters by setting the related property.