Which Web Template should I use in MS VS 2008 to connect to SQL Server 2008?

Posted on 2012-08-15
Last Modified: 2012-08-15
I need to create an application web site that can connect to SQL Server 2008  database. Both the site and SQL Server reside on an inhouse server; for development purposes, both them and Visual Studio 2008 all reside on my computer still running XP Pro.

I need my app on the website to allow users to upload/download documents, query/update/delete database records with a nice GUI and generate reports.

Which of the 'New Web Site' template should I use?

1) ASP.Net Web Site
2) ASP.NET Web Service
3) WCF Service
4) ASP.NET Reports Web Site
5) ASP.NET Crystal Reports Web Site

I'm an experienced desktop developer using VB and C#, now branching out to web work.

Thanks in advance
Question by:MyNameIsIvan
    LVL 100

    Accepted Solution

    Will the web site include a reporting capability (reports run pulling data from a database)?
    If so you would use 4 for SSRS and 5 for Crystal.

    Are you building a web service (you provide feeds of data to other users or facilitates communication between sites)?
    If so use 2 or 3 depending on the method or sending data and communication

    Most web sites that just present information and allow linking to other sites or pages within the site will use template 1 - ASP.Net Web Site


    Author Comment

    That's great thanks! I'm going with option 4

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now