To set the Missing SchemaAction property

1. Select Add if you want the data source table or column added to the dataset and its schema.

Setting the MissingMappingAction property to Passthrough and the MissingSchemaAction to Add results in a duplication of data source table and column names in the dataset.

  1. Select AddWithKey if you want the data source table or column added to the dataset and its schema along with the table's or column's primary key information.
  2. Select Ignore if you don't want a table or column added to the dataset, when that table or column aren't already represented in the dataset schema.

Specify Ignore when you want the dataset loaded only with data explicitly specified in the table mappings. This may be necessary if your adapter calls a stored procedure or a user-defined SQL statement that returns more columns than are defined in the dataset.

4. Select Error if you want the adapter to raise an error that you can trap.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment