• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • Last Modified:

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
1 Solution
Anurag AgarwalCommented:
demergAuthor Commented:
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?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now