Which technology/language(s) for a better data-driven interactive web experience?

Posted on 2006-05-11
Last Modified: 2010-04-06
We're presently running Microsoft Windows 2000 Advanced Server and using IIS to host a website which contains ASP and HTML pages.  Right now some of these pages refer to databases (Access/SQL) on the server to deliver dynamic content to the user, but not on the scale we'd like.  I'm wondering which technology or technologies should be pursued to achieve a more dynamic, robust, live web application.

Some of the features we'd like to provide include both static and drag-and-drop-interactive spreadsheets (a-la Excel pivot tables), dynamic forms, and charts and graphs.  We're looking for a clean and simple interface which doesn't require much of the user.  My present server-side coding experience is with VBScript/ASP.

I know this is a broad question.  I'm open to all suggestions.

Question by:psk1
    LVL 7

    Accepted Solution

    Go with ASP.NET.  This not only is designed to run on a Windows system but also will give you more flexibility in interacting with Excel and other Microsoft products.

    ASP.NET can be written in diferent languages (C#, VB.NET, etc.).

    VB.NET will be most familiar to you since you have been developing using VB in native ASP.

    I too moved from VB/ASP to ASP.NET, however, I learned C#.

    Here are great examples, forums, and free downloadable starter kits to get you going.
    LVL 23

    Assisted Solution

    LVL 2

    Assisted Solution

    Before you dive headlong into the ASP.NET approach, consider spending a bit more time learning and switching over to Java.  I've barely scratched the surface of Java myself, but already I get the distinct impression it has a real future.  Microsoft have never made life easy for developers, and I don't think they're going to start - the fact is that VB.NET is a ground-up, non-backward-compatible rebuild with massive IDE changes and that's just not a nice thing to do to existing developers.

    People have been forsaking MS technologies in droves recently, and with good reason.  I think Java technologies are the best way forward for your project, and trying to migrate to non-MS SQL servers and desktop applications (check out, for example, and PostgreSQL for a nice relational database server) as well as non Microsoft operating systems.

    The way Linux is used, administrated and programmed has changed dramatically over its lifetime, and especially in recent years, but I've never found myself a fish out of water on Unix-like platforms (well, not since I first switched over more then ten years ago).  Switching to a fundamentally different system hurts, but think of it this way: Microsoft delight in making their faithful customers do this time and time again.  With a UNIX-like OS, you know where you stand, and you can have some confidence that if the developers behind it decide to make major changes, they'll bend over backwardss to avoid inconveniencing you.

    When MS launch a new version that invalidates all your existing skills, they make a fortune from selling you the upgrade, then another fortune from teaching you to use it.  When new versions of Apache or PostgreSQL or Java appear, it's generally in the developers' interests to make sure their existing users are kept happy and get the chance to adapt comfortably, without spending on training.

    That's my advice.  Do the slightly harder thing and try to move to open source systems and Java as a development system, and you will be repaid for your work a thousandfold.  You'll have some work in the transition, but you'll be paving the way for better times ahead, where your knowledge still counts for something in the next release and you're not bound to a ridiculous, clunky proprietary system that follows no rules but its own and is built to boost a single corporation's bottom line, not help developers and users.
    LVL 2

    Author Comment

    Thank you!
    LVL 7

    Expert Comment

    mackenga is right, Java is a great language, but having spent a great deal of time developing in both environments, I still promote .NET over Java.  Java is great if your confined to a non windows platform or if your desktop app needs to be compatible with other platforms, but overall, I find it clunky.  If you can, learn both, and you'll be better developer for it.  Ultimately, you'll find what you like best, but please, don't make a decision on platform politics.  Best of luck to you!

    Featured Post

    Course: Create Mobile App Prototypes with Adobe XD

    This is a project-based course: we go through all the steps of creating a prototype from start to finish, using all the tools and features currently available in Adobe XD. You can complete the course in less than a day, plus all project files and fonts are included.

    Join & Write a Comment

    Article by: Matthew
    I am a very big proponent of technology compliance standards and strive to meet such criteria in all of my work. That includes my site, which is 100% XHTML 1.0 compliant as determined by the World Wide Web Consortium. https://www.matthewstevenkel…
    SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
    Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
    Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now