Hi, I have written a C# dll and I have a SQL Db that has three columns (username, password, role). The role element is a class of user eg admin, user; each role needs a different login completion event. The login form I am using is an ASP.net web page that makes calls to the login dll (which in turn connects to the Db and where my validation needs to occur). THe issue I am having is how is the validation done?
Now I have read this article :
http://www.daniweb.com/forums/thread87556-2.html
but that deals with Access Db, not SQL. any ideas ? Thanks for your time!
majestic0110
187
Nearly a Posting Virtuoso
Recommended Answers
Jump to PostFirst, your ASP is the one connecting to the database using the credendials of the web site setup. (Windows authentication mode).
You are to validating the information from the login screen against the database. Just keep in mind that SQL sees the web service as the one logged in …
All 3 Replies
majestic0110
187
Nearly a Posting Virtuoso
JerryShaw
46
Posting Pro in Training
khusiaaaan
0
Newbie Poster
Lusiphur
commented:
New questions in new threads please, don't resurrect dead threads! :)
+0
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.