Traditionally, ASP has been used to iterate through a rowset, extracting values and placing them in the page. In ASP.NET, the list controls can do this automatically through data binding, and provide a huge performance increase.
Compared to using ASP 3.0 with ADO to create an HTML table explicitly from a
Recordset , ASP.NET with a data-bound
DataList control fed by a
DataReader object using the
OleDb data provider can be three times quicker. Switch to the
Sql TDS data provider and it can be up to five times faster than the ASP 3.0 approach.
If you do need to bind to a
DataSet , use the
DataMember property of the control to specify the table rather than creating a
DataView object first.