Freigeben über


ExecuteReader-Methode (String)

Executes Transact-SQL statements that return one or multiple result sets.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

'Declaration
Public Function ExecuteReader ( _
    sqlCommand As String _
) As SqlDataReader
'Usage
Dim instance As ServerConnection
Dim sqlCommand As String
Dim returnValue As SqlDataReader

returnValue = instance.ExecuteReader(sqlCommand)
public SqlDataReader ExecuteReader(
    string sqlCommand
)
public:
SqlDataReader^ ExecuteReader(
    String^ sqlCommand
)
member ExecuteReader : 
        sqlCommand:string -> SqlDataReader 
public function ExecuteReader(
    sqlCommand : String
) : SqlDataReader

Parameter

Rückgabewert

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

Hinweise

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

Beispiele

C#

ServerConnection conn = new ServerConnection();
conn.DatabaseName = "AdventureWorks2008R2";
SqlDataReader reader = conn.ExecuteReader("SELECT Name, CostRate FROM Production.Location");
while (reader.Read())
{
   string name = (string)reader["Name"];
   decimal cRate = (decimal)reader["CostRate"];
   Console.WriteLine(name + "(" + cRate + ")");
}
reader.Close();

PowerShell

$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection
$conn.DatabaseName = "AdventureWorks2008R2"
$reader = $conn.ExecuteReader("SELECT Name, CostRate FROM Production.Location")
while ($reader.Read())
{
   $name = $reader.GetValue(0);
   $cRate = $reader.GetValue(1);
   Write-Host $name,"(",$cRate,")"
}
$reader.Close()