OleDbCommand Constructor (String) (System.Data.OleDb)

Switch View :

Classic

Lightweight

ScriptFree

Site Feedback

.NET Framework Class Library

OleDbCommand Constructor (String)

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

Namespace: System.Data.OleDb
Assembly: System.Data (in System.Data.dll)

Syntax

Visual Basic

Public Sub New ( _
	cmdText As String _
)

public OleDbCommand(
	string cmdText
)

Visual C++

public:
OleDbCommand(
	String^ cmdText
)

new : 
        cmdText:string -> OleDbCommand

Parameters

cmdText: Type: System.String
The text of the query.

Remarks

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

Properties	Initial Value
CommandText	cmdText
[!:System.Data.OleDb.OleDbCommand.CommandTimeout]	30
CommandType	Text
Connection	null

Examples

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

Visual Basic


Public Sub CreateMyOleDbCommand()
    Dim queryString As String = "SELECT * FROM Categories ORDER BY CategoryID"
    Dim command As New OleDbCommand(queryString)
    command.CommandTimeout = 20
End Sub


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

Version Information

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Platforms

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Reference

OleDbCommand Class

OleDbCommand Overload

System.Data.OleDb Namespace

Other Resources

Commands and Parameters (ADO.NET)