What is the alter native for sqldatareader in ADO.NET for connection with database?

For accessing data from database we can use datareader but if we have to use dataset instead of datareader then we need both sqldataadapter and dataset because dataset only contain the data from multiple table and sqldataadapter is used for connection between dataset and database.