ExecuteReader 方法 (String)

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

命名空間：  Microsoft.SqlServer.Management.Common
組件：  Microsoft.SqlServer.ConnectionInfo (在 Microsoft.SqlServer.ConnectionInfo.dll 中)

語法

'宣告
Public Function ExecuteReader ( _
    sqlCommand As String _
) As SqlDataReader
'用途
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

參數

• sqlCommand
  型別：System. . :: . .String
  A String value that specifies the Transact-SQL command to be executed.

傳回值

型別：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.

範例

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()

請參閱

參考

ServerConnection 類別

ExecuteReader 多載

Microsoft.SqlServer.Management.Common 命名空間