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.

Exception Condition

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
Available since 1.1
Return to top
© 2015 Microsoft