OleDbCommand Constructors

Definition

Namespace:

System.Data.OleDb

Assembly:

System.Data.OleDb.dll

Package:

System.Data.OleDb v10.0.0-preview.1.25080.5

Initializes a new instance of the OleDbCommand class.

Overloads

OleDbCommand()	Initializes a new instance of the OleDbCommand class.
OleDbCommand(String)	Initializes a new instance of the OleDbCommand class with the text of the query.
OleDbCommand(String, OleDbConnection)	Initializes a new instance of the OleDbCommand class with the text of the query and an OleDbConnection.
OleDbCommand(String, OleDbConnection, OleDbTransaction)	Initializes a new instance of the OleDbCommand class with the text of the query, an OleDbConnection, and the Transaction.

OleDbCommand()

Source:

OleDbCommand.cs

Initializes a new instance of the OleDbCommand class.

C#

public OleDbCommand();

Examples

The following example creates an OleDbCommand and sets some of its properties.

C#

public void CreateReader(string connectionString, string queryString)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand(queryString, connection);
        command.CommandTimeout = 20;

        connection.Open();
        OleDbDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            Console.WriteLine(reader[0].ToString());
        }
        reader.Close();
    }
}

Remarks

The base constructor initializes all fields to their default values. The following table shows initial property values for an instance of OleDbCommand.

Properties	Initial Value
CommandText	empty string ("")
CommandTimeout	30
CommandType	Text
Connection	null

See also

• Working with Commands

OleDbCommand(String)

Source:

OleDbCommand.cs

Initializes a new instance of the OleDbCommand class with the text of the query.

C#

public OleDbCommand(string? cmdText);

Parameters

cmdText

String

The text of the query.

Examples

The following example creates an OleDbCommand and sets some of its properties.

C#

public void CreateMyOleDbCommand()
{
   string queryString = "SELECT * FROM Categories ORDER BY CategoryID";
   OleDbCommand command = new OleDbCommand(queryString);
   command.CommandTimeout = 20;
}

Remarks

The following table shows initial property values for an instance of OleDbCommand.

Properties	Initial Value
CommandText	cmdText
CommandTimeout	30
CommandType	Text
Connection	null

See also

• Working with Commands

OleDbCommand(String, OleDbConnection)

Source:

OleDbCommand.cs

Initializes a new instance of the OleDbCommand class with the text of the query and an OleDbConnection.

C#

public OleDbCommand(string? cmdText, System.Data.OleDb.OleDbConnection? connection);

Parameters

cmdText

String

The text of the query.

connection

OleDbConnection

An OleDbConnection that represents the connection to a data source.

Examples

The following example creates an OleDbCommand and sets some of its properties.

C#

public void CreateReader(string connectionString, string queryString)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand(queryString, connection);
        command.CommandTimeout = 20;

        connection.Open();
        OleDbDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            Console.WriteLine(reader[0].ToString());
        }
        reader.Close();
    }
}

Remarks

The following table shows initial property values for an instance of OleDbCommand.

Properties	Initial Value
CommandText	cmdText
CommandTimeout	30
CommandType	Text
Connection	A new OleDbConnection that is the value for the connection parameter.

You can change the value for any of these parameters by setting the related property.

See also

• Working with Commands

OleDbCommand(String, OleDbConnection, OleDbTransaction)

Source:

OleDbCommand.cs

Initializes a new instance of the OleDbCommand class with the text of the query, an OleDbConnection, and the Transaction.

C#

public OleDbCommand(string? cmdText, System.Data.OleDb.OleDbConnection? connection, System.Data.OleDb.OleDbTransaction? transaction);

Parameters

cmdText

String

The text of the query.

connection

OleDbConnection

An OleDbConnection that represents the connection to a data source.

transaction

OleDbTransaction

The transaction in which the OleDbCommand executes.

Examples

The following example creates an OleDbCommand and sets some of its properties.

C#

public void CreateReader(string connectionString, string queryString)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand(queryString, connection);
        command.CommandTimeout = 20;

        connection.Open();
        OleDbDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            Console.WriteLine(reader[0].ToString());
        }
        reader.Close();
    }
}

Remarks

The following table shows initial property values for an instance of OleDbCommand.

Properties	Initial Value
CommandText	cmdText
CommandTimeout	30
CommandType	Text
Connection	A new OleDbConnection that is the value for the connection parameter.

You can change the value for any of these parameters by setting the related property.

See also

• Working with Commands