| Author: gomathinayagam 17 Oct 2008 | Member Level: Gold | Rating: Points: -20 |
The ASP.NET profile is used to store and retrieve user settings in a data source such as a database. The user profile is accessed using the Profile property of the current HttpContext. Profile information and property values are managed using a profile provider.
The SqlProfileProvider class is used by ASP.NET to store and retrieve profile settings for an ASP.NET application that is using a SQL Server database. To use a SqlProfileProvider, you must first create the SQL Server database used by the SqlProfileProvider. To create the database used by the SqlProfileProvider, run the aspnet_regsql.exe tool, which is found in the [drive:]\WINDOWS\Microsoft.NET\Framework\versionNumber folder, and specify the -Ap option. The following command demonstrates how you might use the aspnet_regsql.exe executable:
aspnet_regsql.exe -Ap
refer : http://msdn.microsoft.com/en-us/library/system.web.profile.sqlprofileprovider.aspx
or u need more details soultion with example here some codeproject link. the author inherit the sqlprofileprovider and make his own mysql profile provider. go through it :
http://www.codeproject.com/KB/database/mysqlmembershipprovider.aspx
Gomathi Nayagam
Please Rate my answer if it has helpful to you
|