Web form help in Visual Studio 05

[mikeweb]

Hi all, I'm pretty new to this but if someone could help, it would be most appreciated -

I need to create a program where someone can (1) login using a login form (where the username and password is then checked from a database and not store the login details in the web.config file) (2), once logged in, the user can enter customer email address (where the email is checked in the db) and (3), once email address is entered correct, the next screen shows results from the customer (address, phone number etc and this info needs to be read from a db).

I realise the database is more tricky but I'm being taught SQL so I will create the actual db but I just need to know how an html form can connect/read from a database.

If someone could guide me it would be appreciated or if you know of any examples I could download for a basic login system where details of customers are shown that would be great and I could work around that.

Thanks again.

[jamiemac2005]

Hey, in answer to "I just need to know how an html form can connect/read from a database.":

You need to use a server side language, to explain this the server-side language is like a middle man in the HTML->SQL connection...

Something like PHP would work... If you need help getting a basic server set up post back saying so...

But look at this: http://www.w3schools.com/php/php_forms.asp
That shows how PHP can read data from an HTML form, and there are tutorials further down which cover using that data in mySQL...

What flavour of SQL are you being taught? e.g; mySQL, MSSQL, etc.

There's loads of PHP log in tutorials on the web, google is your friend, here's an example: http://www.phpeasystep.com/phptu/6.html
It's quite hard hitting if you've not used PHP but take a look and see what you understand.

I hope that some of that^ was helpful, post back with more Qs if you have them =]

Cheers,
Jamey

[mikeweb]

Thank you for all the info Jamey. I will check out those links.
I'm using SQL Server 2005.

I have recently found quite a good tutorial which I'm running through at the moment: http://www.asp.net/learn/data-access...ial-29-vb.aspx just to give me a basic understanding on connecting to a db.

[jamiemac2005]

Ahh okay, so you're using MS based software... It could be more beneficial to use ASP.Net(As per the link you've posted), staying on that route could work =]

Good luck, post if you have any problems getting this going... Again W3schools have ASP.Net tutes if you really get lost (But that link you posted seems to contain a fair bit =])

Cheers,
Jamey

[calthephenom]

ya, definately asp.net