Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MissingSchemaAction Property

DataAdapter.MissingSchemaAction Property

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

Namespace:  System.Data.Common
Assembly:  System.Data (in System.Data.dll)

public MissingSchemaAction MissingSchemaAction { get; set; }

Property Value

Type: System.Data.MissingSchemaAction
One of the MissingSchemaAction values. The default is Add.

Implements

IDataAdapter.MissingSchemaAction

ExceptionCondition
ArgumentException

The value set is not one of the MissingSchemaAction values.

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;
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft