Hello being rather new to VB.net and using VS2008 to design a database (SQL Server 2005 db), I have a few questions and hope I am heading on the right path..

I have been trying to design programatically so have been using a dataadapter.

Am I correct in thinking that a dataadapter is used when designing "programatically" as I am doing already? And that a tableadapter is used with Visual Studio design-time tools such as the Dataset Designer and Data Source Configuration Wizard which then places the binding source, binding navigator and compiles and configures the queries etc?

Which method would be the most ideal? Is there any reason to choose one over the other?

I wanted to learn to design programatically (dataadapter) so I got an idea of how things worked and linked together, I have my created own stored procedures in sql server and call them from VS2008. I dont feel I would gain that experience if I used design-time (tableadapter) tools and wizards. But it would save time?

I found these links which did help, but was just wondering what the general consensus was..use design-time (tableadapter) or use progamatic (dataadaptor) approach?

http://msdn.microsoft.com/en-us/library/ms171919.aspx
http://keithdevens.com/weblog/archiv...3/TableAdapter