Sqldatasource and dataset RRS feed

  • Question

  • User-1338140908 posted

    Dear sir or madam

    I have a problem related to using sqldatasource and dataset.I heard that using dataset is faster than using sqldatasource,but I think that in sqldatasource have a DataSourceMode property allowing user to choose to use with dataset or datareader.

    Now,I still wonder why they said that dataset is faster than sqldatasource.


    I look forward to hearing from you.

    Thank you in advance.

    Best wishes,



    Thursday, October 25, 2007 12:21 AM


  • User302303298 posted

    Hi seyha_moth

    by defaulst SqlDataSource control use DataSet, but coz of abstration you dont get to know that.  so its better to dataset as it is or you can change the default behavior of sqldatasource to use datareader which is more faster than dataset.

    hope it helps

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, October 25, 2007 1:07 AM