DataAdapter.MissingSchemaAction Property

Definition

Namespace:

System.Data.Common

Assemblies:

netstandard.dll, System.Data.Common.dll

Source:

DataAdapter.cs

Determines the action to take when existing DataSet schema does not match incoming data.

public:
 property System::Data::MissingSchemaAction MissingSchemaAction { System::Data::MissingSchemaAction get(); void set(System::Data::MissingSchemaAction value); };

public System.Data.MissingSchemaAction MissingSchemaAction { get; set; }

member this.MissingSchemaAction : System.Data.MissingSchemaAction with get, set

Public Property MissingSchemaAction As MissingSchemaAction

Property Value

MissingSchemaAction

One of the MissingSchemaAction values. The default is Add.

Implements

MissingSchemaAction

Exceptions

ArgumentException

The value set is not one of the MissingSchemaAction values.

Examples

The following example creates a derived class, OleDbDataAdapter and sets some of its properties.

// Assumes a valid connection string to an Access database.
static void CreateOleDbAdapter(string connectionString)
{
    OleDbDataAdapter adapter = new OleDbDataAdapter();
    adapter.SelectCommand =
        new OleDbCommand("SELECT * FROM Categories ORDER BY CategoryID");
    adapter.SelectCommand.Connection =
        new OleDbConnection(connectionString);
    adapter.MissingMappingAction = MissingMappingAction.Error;
    adapter.MissingSchemaAction = MissingSchemaAction.Error;
}

' Assumes a valid connection string to an Access database.
Private Sub CreateOleDbDataAdapter(ByVal connectionString As String)
    Dim adapter As New OleDbDataAdapter()
    adapter.SelectCommand = _
       New OleDbCommand("SELECT * FROM Categories ORDER BY CategoryID")
    adapter.SelectCommand.Connection = New OleDbConnection _
       (connectionString)
    adapter.MissingMappingAction = MissingMappingAction.Error
    adapter.MissingSchemaAction = MissingSchemaAction.Error
End Sub

See also

• MissingMappingAction
• ADO.NET Overview