Database.ExecuteNonQuery Method (StringCollection)

2008-12-15

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

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Sub ExecuteNonQuery ( _
    sqlCommands As StringCollection _
)

public void ExecuteNonQuery (
    StringCollection sqlCommands
)

public:
void ExecuteNonQuery (
    StringCollection^ sqlCommands
)

public void ExecuteNonQuery (
    StringCollection sqlCommands
)

public function ExecuteNonQuery (
    sqlCommands : StringCollection
)

参数

sqlCommands
A StringCollection System object value that contains more than one Transact-SQL command.

备注

The StringCollection value of the sqlCommands parameter makes it possible to send a Transact-SQL script with multiple commands.

已更新的文本：2006 年 7 月 17 日

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

'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

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.