[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2012-08-15
Medium Priority
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 101

Accepted Solution

mlmcc earned 2000 total points
ID: 38295986
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

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

834 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