Quickest and easiest way to set up a web page to search an SQL database?

Question

I usually only work on system admin projects and software packaging and have little knowledge of web technologies, but I've been given the task of building a simple website that searches an SQL 2005 database from the users input and lists the results. That's it.

Can anybody help me out with some sample code or some such? Since we're a pure Microsoft house, it will be running on SQL 2005 and IIS so I'm assuming I'll need to use ASP.NET, but perhaps my inexperience is leading me down the wrong path.

Any help or suggestions would be much appreciated!

Answer 1

You might want to look at ASP.NET Dynamic Data. This is exactly the scenario it was designed for.