Security :: Which Table Is Used To Store Extra Profile Fields With ProfileCommon

Jul 18, 2010

I added extra fields into web config like this :

<profile enabled="true">
<add name="FirstName" type="string"/>
<add name="LastName" type="string"/>
<add name ="HomeAddress" type="string"/>

View 2 Replies

Similar Messages:

MVC Use An Extra Table To Store User Profile?

Dec 27, 2010

ASP.NET MVC Can I use an extra table to store user profile? And how to do that?Something I've done here:I have a database table has userId name, email, password stuff.I want to use all the information in this table for user authentication, and also for user profile. How can I do that in Mvc2 project

View 1 Replies

Security :: Profilecommon - In Which Table Store Data

Mar 6, 2011


In which table is stored data "dejan"?

View 2 Replies

Security :: Extend Default Profile Fields Into Second Custom Table

Apr 23, 2010

I am trying to use a second (custom) table to extend my users profile info. This table is in the same database as the 'aspnet_Users' table but has a different name. I create a FK relationship between the 'aspnet_Users' table and my custom table. Here is my web.config code:

<profile defaultProvider="AspNetSqlMembershipProvider">
<clear />
<add name="AspNetSqlMembershipProvider"
applicationName="/" />
<add name="MyCustomProfile"
table="MyProfileTable_Employees" />
<group name ="MyProfileInfo">
<add name="FirstName" type="string" defaultValue="[null]" customProviderData="FirstName;nvarchar" provider="MyCustomProfile" />
<add name="LastName" type="string" defaultValue="[null]" customProviderData="LastName;nvarchar" provider="MyCustomProfile" />
<add name="EmployeeNumber" type="int" defaultValue="[null]" customProviderData="EmployeeNumber;int" provider="MyCustomProfile" />

I have the table "MyProfileTable_Employees" poplulated with data the 'userid' matches to the aspnet_Users table. In my web application (vb), when I type in Profile.MyProfileInfo, there are no custom fields. Actually, when I type profile., there are no profile related entries. What am I missing here? Am I miss-interpting what a custom profile provider is?

View 2 Replies

Security :: CreateUserWizard With Extra Profile Info?

Sep 23, 2010

I'm using the CreateUserWizard and it's working great. I do have a "step2" that asks the newly created user their first name and last name. Seems simple enough, but I'm getting an error on the Profile.Save(): "This property cannot be set for anonymous users". I'm assuming this is due to the fact that I have DisableCreatedUser="true" for the CreateUserWizard, which is what I NEED to do. Does this mean that until we enable this user, they can't add these few columns? Since the site I am updating requires matching a newly registered user to an already existing "Artist" table, it's important that the administrators are given the first and last name of the user. The aspnet_User table doesn't have that, so I thought I'd give the profile a try.

View 3 Replies

Security :: Remove Fields From The C# Profile Provider And Database?

Mar 25, 2010

I have an issue where I am running out of database space on my hosting provider. As it turns out, the aspnetdb database is more than 6x our application database. We are using anonymous profiles and there are 21 fields stored in each user profile.

Upon analysis, most of this data is not required to be stored - it is simply wasting space. The part that is wasting the most space (5 binary objects) are not even used by any of the public users. I would like to remove these binary objects from all of the user's profiles without deleting the profiles, but I can't seem to find any documentation on how to do this.

I can remove the fields, which will take care of users going forward, but I need to retroactively delete these fields from the aspnetdb database to free up space. Since each user manages their own profiles, I am unsure how to create an automated procedure to delete these fields out each anonymous user's profile.

View 1 Replies

Security :: Reading Custom Profile Fields From DropDownLists Failing?

May 8, 2010

So I'm using the CreateUserWizard tool, which is working great, and have added a few custom fields to the user's Profile, which is also working great... with one exception. The fields that I'm capturing from TextBoxes are being saved to the database perfectly. But those I'm trying to capture from DropDownLists aren't being saved. No error is taking place, either in my code or at runtime, but no data is being written to the table from these particular fields.

