Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 login form

Author  Topic 

jhermiz

3564 Posts

Posted - 2004-08-29 : 16:33:37
When developing in C++ / VB I usually have just a text box for user name and a text box for password. Then the click event of a button I connect to my SQL Server db..goto the correct table, and SQL or check if that user exists in a Logins table.

Can I basically do the same for an ASP.net page. I basically need to:

1) Create a page with these two boxes
2) Have the user click a submit button
3) Make a connection to sql SERVER db
4) Check if the user exists in a log in table

Are there any examples of this online with a SQL Server db?

Thanks,
Jon

Jon
www.web-impulse.com

Can you dig it: http://www.thecenturoncompany.com/jhermiz/blog/

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-08-29 : 17:08:49
Helpful, dunno, maybe:

[url]http://www.socalnetug.org/reference/ASPsecurity/ASPNETsecurity.pdf[/url]

Also I go to [url]http://www.codeproject.com[/url] for code.

/rockmoose

/* Chaos is the nature of things...Order is a lesser state of chaos */
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-08-30 : 01:32:33
Some really good sites to learn the ropes:

http://aspnet.4guysfromrolla.com/ (lots of easy-to-read articles and links)
http://www.aspfaq.com/ (for all your hows and whys)
http://www.asp.net/Tutorials/quickstart.aspx (go through all of these if you havent already)
http://www.asp.net/Default.aspx?tabindex=8&tabid=47 (the best way to learn - download the Commerce starter kit and go through all the code in it)

OS
Go to Top of Page

samuelhon
Starting Member

5 Posts

Posted - 2004-08-31 : 05:26:03
Hi

I think this example [url]http://support.microsoft.com/?kbid=301240[/url] might be useful.

Are you going to be coding in C# or VB.NET?

Sam
Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2004-08-31 : 05:37:44
The code for this would be virtually identical to normal VB, except that the ASP page would present itself in two different ways.. one would be if there were no variables in the posted data, in which case it would present empty boxes, and the other would be if there were variables, in which case it would go away and check the details.

-------
Moo. :)
Go to Top of Page
   

- Advertisement -