This video explains understanding of DataAdapter in 2 minutes. Watch the complete video series of ADO.NET with examples at: http://www.pluralsight.com/courses/adodotnet-by-example