The main components of ADO.NET are the .NET Data Providers and the DataSet object. A .Net Data provider is used to connect to a database, execute commands, and retrieve results. The DataSet consists of a collection of DataTables and relations. From the following chapters you can see very useful ADO.NET C# programs and sourcecode