Jun 17, 2008 10:27 AM|vinz|LINK
Wizard DataSource such as SqlDataSource are good but For me,I would prefer using the hard-coded dataset over Wizard DataSource because I can write my own logic there. SqlDataSource is good and could be preferred if a simple query is to be generated. But
it tends to get complicated and confusing when it comes to intertwined queries. SqlDataSource is also hard to maintain in case of huge blocks of code and we have to generate umpteen DataSources for different data controls. Where as in the case of hard-coded
sql databind, we can reuse the code without any hiccups changing the basic query here and there according to requirements and It is also a lot easier to maintain it.
These articles below may help you to get started with