I thought I knew how to capture data from a DropDownList in ASP.NET (I'm a newbie, but not ridiculously so), but I've tried a bunch of stuff here and nothing seems to be working. I'm posting an abbreviated version of my CreateUserWizard1_CreatedUser function below, with comments...

protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
//Get the profile of the user by finding the profile by name
TextBox oUserName = (TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("UserName");


View 2 Replies

Security :: Changing Aspnetdb To Store User Profile Information?

Feb 19, 2010

I need to know how to change aspnetdb to store profile information unique to each user so that I can restrict records in an sql table to only show that user's records.

So if I make a "companyID" int, identity column where would I put it?

Also, when I write the where clause to companyID = profile (companyID) would that work?

View 1 Replies

Security :: Add An Extra Field Id_domain In Table Aspnet_memebership?

Mar 6, 2011

I have to add an extra field id_domain in table aspnet_memebership.

How can I save data in another field? Is it possible with LINQ?

I have an additional table tbl_employees. At the same time I want to save the data in the table tbl_employees and the table

View 2 Replies

Security :: Practice To Maintain A Separate Usert Table And Add Fields To The Aspnet_Users Table?

Apr 14, 2010

If I am going to use the membership and roles, the database includes an aspnet_Users table that has the userid and email address. If I have custom fields is it best practice to maintain a separate usert table and link on user id or to add fields to the aspnet_Users table?

View 1 Replies

Security :: Creating New Profile Table And Getting Information

Feb 25, 2010

In my application I am using the aspnetdb membership for authorizing users. I created a new table UserProfiles that will hold their profile information. The UserID is linked to aspnet_users UserID with a foreign key. One of the columns in the table represent CompanyID (int). I want to be able to restrict logged in users to only see records from their company based on the CompanyID. There can be more than one user with the same CompanyID to the UserID would not work. I can restrict their access by UsedID to only see records they created by using code behind:


and my select statement is:


How would be the best way to restrict the selected data to UserProfiles.CompanyID?

View 5 Replies

Security :: Using The SQL Table Profile Provider In C# 4 Web Applications?

Sep 6, 2010

Just an FYI for those trying to use the SqlTableProfileProvider in a Web application project. Here's my article:

Using the SQL Table Profile Provider in ASP.NET 4 Web Applications (C# & VB)


The complete projects are here:


View 2 Replies

Security :: Table Profile Provider Samples Created By Hao Kung?

Jul 1, 2010

I created a table named Thread to store logged-on users' comments. It has CommentId, Topic, Comment, CreatedTime and UserId columns. I made CommentId as the primary key and UserId as the foreign key to the UnserId in the Membership table aspnet_Users.But when I insert those data into table Thread, I get an error "Cannot insert the value NULL into column 'UserId', table 'ASPNETDB.dbo.Thread'; column does not allow nulls. INSERT fails.The statement has been terminated." I have tried different ways to resolve this, but could not make the UserId in the table Thread match the UserId in table aspnet_Users. Yesterday, I found the Table Profile Provider Samples created by Hao Kung at It should be be able to solve my problem. But the code was written in C#. Is there anybody who knows a VB version of this code, or a better way to solve my problem?

View 2 Replies

Security :: Profile Is Not Saving In Aspnet_profile Table Besides Using Save Method?

Jul 27, 2010

I am using profiles it works fine but it is not saving in aspnet_profile table besides using save method

In Web Config:

<profile enabled="true" defaultProvider="SqlProvider">
<clear />
<add name="SqlProvider"
applicationName="AJAXEnabledFor Master Page"/>
<add name= "FirstName" />
<add name= "LastName" />
<add name= "Address1"/>
<add name= "Address2"/>
<add name= "City"/>
<add name= "State"/>
<add name= "Country"/>
<add name= "PinCode"/>
<add name= "Contact"/>

In Code Behind File

if (CreateUserWizard1.ActiveStep.Title == "Complete")
Roles.AddUserToRole(CreateUserWizard1.UserName, "Guest");
ProfileCommon p = (ProfileCommon)ProfileCommon.Create(CreateUserWizard1.UserName, true);
WizardStep Details = CreateUserWizard1.FindControl("Details") as WizardStep;
p.FirstName = ((TextBox)Details.FindControl("TextBox1")).Text;
p.LastName = ((TextBox)Details.FindControl("TextBox2")).Text;
p.Address1 = ((TextBox)Details.FindControl("TextBox3")).Text;
p.Address2 = ((TextBox)Details.FindControl("TextBox4")).Text;
p.City = ((TextBox)Details.FindControl("TextBox5")).Text;
p.State = ((TextBox)Details.FindControl("TextBox6")).Text;
p.Country = ((TextBox)Details.FindControl("TextBox7")).Text;
p.PinCode = ((TextBox)Details.FindControl("TextBox8")).Text;
p.Contact = ((TextBox)Details.FindControl("TextBox9")).Text;

View 1 Replies

Security :: ProfileCommon Object Not Getting Instantiated?

Feb 17, 2010

I am getting an object not instantiated error on a production environment only when trying to execute the following code.


<profile defaultProvider="ProfileProvider" enabled="true" automaticSaveEnabled="true">
<providers> [Code]....

View 1 Replies

Security :: Website Can Call ProfileCommon From A DLL?

Feb 4, 2011

I am trying to use ProfileCommon inside a DLL. this DLL is being called by ASP.NET web application.

I am getting this:

Error 15 The type or namespace name 'ProfileCommon' could not be found (are you missing a using directive or an assembly

View 1 Replies

Security :: Transfer ProfileCommon Context To Authenticated User

Feb 7, 2010

I currently have a ProfileCommon enabled on my site and would like to know where I would start to transfer this ProfileCommon's context to a user's profile after he/she has logged in. Here is a snippet of how I have defined this ProfileCommon:


View 2 Replies

Preventing Extra Fields From Being Added To A Form

Mar 10, 2011

I realize what I am trying to do is a little unconventional; but I want to make my search SEO. Basically I want the query string resulting from my search to be human readable; if I was doing straight html this would be cake:

<form method="GET"><input type="text" name="Zip" /></form>

I realize that I can change the form method in, however, all the state holders show up in the query string. I even tried disabling viewstate and removing all javascript submitting controls (to get rid of __EVENTTARGET) to no avail.

The thing is, I really want to keep using the same master page as I do in the rest of the site; does any one know of anything I can do short of building the page from scratch?

View 1 Replies

Multilevel Gridview Showing Extra Fields

Apr 4, 2014

I am making a leave management program in using c#. Im having a problem on my multilevel gridview where it show all the fields i called in a query but I only specifiy some columns to be shown in a label using Bind

Here is my code for my design

<asp:TemplateField HeaderStyle-BorderStyle="None" ItemStyle-Width="10" ItemStyle-CssClass="tRight" ItemStyle-HorizontalAlign="left">
<img title= "View Details" style="cursor: pointer" src="../Images/plus.png/"/>
<asp:Panel ID="pnlRegDetails" runat="server" Style="display:none;"> <!-- Plus sign panel -->
<div style="padding:2px 2px 2px 2px;">

[Code] .....

And here is my code in c# in code behind

protected void bindLeaveApplication6()
int cutoffid = getCutOffID(cboCutOffSelect.SelectedValue);
using (SqlConnection conn = new SqlConnection(DAO.ConnectionString))

[Code] ....

View 3 Replies

Security :: Creating A Profile For A New User Is Updating Other Profile

Feb 4, 2010

I am logged in as user1, and while creating a user in which I have additional information which would store first and last name into the profile database. I have the following code


But because I just have profile like that, it is updating the profile of user1 not the new user i just created


View 5 Replies

Security :: Want To Use Profile And Have A Profile Property?

Dec 5, 2010

I'm being stupid but don't know what I'm missing.I want to use profile and have a profile property.So in the webconfig for my site I've added:

<add name="Name"/>

But in the code behind a page I cannot use Profile.Visual Studio is just saying the Profile is not known in the current context.Thus I cannot do

Profile.Name = ....
x = Profile.GetPropertyValue(....)

View 13 Replies

Security :: Get User Info With Custom Provider - Use Provider With Profilecommon?

Apr 16, 2010

I try to get the user profile settings with this code. But all items in it are empty, in the database they are not empty. So there is going something wrong. First of oll how can i add a provider to the ProfileCommon ? Maybe i'm there then... the usrInfo is filled well...

MembershipUser usrInfo = Membership.Providers["MyMembershipProvider"].GetUser(UserName,false);
ProfileCommon prf = (ProfileCommon)Profile.GetProfile(UserName);
LitNaam.Text = prf.Voorletters.ToString() + " " + prf.Achternaam.ToString();

View 2 Replies

Trying To Implement Custom Profile Fields In Visual Studio 2008 Web Application Project?

Mar 18, 2010

I've been working on this for a while now and nothing has been a bigger pain in I'm trying to implement custom profile fields in my visual studio 2008 web application project. I've read a lot of tutorials but they all seem to be either out dated or don't apply to web application projects. Last night I got a little closer to solving the problem when I found the "Web Profile Builder" for web applications. I've successfully set this up and can handle static profile data.I've got my web.config file setup and I can access my custom profile fields by Profile.CustomField. Now I want to figure out how I integrate this with the database and data connection. I know there are two standard ways to handle this, I would like to create new columns in the aspnet_Profile database (rather than the delimited key/value option).I'm pretty new to and this is my first project with c#, .net, and asp.

View 3 Replies

Security :: Userid Of Newly Created User / To Store Additional Details Of The User In Another Database Table

Nov 10, 2010

Our application lets the administrator create new users. Since the administrator is logged in, I have set Logincreateduser = false so that the administrator is not logged out even after creating the new user.

The problem is :I need the userid of the newly created user to store additional details of the user in another database table. I see that i can get the username using Createuserwizard1.username; but how do I get the userID?

View 2 Replies

DataSource Controls :: Copy Data From One Table And Insert With Extra Values?

Jan 27, 2010

Is there a way to copy a row from one table and insert to another but at the same time insert extra values to destination table?Let's say source table Item has values:


Destination table ItemHist:


I want to copy row from source table where itemid is 25, insert it into destination table and add extra values: ChangeDate, ChangeReason, ChangedBy. I tried:

INSERT INTO ItemHist (ItemID, ChangeDate, ChangeReason, ChangedBy, ItemType, ItemModel) VALUES (ItemHist.ChangeDate=GetDate(), ItemHist.ChangeReason="why not", ItemHist.ChangedBy="me")
SELECT ItemID, ItemType, ItemProducer, ItemModel FROM Item WHERE ItemId=25

but obviously it didn't work ("The name 'ChangeDate' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.").

View 4 Replies

Copyrights 2005-15, All rights reserved