Solved

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

Posted on 2011-02-25
2
461 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

Question has a verified solution.

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

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

695 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