ASP.Net 3.5 VB - Login using existing SQL Server table for user and Forms validation
Posted on 2011-02-25
I am just learning ASP.Net 3.5 VB and require assistance with login/security setup.
I have an existing user table in my SQL Server database which I would like to use for forms authentication in my ASP.Net 3.5 VB application. The UserID# from this table is required as it is used throughout the application to query various areas of the SQL Database to view, add and edit records.
Most of the on-line tutorials show how to use built in SQL Server datasets to authenticate user information but this does me little good as I cannot link these with my existing user information required in the application.
Can anyone provide or recommend example VB code of a Login setup using existing SQL Server tables for forms validation as well as the Web.config script to make it all work?