Ron,
I'd like to clarify and comment on a few things you said:
>>The data adapter leaves the dta connection open only long enough for the command to be executed.<Well, sorta ... this is true if you do a simple MyDataAdapter.Fill(MyDataSet). However, if you open the connection at all manually (because you're doing transactions or whatever), it will stay open until you close it again.
>>As far as switching from a Windows to a web app, the best methodology is to use an application framework, where the only difference is the ui, while the data access, validation, etc., is outside the ui, so it doesn't need to be rewritten when you change platforms. The best of the app frameworks available now are Mere Mortals and Rockford Lhotka's CSLA frameworks, imho.<While I agree that the best methodology is separating the UI from DataAccess and BizObjects, I don't think using a "framework" implies buying a commercial one. You can roll your own as well.
~~Bonnie