How to make custom database for Membership
Introduction:
In this article I will explain how to use custom database for Membership in asp.net.
Description:
In one of my project I got requirement like using asp.net membership concept with custom database. First of all we learn what is asp.net membership? And why we need to use this one?
ASP.NET membership gives you a built-in way to validate and store user credentials. ASP.NET membership therefore helps you manage user authentication in your Web sites. You can use ASP.NET membership with ASP.NET Forms authentication or with the ASP.NET login controls to create a complete system for authenticating users.In this article I will explain how to use custom database for Membership in asp.net.
Description:
In one of my project I got requirement like using asp.net membership concept with custom database. First of all we learn what is asp.net membership? And why we need to use this one?
By Using ASP.NET membership we can create new users and passwords and we can authenticate users who visit your site. You can authenticate users programmatically, or you can use the ASP.NET login controls to create a complete authentication system that requires little or no code and we can manage passwords, which includes creating, changing, and resetting them.
Now we will do the step by step process how to use Custom membership database.
1. Go to the Start menu and open Run and enter%WINDIR%\Microsoft.Net\Framework\v2.0.50727\aspnet_regsql.exe and click ok it will open the Asp.net SQL Server setup wizard like this  |
We can get this in alternatively go toC:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe |
In this wizard we have two options
1. Configure SQL Server for application Services
2. Remove application services information from an existing database.
Now select first option Configure SQL Server for application services because first time we are creating database. If you want to delete already created database select second option
After selecting the first option click next now the window like this
 |
After that enter your database server name and select database from existing list or give new name and click next you will see the window like this
 |
After that click next button you now your aspnet membership database installation is completed and now that is ready to use with our application final window like this
 |
Now check your database everything installed and ready to use in our application.
Everything is ready how to use that custom database in our application for that create one new web application and name it as Registration.aspx now drag and drop the one new control CreateUserWizardfrom Login Controls list that aspx page like this
<html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Untitled Pagetitle> head> <body> <form id="form1" runat="server"> <div> <asp:CreateUserWizard ID="CreateUserWizard1" runat="server"> <WizardSteps> <asp:CreateUserWizardStep ID="CreateUserWizardStep1" runat="server"> asp:CreateUserWizardStep> <asp:CompleteWizardStep ID="CompleteWizardStep1" runat="server"> asp:CompleteWizardStep> WizardSteps> asp:CreateUserWizard> div> form> body> html> |
Now open Web.config file and write the following code
Write the connectionstring like this
<connectionStrings> <add name="Connection" connectionString="Data Source=SureshDasari;Integrated Security=true;Initial Catalog=AspMembership" providerName="System.Data.SqlClient"/> connectionStrings> |
After that write the following code in system.web section
<membership> <providers> <clear/> <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider"connectionStringName="Connection" applicationName="SampleApplication"/> providers> membership> <profile> <providers> <clear/> <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider"connectionStringName="Connection" applicationName="SampleApplication"/> providers> profile> <roleManager enabled="false"> <providers> <clear/> <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider"connectionStringName="Connection" applicationName="SampleApplication"/> providers> roleManager> |
After that run your application and create user by using CreateUserWizard
Here functionality of inserting the user details and everything will take care by CreatUserWizard no need to write any coding just set the database and set the conditions in web.config file that is enough. Now your program will work perfectly
Demo
 |