Solved

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

Posted on 2011-02-25
2
454 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now