Question Learning 3 Tier Design and need opinion

[ts9700]

Hello,

Just joined 10 minutes ago and this is my very first post!

I'm trying to teach myself how to create an ASP.Net 3.5 web application using VB 2008 in VS 2008 with a SQL Server 2008 database using stored procedures. And using a 3 Tier Architecture with business object.

I've never tried anything this ambitious. Use to do only simple VBA code in access. So I'd really like some opinions and guidance.

Naturally, I'm trying to learn the hardest thing first as punishment.

If there is something I should be doing, I'd love some feedback! And what I'm doing right because I've got a feeling my ego will be bruised. Did I mention I'm almost a senior citizen?

Thanks

View attachment MyCode.pdf

 

[jmcilhinney]

If you want to learn separation of concerns in ASP.NET then you should forget Web Forms altogether and go straight to MVC. You can download the ASP.NET MVC Framework and start building MVC applications in VS 2008. If you aren't aware, MVC stands for Model-View-Controller. Basically, the Model is your Data Access Layer, the Controller is your Business Logic Layer and the View is your Presentation Layer.

ASP.NET MVC: The Official Microsoft ASP.NET Site

 

[MattP]

I'll give you several options so you can give them a look and see where you'd like to jump in.

Here's the official web-forms data access tutorials: http://www.asp.net/web-forms/data (I went through this entire thing when I was originally learning and there is some very thorough and quality information here)

Here's a nice MVC tutorial: http://www.asp.net/mvc/tutorials/mvc-music-store-part-1 (probably accessible to from jmcilhinney's provided link and a well thought out tutorial for novices learning the ropes)

You may also want to look at using the MVVM (Model-View-ViewModel) pattern rather than MVC: http://aspnetmvvm.codeplex.com/ (I spend most of my time in Silverlight so I'm partial to this pattern.)

Another MVVM article: http://blogs.microsoft.co.il/blogs/helpercoil/archive/2010/08/28/asp-net-mvc-and-the-mvvm-pattern.aspx