發行項
09/24/2010

ExecuteNonQuery 方法 (String)

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

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

語法

'宣告
Public Sub ExecuteNonQuery ( _
    sqlCommand As String _
)
'用途
Dim instance As Database
Dim sqlCommand As String

instance.ExecuteNonQuery(sqlCommand)

public void ExecuteNonQuery(
    string sqlCommand
)

public:
void ExecuteNonQuery(
    String^ sqlCommand
)

member ExecuteNonQuery : 
        sqlCommand:string -> unit

public function ExecuteNonQuery(
    sqlCommand : String
)

參數

sqlCommand
型別：System. . :: . .String
A String value that contains the Transact-SQL command.

範例

'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