Profile System Asp.net 2005

[vishnu]

I am working on Profile system.I am using CreateUserWizard control for
creating New User.I want to add more information other than
(UserName,Email,Password,ConfirmPassword.....) such as
Country,Gender,Age.So I need to use Profile system.
I added the following code in web.config file:
<profile enabled="true">
<providers>
<add name="AspNetSqlProvider"
connectionStringName="EmailSystemConnectionString" plicationName="/"
type="System.Web.Profile.SqlProfileProvider"></add>
</providers>
<properties>
<add name="Country" type="string"/>
<add name="Gender" type="string"/>
<add name="Age" type="string"/>
</properties>
</profile>
</system.web>
I added the Following code in .cs file
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs
e)
{
ProfileCommon p =
(ProfileCommon)ProfileCommon.Create(CreateUserWiza rd1.UserName, true);
p.Country = "INDIA";
p.Gender = "MALE";
p.Age = "MALE";
p.Save();

}

Code is working fine with out any errors.But After successful Run I
can't see any values under the table aspnet_Profile.Is anything else to
be added.
Thanks
Vishnu Priya

[Peter Bromberg [C# MVP]]

The built-in Profile Provider serializes all Profile properties to opaque
text or binary in a single table column.
If you want discombobulated Profile entries in a typical Database table with
a column for each profile Property, then you need to look at the custom Table
provider and / or Stored Procedure providers.

Example (there are many others):
http://www.eggheadcafe.com/articles/20060731.asp

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"vi****@visrez.com" wrote:

I am working on Profile system.I am using CreateUserWizard control for
creating New User.I want to add more information other than
(UserName,Email,Password,ConfirmPassword.....) such as
Country,Gender,Age.So I need to use Profile system.
I added the following code in web.config file:
<profile enabled="true">
<providers>
<add name="AspNetSqlProvider"
connectionStringName="EmailSystemConnectionString" plicationName="/"
type="System.Web.Profile.SqlProfileProvider"></add>
</providers>
<properties>
<add name="Country" type="string"/>
<add name="Gender" type="string"/>
<add name="Age" type="string"/>
</properties>
</profile>
</system.web>
I added the Following code in .cs file
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs
e)
{
ProfileCommon p =
(ProfileCommon)ProfileCommon.Create(CreateUserWiza rd1.UserName, true);
p.Country = "INDIA";
p.Gender = "MALE";
p.Age = "MALE";
p.Save();

}

Code is working fine with out any errors.But After successful Run I
can't see any values under the table aspnet_Profile.Is anything else to
be added.
Thanks
Vishnu Priya