Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 28, 2008 05:14 PM by pettrer
Oct 17, 2006 05:50 PM|LINK
I'm trying to use the login features with an sql server 2000 db. So far it hasn't been a pleasant ride. Before I go on trying - does anyone know if they are compatible at all?
Oct 17, 2006 08:17 PM|LINK
Easy way: Click Website/ASP.NET Configuration. Will do the work for you
Oct 17, 2006 08:31 PM|LINK
Yes, thanks, but what I'm asking is: Does Sql Server 200 work with WVD Express and asp.net 2.0 or do I need Sql Server 2005 for anything in specific?
Thanks for your reply,
Oct 17, 2006 09:03 PM|LINK
Oct 17, 2006 09:30 PM|LINK
Minutes ago, I actually could see that for myself, for the very first time!!![:D]
I simply used the code from here
http://www.c-sharpcorner.com/UploadFile/sushmita_kumari/Logincontrol101312006002845AM/Logincontrol1.aspx?ArticleID=c33d0072-8f7c-4958-a7dc-ca1809737193 - which provides the code for a login control using a table of one's own. I made a VB version of it -
here it is in case someone wants it (passwords etc altered of course):
This is the complete aspx file:
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
This is the complete codebehind file:
Partial Class _Default
Protected Sub Login1_Authenticate(ByVal sender
ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs)
As Boolean =
Authenticated = SiteLevelCustomAuthenticationMethod(Login1.UserName, Login1.Password)
e.Authenticated = Authenticated
If (Authenticated =
Private Function SiteLevelCustomAuthenticationMethod(ByVal UserName
As Boolean =
As String =
"Data Source=sql.bjorn.se;Initial Catalog=db0544;Persist Security Info=True;User ID=du0457;Password=Khgfh5hgf"
Dim Connection As SqlConnection =
Dim strSQL As
String = "Select * From Main"
Dim command As SqlCommand =
New SqlCommand(strSQL, Connection)
Dim Dr As SqlDataReader
Dr = command.ExecuteReader
If ((UserName = Dr("user").ToString) _
And (Password = Dr("pwd").ToString))
boolReturnValue = True
I hope I brought something back to the community this way.
Now a question again - one's down, there are many to go, I guess; Login is fixed but the other login-related controls must have similar code, won't they? What about the code for, say, a CreateUserWizard control? If you can point me in the right direction,
I'd be grateful. Otherwise, thanks for your kind help so far.
From Sweden with love,
Oct 17, 2006 09:44 PM|LINK
You'll find them all on the toolbar under LOGIN CONTROLS, drag and drop. If Login is:
Oct 17, 2006 10:32 PM|LINK
I seem to not make myself very clear tonight. :-)
What I meant was that I need to create the codebehind stuff coding for the rest of the login controls...
Oct 17, 2006 10:40 PM|LINK
I'm working on the CreateUserWizard now and I think I got it working somewhat (will post it when it's ready for others) but I have a strange problem - I don't seem to be able to write to the db, and still get no error message! Ideas perhaps?
Here's the thread describing it: http://forums.asp.net/thread/1431692.aspx
Oct 17, 2006 11:38 PM|LINK
You've got an interesting blog, by the way! I agree with you on Telerik's superiority, but as far as ajax goes, atlas does the job + it's free... Sorry to be OT.
Oct 18, 2006 05:15 AM|LINK
Actually Telerik wraps around Atlas enginee but with their controls, and those controls are very poweful, the combobox is the best control out there, still uses Atlas.
Atlas is great, but the controls are pretty poor, only use atlas as the UpdatePanel do not use extenders!