OdbcCommand.ExecuteReader Method
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.
Sends the CommandText to the Connection and builds an OdbcDataReader.
Overloads
ExecuteReader() |
Sends the CommandText to the Connection and builds an OdbcDataReader. |
ExecuteReader(CommandBehavior) |
Sends the CommandText to the Connection, and builds an OdbcDataReader using one of the |
ExecuteReader()
- Source:
- OdbcCommand.cs
- Source:
- OdbcCommand.cs
- Source:
- OdbcCommand.cs
- Source:
- OdbcCommand.cs
Sends the CommandText to the Connection and builds an OdbcDataReader.
public:
System::Data::Odbc::OdbcDataReader ^ ExecuteReader();
public System.Data.Odbc.OdbcDataReader ExecuteReader ();
override this.ExecuteReader : unit -> System.Data.Odbc.OdbcDataReader
member this.ExecuteReader : unit -> System.Data.Odbc.OdbcDataReader
Public Function ExecuteReader () As OdbcDataReader
Returns
An OdbcDataReader object.
Remarks
You should set the CommandText property to the full ODBC call syntax for stored procedures. The command executes this stored procedure when you call ExecuteReader.
While the OdbcDataReader is used, the associated OdbcConnection is busy serving the OdbcDataReader. While in this state, no other operations can be performed on the OdbcConnection other than closing it. This is the case until the Close method of the OdbcDataReader is called.
See also
Applies to
ExecuteReader(CommandBehavior)
- Source:
- OdbcCommand.cs
- Source:
- OdbcCommand.cs
- Source:
- OdbcCommand.cs
- Source:
- OdbcCommand.cs
Sends the CommandText to the Connection, and builds an OdbcDataReader using one of the CommandBehavior
values.
public:
System::Data::Odbc::OdbcDataReader ^ ExecuteReader(System::Data::CommandBehavior behavior);
public System.Data.Odbc.OdbcDataReader ExecuteReader (System.Data.CommandBehavior behavior);
override this.ExecuteReader : System.Data.CommandBehavior -> System.Data.Odbc.OdbcDataReader
member this.ExecuteReader : System.Data.CommandBehavior -> System.Data.Odbc.OdbcDataReader
Public Function ExecuteReader (behavior As CommandBehavior) As OdbcDataReader
Parameters
- behavior
- CommandBehavior
One of the System.Data.CommandBehavior
values.
Returns
An OdbcDataReader object.
Remarks
If you expect your SQL statement to return only a single row, specifying SingleRow
as the CommandBehavior value may improve application performance.
You should set the CommandText property to the full ODBC call syntax for stored procedures. The command executes this stored procedure when you call ExecuteReader.
The OdbcDataReader supports a special mode that enables large binary values to be read efficiently. For more information, see the SequentialAccess
setting for CommandBehavior.
Note
The SequentialAccess
value of CommandBehavior is not a limiting setting; it just means that you will have at least sequential access to the OdbcDataReader. For example, when you use the SQL Server ODBC Driver in SequentialAccess
mode, you can still move to the first column of an OdbcDataReader row after having read through all the other columns sequentially.
While the OdbcDataReader is used, the associated OdbcConnection is busy serving the OdbcDataReader. While in this state, no other operations can be performed on the OdbcConnection other than closing it. This is the case until you call the OdbcDataReader.Close method. If the OdbcDataReader is created with CommandBehavior set to CloseConnection
, closing the OdbcDataReader closes the connection automatically.
See also
Applies to
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir