Condividi tramite


Metodo ServerConnection.ExecuteReader (String, SqlCommand%)

Executes a reader using a SqlDataReader object value that contains one or more result sets.

Spazio dei nomi  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Sintassi

'Dichiarazione
Public Function ExecuteReader ( _
    sqlCommand As String, _
    <OutAttribute> ByRef command As SqlCommand _
) As SqlDataReader
'Utilizzo
Dim instance As ServerConnection 
Dim sqlCommand As String 
Dim command As SqlCommand 
Dim returnValue As SqlDataReader 

returnValue = instance.ExecuteReader(sqlCommand, _
    command)
public SqlDataReader ExecuteReader(
    string sqlCommand,
    out SqlCommand command
)
public:
SqlDataReader^ ExecuteReader(
    String^ sqlCommand, 
    [OutAttribute] SqlCommand^% command
)
member ExecuteReader : 
        sqlCommand:string * 
        command:SqlCommand byref -> SqlDataReader
public function ExecuteReader(
    sqlCommand : String, 
    command : SqlCommand
) : SqlDataReader

Parametri

  • sqlCommand
    Tipo: System.String
    A String value that specifies the Transact-SQL commands to be executed.

Valore restituito

Tipo: System.Data.SqlClient.SqlDataReader
A SqlDataReader object value that contains one or more result sets.

Osservazioni

The SqlDataReader object is returned to let the client process the data without requiring it to read all information into memory.

Vedere anche

Riferimento

ServerConnection Classe

Overload ExecuteReader

Spazio dei nomi Microsoft.SqlServer.Management.Common