Solved

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

Posted on 2011-02-25
2
455 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:demerg
2 Comments
 
LVL 8

Accepted Solution

by:
Anurag Agarwal earned 500 total points
ID: 34980925
0
 

Author Comment

by:demerg
ID: 34981074
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
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question