Need some advice | Student Union

Kirwin
I0I0I

I have created a database on sql server 2005, and i would like to create a web interface that would allow a user to input data into it and be able to query it by maybe clicking a hyperlink that would run the query that i would create(since the users know nothing about SQL). where do i start? any tutorials on this? i tried to google, live, and yahoo but just got lost and confused. thanks in advanced.

evol262

To be perfectly honest, SQL Server 2005 is probably overkill. However --

It's trivial to do with with Visual Studio and ASP. Drag and drop form controls will set up data connectors. Here's one page with an easy example in VB.Net:
http://www.campus.ncl.ac.uk/databases/dotnet/sqldotnet.html

An MSDN example:
http://support.microsoft.com/kb/306574

In reality, you don't ever want to do this. Stored procedures are much safer than letting your users hit the database directly (rarely advisable).

I'm not an ASP developer, but I assume there's some way to separate the database connection logic from the view they can see. Still, this should get you started.

Kirwin
I0I0I

So then what stored procedures would you use to let a user to remotely use the database. The reason i ask is because i created the database for my dad and i would like for him to be able to access it form his work. he usese a laptop and connect to whatever connection is availble. I would love for him also to use a entry form that just lets you enter data and is not that confusing. PS i also have the same exact database created in access.

campusK0der

[Since you did not mention anything about your experience or complexity of your DB, we will start with basics ]

This is where you start:

http://asp.net/get-started

Watch this video:

----------------------------------------
Watch ASP.NET Development in Action

Watch how easy it is to build a “to do” task list application from scratch using ASP.NET 2.0, ASP.NET AJAX, SQL Server Express, and Visual Web Developer.

Microsoft’s Joe Stagner starts by creating a fresh database and the code to access its data. We then see how to define a ToDo List page that displays and updates content in the database. Finally we learn how to add AJAX functionality to the page to improve the user experience. Duration: 20 minutes, 23 seconds.

Watch the video | Download the video | Get VB code or C# code

----------------------------------------

and

----------------------------------------

How Do I:
Create Data-Driven Web Sites? (13:41)

Watch the video | Download the video
Get VB code or C# code

----------------------------------------

If this is too much to do...

then you should look into hosted SharePoint account, upload your Access file and create data lists from it...those can be edited online. $20+/month for most SharePoint hosting.

Kirwin
I0I0I

Thank You very much guys I appreciate the help, and by the way I like to do things myself for the challenge and would never consider hosting, at least for this.

Kirwin
I0I0I

how come you guys did not mention infopath? I just realized that infopath helps you create forms for both access and sql server!!! Office is awsome and should be mentioned on here when it can provide a quick and wasy solution. Also access creates a client application to a database in sql server, ahh intergration at its finest.