title: How to store Mobile Numbers in asp.net Membership c# and SQL
body: <p>I have a web application which stores customer details like username, firstname and email address ... etc...etc.. </p>
  
  <p>I am using Asp.Net Membership, also my web page where i will allow customers to register I'm using CreateUserWizard. </p>
  
  <p>I would like to know how to save customer mobile numbers using asp.net Membership. In my sql table I have all the asp.net membership tables. However wanted to know how to customize the table to allow mobile numbers to be saved into database. </p>
  
  <p>Any ideas?</p>
  
  <hr>
  
  <p>I Have  Custom UserProfile Class where I have setup the mobile property and other properties. How Can I save all the details into separate columns in database??</p>
  
  <p>public class UserProfile : ProfileBase
      {
          public static UserProfile GetUserProfile(string username)
          {
              return Create(username) as UserProfile;
          }</p>
  
  <pre><code>    public static UserProfile GetUserProfile()
      {
          return Create(Membership.GetUser().UserName) as UserProfile;
      }
  
  
      [SettingsAllowAnonymous(false)]
      public string MobileNumber
      {
          get { return base["MobileNumber"].ToString(); }
          set { base["MobileNumber"] = value; }
      }
  
      //Few other properties.....
  
  
  
  }
  </code></pre>
  
  <p>Here is my webconfig settings</p>
  
  <p>     </p>
  
  <pre><code>  &lt;providers&gt;
      &lt;add name="SqlProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="EXAMPLE" applicationName="EXAMPLE" description="SqlProfileProvider for SampleApplication"/&gt;
    &lt;/providers&gt;
  &lt;/profile&gt;
  </code></pre>