Which tool to build a simple web front-end to my database [closed]

Question

I am a SQL Server DBA and have a database that I would like to access via a web browser. It will be used internally on the intranet and will simply be calling stored procedures in SQL Server to enter data into the database and return data into a simple web page. I am not a developer although I'm pretty good at SQL and scripting with powershell. I may use SSRS later to report on the data.

My question is which is the best tool for a non-developer to rapidly put together a web front end to SQL Server? I was thinking maybe ASP.NET, Ruby, Powershell, PHP, etc. Which is the simplest?

Where should I host the web application? Apache or IIS? I care more about putting something simple together than creating something fancy and flashy. Any suggestions? As you may have gathered I'm after the simplest solution for rapid development, at the cost of something slick and nice looking (there will only be two users, one of them me).

Thanks, Mark.

Answer 1

If you are experienced with SQL Server, I would recommend ASP.NET.

ADO.NET gives you good access to SQL Server, and with SMO, you will also have just about the best access to SQL Server features. You can access SQL Server from other environments, but nothing is quite as integrated or predictable.

You can call your stored procs with SqlCommand and process the results the SqlDataReader and you'll be in business.