I have created an MS Access table to store Usernames and Passwords plus other information.
I have just started to play around with ASP.NET and am trying to have a situation where a user is required to login to view an image gallery that is run in Flash.
At the Login page the user would type in the username and password, if that is correct I would do another query to grab some param code that is in another column that's part of the users record that I would store as a variable to be passed into the Flash slideshow as a param. Then it loads a particular gallery that only that person can see.
I have this working in classic ASP and would like to have this working on ASP.NET ver 3.5 (my ISP is not on 4.0 yet)
Do I add the connection details in the web.config (root)?
The query to check the credentials in the code behind for the Login page?
Is it a case that I can grab my original code from Classic ASP and drop it into the code behind.
Also my other question, should I use C# or VB, what is the prefered route?
I'm not really after roles or memberships and I have looked at the asp.net conf manager which I dont think helps me. But cookies would be good also.
If you have any code examples or point me in a direction that I could learn from it would be greatly appreciated.