Sams Teach Yourself ADO.NET in 21 Days

Workshop

This workshop will help reinforce the concepts covered in today's lesson.

Quiz

1:	When would you set the MissingSchemaAction property to Error?
A1:	Setting the MissingSchemaAction property to Error will cause the Fill method to throw an exception if the incoming schema (the one from the data store) doesn't exactly match that in the existing DataTable. You can use this to ensure that the DataTable you're reading into is correct for the data store.
2:	What is the purpose of table and column mappings?
A2:	Table and column mappings are used by the data adapter to map the incoming table and column names with DataTable and DataColumn names to be populated. They can be used both to match an existing schema and to specify what the new schema will ...