Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
158 Points
31 Posts
Feb 14, 2010 01:47 PM|LINK
Well you dont have to create the tables .
The profile provider will take care of that .
All you have to do is to add the additional code inside the <!--Anup Hariharan Nair--> section in the web.config file.
Yuor Profile provider will become like the following :
<profile defaultProvider="TBH_ProfileProvider"> <providers> <add name="TBH_ProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> </providers> <properties> <add name="FirstName" type="String" /> <add name="LastName" type="String" /> <add name="Gender" type="String" /> <add name="BirthDate" type="DateTime" /> <add name="Occupation" type="String" /> <add name="Website" type="String" /> <add name="ShoppingCart" type="MB.TheBeerHouse.BLL.Store.ShoppingCart" serializeAs="Binary" allowAnonymous="true" /> <group name="Forum"> <add name="Posts" type="Int32" /> <add name="AvatarUrl" type="String" /> <add name="Signature" type="String" /> </group> <group name="Address"> <add name="Street" type="String" /> <add name="PostalCode" type="String" /> <add name="City" type="String" /> <add name="State" type="String" /> <add name="Country" type="String" /> </group> <group name="Contacts"> <add name="Phone" type="String" /> <add name="Fax" type="String" /> </group> <group name="Preferences"> <add name="Theme" type="String" allowAnonymous="true" /> <add name="Culture" type="String" defaultValue="en-US" /> <add name="Newsletter" type="MB.TheBeerHouse.BLL.Newsletters.SubscriptionType" /> </group> <!-- Anup Hariharan Nair--> <add name="DateOfJoin" type="DateTime" /> <add name="DateOfLeave" type="DateTime" /> <add name="Graduation" type="String" /> <add name="PostGraduation" type="String" /> <!-- Anup Hariharan Nair--> </properties> </profile>
anupharihara...
Member
158 Points
31 Posts
Re: How Do I connect the user data table with custom table
Feb 14, 2010 01:47 PM|LINK
Well you dont have to create the tables .
The profile provider will take care of that .
All you have to do is to add the additional code inside the <!--Anup Hariharan Nair--> section in the web.config file.
Yuor Profile provider will become like the following :
<profile defaultProvider="TBH_ProfileProvider"> <providers> <add name="TBH_ProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> </providers> <properties> <add name="FirstName" type="String" /> <add name="LastName" type="String" /> <add name="Gender" type="String" /> <add name="BirthDate" type="DateTime" /> <add name="Occupation" type="String" /> <add name="Website" type="String" /> <add name="ShoppingCart" type="MB.TheBeerHouse.BLL.Store.ShoppingCart" serializeAs="Binary" allowAnonymous="true" /> <group name="Forum"> <add name="Posts" type="Int32" /> <add name="AvatarUrl" type="String" /> <add name="Signature" type="String" /> </group> <group name="Address"> <add name="Street" type="String" /> <add name="PostalCode" type="String" /> <add name="City" type="String" /> <add name="State" type="String" /> <add name="Country" type="String" /> </group> <group name="Contacts"> <add name="Phone" type="String" /> <add name="Fax" type="String" /> </group> <group name="Preferences"> <add name="Theme" type="String" allowAnonymous="true" /> <add name="Culture" type="String" defaultValue="en-US" /> <add name="Newsletter" type="MB.TheBeerHouse.BLL.Newsletters.SubscriptionType" /> </group> <!-- Anup Hariharan Nair--> <add name="DateOfJoin" type="DateTime" /> <add name="DateOfLeave" type="DateTime" /> <add name="Graduation" type="String" /> <add name="PostGraduation" type="String" /> <!-- Anup Hariharan Nair--> </properties> </profile>Thanks,
Anup Hariharan Nair
http://alterfiction.com/
http://in.linkedin.com/in/anuphariharan