Fill Dataset Using Reader

SqlDataReader dr;
            SqlConnection connection = new SqlConnection(sqlConnectString);
            SqlCommand command = new SqlCommand(sqlSelect, connection);
            connection.Open( );
            dr = command.ExecuteReader( );

            // Create the DataSet using the DataSet.Load( ) method
            DataSet ds = new DataSet( );
            ds.Load(dr, LoadOption.OverwriteChanges,
                new string[ {"Department", "Contact"});

            int tableCount = 0;
            foreach(DataTable dt in ds.Tables)
            {
                Console.WriteLine("Table {0}; Name = {1}", tableCount++,
                    dt.TableName);
                foreach(DataRow row in dt.Rows)
                {
                    for(int i = 0; i < dt.Columns.Count; i++)
                        Console.Write("{0} = {1};", dt.ColumnsIdea.ColumnName,
                            rowIdea);
                    Console.WriteLine( );
                }
                Console.WriteLine( );
            }

            Console.WriteLine("Press any key to continue.");
            Console.ReadKey( );