ServerConnection.ExecuteReader 方法 (String)
执行返回一个或多个结果集的 Transact-SQL 语句。
命名空间: 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
类型:String
一个 String 值,该值指定要执行的 Transact-SQL 命令。
返回值
类型:SqlDataReader
一个 SqlDataReader 对象值,该值包含一个或多个结果集。
注释
使用 SqlDataReader 对象返回客户处理数据 , 而不需要它读取所有信息入记忆。
示例
C#
ServerConnection conn = new ServerConnection();
conn.DatabaseName = "AdventureWorks2012";
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 = "AdventureWorks2012"
$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()