Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 28, 2008 05:14 PM by pettrer
Sep 09, 2007 08:41 PM|LINK
First, let me say that this posting saved me purchasing some rope and a sturdy chair. [;)] Now, my issue. After copying and pasting the code and getting everything to work, I realized that just the first user in the SQL table is allowed to authenticate.
No other person can. Any thoughts?
Sep 10, 2007 08:42 AM|LINK
I'm so glad I stopped you from investing in some rope! ;-) Sturdy chairs, however, are nice to have.
I have no idea why you get this problem, but let me fill you in on what I did. After say 30 more hours of working with the controls I gave up and created them myself, using winforms. It's actually really easy, as long as you just want login functionality -
please tell me if you want to know how it's done.
However, I'd still be grateful if anyone could come up with a workable solution so that we could actually USE the login/create user wizard etc controls, together with an existing db. Conceptually I think it would be a piece of cake, but I have no idea how
to do the actual programming for it.
All the best,
Nov 14, 2007 10:17 AM|LINK
This is great, but the sqldatareader doesn't go any further than the first row!!
Can you please tell me what I'm doing wrong:
Authenticated = SiteLevelCustomAuthenticationMethod(Login1.UserName, Login1.Password)
e.Authenticated = Authenticated
Dr = command.ExecuteReader()
Dec 13, 2007 07:31 PM|LINK
I had the same problem running that code also, I found the problem though (at least I think).
the Dr.Close() and Return boolReturnValue should be outside the while.
If you think about it, it should make sense as the connection is either closed in the first iteration or a return value is returned automatically in the first iteration.
So try moving it out of the while loop and it should work.
Oh and also its missing the close for the sqlConnection, you might want to add that in also
Apr 23, 2008 02:30 PM|LINK
This is a good post, but I found a problem with the following..
The logic is incorrect, and it renders a syntax error..
It should be this:
Apr 28, 2008 05:14 PM|LINK
BTW - over 30,000 views now on this thread - must be some kind of record...