What to use for a datagrid with a lot of data? <p>Found this interesting interview question:</p> <p>You need to display the sales data for your division for the past 5 years in a DataGrid on a Web Form. Performance is very important. What would be the best strategy to use in retrieving the data?</p> <ul> <li>a)Use a DataReader object to retrieve the data for the DataGrid.</li> <li>b)Use a DataSet object to retrieve the data for the DataGrid.</li> <li>c)Use a simple select statement as the data source for the DataGrid.</li> <li>d)Use a cached XML file as the data source and retrieve the data with a DataSet.</li> </ul> <p>My answer is c) but I am not too sure Can anyone point me to the right answer and explain it to me please Thanks</p>