OleDbCommand Constructors
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
Initializes a new instance of the OleDbCommand class.
public:
OleDbCommand();
public OleDbCommand ();
Public Sub New ()
Examples
The following example creates an OleDbCommand and sets some of its properties.
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();
}
}
Public Sub CreateReader(ByVal connectionString As String, _
ByVal queryString As String)
Using connection As New OleDbConnection(connectionString)
Dim command As New OleDbCommand(queryString, connection)
command.CommandTimeout = 20
connection.Open()
Dim reader As OleDbDataReader = command.ExecuteReader()
While reader.Read()
Console.WriteLine(reader(0).ToString())
End While
reader.Close()
End Using
End Sub
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
Applies to
OleDbCommand(String)
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
Initializes a new instance of the OleDbCommand class with the text of the query.
public:
OleDbCommand(System::String ^ cmdText);
public OleDbCommand (string cmdText);
public OleDbCommand (string? cmdText);
new System.Data.OleDb.OleDbCommand : string -> System.Data.OleDb.OleDbCommand
Public Sub New (cmdText As String)
Parameters
- cmdText
- String
The text of the query.
Examples
The following example creates an OleDbCommand and sets some of its properties.
public void CreateMyOleDbCommand()
{
string queryString = "SELECT * FROM Categories ORDER BY CategoryID";
OleDbCommand command = new OleDbCommand(queryString);
command.CommandTimeout = 20;
}
Public Sub CreateMyOleDbCommand()
Dim queryString As String = "SELECT * FROM Categories ORDER BY CategoryID"
Dim command As New OleDbCommand(queryString)
command.CommandTimeout = 20
End Sub
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
Applies to
OleDbCommand(String, OleDbConnection)
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
Initializes a new instance of the OleDbCommand class with the text of the query and an OleDbConnection.
public:
OleDbCommand(System::String ^ cmdText, System::Data::OleDb::OleDbConnection ^ connection);
public OleDbCommand (string cmdText, System.Data.OleDb.OleDbConnection connection);
public OleDbCommand (string? cmdText, System.Data.OleDb.OleDbConnection? connection);
new System.Data.OleDb.OleDbCommand : string * System.Data.OleDb.OleDbConnection -> System.Data.OleDb.OleDbCommand
Public Sub New (cmdText As String, connection As OleDbConnection)
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.
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();
}
}
Public Sub CreateReader(ByVal connectionString As String, _
ByVal queryString As String)
Using connection As New OleDbConnection(connectionString)
Dim command As New OleDbCommand(queryString, connection)
command.CommandTimeout = 20
connection.Open()
Dim reader As OleDbDataReader = command.ExecuteReader()
While reader.Read()
Console.WriteLine(reader(0).ToString())
End While
reader.Close()
End Using
End Sub
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
Applies to
OleDbCommand(String, OleDbConnection, OleDbTransaction)
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
- Source:
- OleDbCommand.cs
Initializes a new instance of the OleDbCommand class with the text of the query, an OleDbConnection, and the Transaction.
public:
OleDbCommand(System::String ^ cmdText, System::Data::OleDb::OleDbConnection ^ connection, System::Data::OleDb::OleDbTransaction ^ transaction);
public OleDbCommand (string cmdText, System.Data.OleDb.OleDbConnection connection, System.Data.OleDb.OleDbTransaction transaction);
public OleDbCommand (string? cmdText, System.Data.OleDb.OleDbConnection? connection, System.Data.OleDb.OleDbTransaction? transaction);
new System.Data.OleDb.OleDbCommand : string * System.Data.OleDb.OleDbConnection * System.Data.OleDb.OleDbTransaction -> System.Data.OleDb.OleDbCommand
Public Sub New (cmdText As String, connection As OleDbConnection, transaction As OleDbTransaction)
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.
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();
}
}
Public Sub CreateReader(ByVal connectionString As String, _
ByVal queryString As String)
Using connection As New OleDbConnection(connectionString)
Dim command As New OleDbCommand(queryString, connection)
command.CommandTimeout = 20
connection.Open()
Dim reader As OleDbDataReader = command.ExecuteReader()
While reader.Read()
Console.WriteLine(reader(0).ToString())
End While
reader.Close()
End Using
End Sub
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
Applies to
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應