in case you just need to display data , like u want to display information of cities in dropdown list, its less overhead than using dataset where u have local copy of data for various use like navigating through records ds.tables[0].rows[0][1] , like this but when only information is just to be displayed better to use datareader , its light and fast