ExecuteWithResults 方法 (StringCollection)
在有傳回結果的資料庫內容中執行批次。
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
Public Function ExecuteWithResults ( _
sqlCommands As StringCollection _
) As DataSet
'用途
Dim instance As Database
Dim sqlCommands As StringCollection
Dim returnValue As DataSet
returnValue = instance.ExecuteWithResults(sqlCommands)
public DataSet ExecuteWithResults(
StringCollection sqlCommands
)
public:
DataSet^ ExecuteWithResults(
StringCollection^ sqlCommands
)
member ExecuteWithResults :
sqlCommands:StringCollection -> DataSet
public function ExecuteWithResults(
sqlCommands : StringCollection
) : DataSet
參數
- sqlCommands
型別:System.Collections.Specialized. . :: . .StringCollection
包含多個 Transact-SQL 命令的 StringCollection 系統物件值。
傳回值
型別:System.Data. . :: . .DataSet
包含所傳回之結果集的 DataSet 系統物件值。
範例
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Run a Transact-SQL command on the database.
db.ExecuteNonQuery("CHECKPOINT")
'Run a Transact-SQL command with results and display.
Dim ds As DataSet
ds = db.ExecuteWithResults( _
"SELECT * FROM Person.Address")
Dim t As DataTable
Dim r As DataRow
Dim c As DataColumn
For Each t In ds.Tables
For Each r In t.Rows
For Each c In r.Table.Columns
Console.WriteLine( _
c.ColumnName + " = " + r(c).ToString)
Next
Next
Next
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
$db.ExecuteNonQuery("CHECKPOINT")
$ds = $db.ExecuteWithResults("SELECT * FROM Person.Address")
Foreach ($t in $ds.Tables)
{
Foreach ($r in $t.Rows)
{
Foreach ($c in $t.Columns)
{
Write-Host $c.ColumnName "=" $r.Item($c)
}
}
}