Link to home
Start Free TrialLog in
Avatar of demerg
demerg

asked on

ASP.Net 3.5 VB - Login using existing SQL Server table for user and Forms validation

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?

Many Thanks
ASKER CERTIFIED SOLUTION
Avatar of Anurag Agarwal
Anurag Agarwal
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of demerg
demerg

ASKER

Hi anuraq

This is MYSQL not SQL Server and this is not using a built in database it is creating a whole new one.

What I am trying to do is use an EXISTING sql server table which already exists and is linked to most other tables by an exiting USERID#.

If you look at the 3rd paragraph of my question...  If I use the suggested model, how do I tie the craeted database with my exsiting user tables?

demerg