OleDbParameterCollection 類別

定義

public ref class OleDbParameterCollection sealed : MarshalByRefObject, System::Collections::IList, System::Data::IDataParameterCollection

public ref class OleDbParameterCollection sealed : System::Data::Common::DbParameterCollection

[System.ComponentModel.ListBindable(false)]
public sealed class OleDbParameterCollection : MarshalByRefObject, System.Collections.IList, System.Data.IDataParameterCollection

[System.ComponentModel.ListBindable(false)]
public sealed class OleDbParameterCollection : System.Data.Common.DbParameterCollection

[<System.ComponentModel.ListBindable(false)>]
type OleDbParameterCollection = class
    inherit MarshalByRefObject
    interface IDataParameterCollection
    interface IList
    interface ICollection
    interface IEnumerable

[<System.ComponentModel.ListBindable(false)>]
type OleDbParameterCollection = class
    inherit DbParameterCollection

Public NotInheritable Class OleDbParameterCollection
Inherits MarshalByRefObject
Implements IDataParameterCollection, IList

Public NotInheritable Class OleDbParameterCollection
Inherits DbParameterCollection

繼承

Object

MarshalByRefObject

OleDbParameterCollection

繼承

Object

MarshalByRefObject

DbParameterCollection

OleDbParameterCollection

屬性

ListBindableAttribute

實作

ICollection IEnumerable IList IDataParameterCollection

範例

以下範例透過集合在 中OleDbDataAdapter建立多個 的OleDbParameterOleDbParameterCollection實例。 這些參數用於選擇資料來源中的資料並將資料置入 DataSet。 此範例假設 a DataSet 與 an OleDbDataAdapter 已透過適當的結構、指令與連線建立。

public DataSet GetDataSetFromAdapter(
    DataSet dataSet, string connectionString, string queryString)
{
    using (OleDbConnection connection =
               new OleDbConnection(connectionString))
    {
        OleDbDataAdapter adapter =
            new OleDbDataAdapter(queryString, connection);

        // Set the parameters.
        adapter.SelectCommand.Parameters.Add(
            "@CategoryName", OleDbType.VarChar, 80).Value = "toasters";
        adapter.SelectCommand.Parameters.Add(
            "@SerialNum", OleDbType.Integer).Value = 239;

        // Open the connection and fill the DataSet.
        try
        {
            connection.Open();
            adapter.Fill(dataSet);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }
    return dataSet;
}

Public Function GetDataSetFromAdapter( _
    ByVal dataSet As DataSet, ByVal connectionString As String, _
    ByVal queryString As String) As DataSet

    Using connection As New OleDbConnection(connectionString)
        Dim adapter As New OleDbDataAdapter(queryString, connection)

        ' Set the parameters.
        adapter.SelectCommand.Parameters.Add( _
            "@CategoryName", OleDbType.VarChar, 80).Value = "toasters"
        adapter.SelectCommand.Parameters.Add( _
         "@SerialNum", OleDbType.Integer).Value = 239

        ' Open the connection and fill the DataSet.
        Try
            connection.Open()
            adapter.Fill(dataSet)
        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
        ' The connection is automatically closed when the
        ' code exits the Using block.
    End Using

    Return dataSet
End Function

備註

集合中的參數數量必須等於命令文本中的參數佔位符數，否則 OLE DB 的 .NET Framework Data Provider 可能會產生錯誤。

另請參閱

• 與指令合作
• 使用參數搭配 DataAdapter