I will be placing SQLDataSource examples here shortly.
I know there is controversy relating to placing SQL or even Stored Procedure names in .aspx files, but the reality is that for some applications, there is no need to concern ourselves with the complexities related to N-tiered, fully-abstracted, technical-utpoia development. This is especially prevalent when the resources working on an implementation do not have the background or ability (for a variety of reasons not always their own doing) to deliver solutions with these concepts intact each time. Certainly, Microsoft must have agreed as they allow/support this approach. None-the-less, feel free to engage in healthy discussion here. And I hope this area will be useful for those who know the pros and cons, and make the educated decision to use the SQLDataSource inside their .aspx pages.