Binding tables from database with Login Control

Angaara · March 17th, 2013, 01:07 PM

hi everyone,

I am following the Beginning ASP.NET 4 which is a fantastic edition with clear and complete example of building a full featured website...
However when it comes to login controls i get stuck as the book provides a good example of how to create the whole login system but it does not provide an example of how to bind the login control with a table in database "Preferably with SQL SERVER" so here is my situation:
I want my login control to interact with a login table in database pre-loaded with users names and passwords so when a user logs in it should check the user details against the details in DB...!
I would really appreciate if someone could help me with this and if possible provides an example...

Thanks

Imar · March 19th, 2013, 10:47 AM

Hi there,

Do you mean you don't want to use Membership but your own authentication mechanism? I would recommend against that, but if you have compelling reasons to do so, you can handle the control's LoggingIn event, do your own user validation and then set e.Cancel to to true. But this would also require you make sure the user remains authenticated by the use of a cookie or a session variable.

Some useful links:

http://msdn.microsoft.com/en-us/libr...loggingin.aspx

https://www.google.com/#hl=nl&sclien...w=1920&bih=931

Cheers,

Imar

Angaara · March 19th, 2013, 11:05 AM

Dear Imar:

First of all : Thank you so much by replying to my query...
Secondly : Thanks you so much for providing such a simple, understandable books which is really motivating even people who are no very interested with IT specially programming or web development...

Regarding my previous post:
I am working on a project where i am uploading a list of people to database table where i have to provide them with initial login id and password which i have done all of these through my own validation etc... but when it come to security i was not sure if that was the right way but when you mentioned you will not recommend it then it means it is weak so :
is there a way if i could configure the already built in controls and provide my users initial login details? An example would really help me

Thanks

Imar · March 19th, 2013, 11:12 AM

Hi there,

Is it an option to create the users in the Membership system? That would be the quickest and safest way to do i. Building your own login system has risks involved, that are typically already covered with the built-in Membership system.

You can create a user using the Membership API like this:

Code:

Membership.CreateUser("UserName", "Password")

Quote:

Thanks you so much for providing such a simple, understandable books which is really motivating even people who are no very interested with IT specially programming or web development...

You're welcome. Good to hear you like the book so much.

Cheers,

Imar