When do i use the SqlDataSource and when to use dataset?

When do i use the SqlDataSource and when to use datasets?

they both perform select,delete, etc...

so which one is better ?
and if it depends on my needs in the project , then which is better for each situation ?

Datasets are always better and maintained in memory to reuse. SQLDataSource is maintained at page level making it a two-tier object. If you are making a small application this should be fine though.

thank you ,

does anyone have more information on the subject ?

personally, I don't like using SqlDataSources to bind to controls. I actually try to stay away from binding any type of data source to a control through the designer. I feel that I have more control over DataSets(and DataTables) than I do over SQLDataSources.

Thank you.

in my opinion both of them has their own usage. you use dataset to implement Disconnected Data access and you should write code to make something work.but you can implement some functionality using SQLDataSources without even writing a bit of code.

Touraj Ebrahimi [toraj_e] [at] [yahoo] [dot] [com]