OdbcCommand 类

定义

public ref class OdbcCommand sealed : System::Data::Common::DbCommand, ICloneable

public ref class OdbcCommand sealed : System::ComponentModel::Component, ICloneable, IDisposable, System::Data::IDbCommand

public sealed class OdbcCommand : System.Data.Common.DbCommand, ICloneable

public sealed class OdbcCommand : System.ComponentModel.Component, ICloneable, IDisposable, System.Data.IDbCommand

type OdbcCommand = class
    inherit DbCommand
    interface ICloneable

type OdbcCommand = class
    inherit Component
    interface ICloneable
    interface IDbCommand
    interface IDisposable

Public NotInheritable Class OdbcCommand
Inherits DbCommand
Implements ICloneable

Public NotInheritable Class OdbcCommand
Inherits Component
Implements ICloneable, IDbCommand, IDisposable

继承

Object

MarshalByRefObject

Component

DbCommand

OdbcCommand

继承

Object

MarshalByRefObject

Component

OdbcCommand

实现

ICloneable IDbCommand IDisposable

示例

以下示例使用 ExecuteNonQuery。

public void InsertRow(string connectionString, string insertSQL)
{
    using (OdbcConnection connection =
               new OdbcConnection(connectionString))
    {
        // The insertSQL string contains a SQL statement that
        // inserts a new row in the source table.
        OdbcCommand command = new OdbcCommand(insertSQL, connection);

        // Open the connection and execute the insert command.
        try
        {
            connection.Open();
            command.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }

Public Sub InsertRow(ByVal connectionString As String, _
    ByVal insertSQL As String)

    Using connection As New OdbcConnection(connectionString)
        ' The insertSQL string contains a SQL statement that
        ' inserts a new row in the source table.
        Dim command As New OdbcCommand(insertSQL, connection)

        ' Open the connection and execute the insert command.
        Try
            connection.Open()
            command.ExecuteNonQuery()
        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
        ' The connection is automatically closed when the
        ' code exits the Using block.
    End Using
End Sub

注解

OdbcCommand 类提供以下方法，用于针对数据源执行命令：

可以重置 CommandText 属性并重复使用 OdbcCommand 对象。 但是，必须先关闭 OdbcDataReader，然后才能执行新的或以前的命令。

如果执行命令会导致致命 OdbcException（例如 SQL Server 严重级别为 20 或更高），OdbcConnection 可能会关闭。 但是，用户可以重新打开连接并继续。

构造函数

属性

方法

事件

显式接口实现

扩展方法

适用于

另请参阅

• OdbcDataAdapter
• OdbcConnection
• 执行命令