I'll try to simplify this!
We have an existing Classic ASP site and SQL database. On the old site, the user would log in, and the user's id (int) would get set in a cookie, and then I could show a list of projects associated to that user. Simple stuff.
Select * from PROJECTS where EmployeeID = " & request.cookies("employeeID")
So, now, I'm building a new ASP.NET app, using WebForms, and I've implemented the standard authentication methods that come with it. (It's created all the "aspnet_..." tables, and I created a user using the register.aspx page and it recognizes me, and I can navigate through pages I've created. Cool.)
I can show a list of projects from the existing SQL database, no problem, but I want to be able to show projects for the logged-in user.
The new authentication has nothing to do with the old user ID, so what's the best way to link that info?
Should I add a new "olduserID" field to the ...
Go to the complete details ...