通过

  • 项目

ExecuteWithResults 方法 (StringCollection)

Executes a batch in the context of the database where there are results returned.

命名空间：  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

参数

返回值

类型：System.Data. . :: . .DataSet
A DataSet system object value that contains the returned results set.

示例

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")

'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