Метод ExecuteReader (String, SqlCommand)
Executes a reader using a SqlDataReader object value that contains one or more result sets.
Пространство имен: Microsoft.SqlServer.Management.Common
Сборка: Microsoft.SqlServer.ConnectionInfo (в Microsoft.SqlServer.ConnectionInfo.dll)
Синтаксис
'Декларация
Public Function ExecuteReader ( _
sqlCommand As String, _
<OutAttribute> ByRef command As SqlCommand _
) As SqlDataReader
'Применение
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
Параметры
- sqlCommand
Тип: System. . :: . .String
A String value that specifies the Transact-SQL commands to be executed.
- command
Тип: System.Data.SqlClient. . :: . .SqlCommand%
A SqlCommand object that can be used to cancel the SqlDataReader pipe to terminate a long-running command.
Возвращаемое значение
Тип: System.Data.SqlClient. . :: . .SqlDataReader
A SqlDataReader object value that contains one or more result sets.
Замечания
The SqlDataReader object is returned to let the client process the data without requiring it to read all information into memory.