执行目录操作 (ADO.NET)

  • 项目

更新：November 2007

若要执行对数据库或编录进行修改的命令（如 CREATE TABLE 或 CREATE PROCEDURE 语句），请使用相应的 SQL 语句和 Connection 对象创建一个 Command 对象。 使用 Command 对象的 ExecuteNonQuery 方法来执行该命令。

以下代码示例在 Microsoft SQL Server 数据库中创建一个存储过程。

' Assumes connection is a valid SqlConnection.
Dim queryString As String = "CREATE PROCEDURE InsertCategory " & _
    "@CategoryName nchar(15), " & _
    "@Identity int OUT " & _
    "AS " & _
    "INSERT INTO Categories (CategoryName) VALUES(@CategoryName) " & _
    "SET @Identity = @@Identity " & _
    "RETURN @@ROWCOUNT"

Dim command As SqlCommand = New SqlCommand(queryString, connection)
command.ExecuteNonQuery()

// Assumes connection is a valid SqlConnection.
string queryString = "CREATE PROCEDURE InsertCategory  " + 
    "@CategoryName nchar(15), " +
    "@Identity int OUT " +
    "AS " + 
    "INSERT INTO Categories (CategoryName) VALUES(@CategoryName) " + 
    "SET @Identity = @@Identity " +
    "RETURN @@ROWCOUNT";

SqlCommand command = new SqlCommand(queryString, connection);
command.ExecuteNonQuery();

请参见

其他资源

使用命令修改数据 (ADO.NET)

命令和参数 (ADO.NET)