.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

I created a user profiles table, now what?

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :ASP.Net
 

I'm using the ASP.NET Configuration tool to add User management to my application.  I didn't like how the aspnet_Profile table stored all user profile info as blobs of information though.  I prefer having each profile value as a separate column in a db table.  So, I went ahead and created a table with a few columns, including the UserId uniqueidentifier column that I want to link back to the aspnet_Users table.  I set up the relationship between the Users table and my profile table as a 1 to 0..1 relationship.

What I'm stuck on right now is how do I initially create the profile record so I can use it for editing it's values.  When a user registers to my application, I want a new record to be created in my Profile table with the UserId to be the same as it was created in the Users table.  I'm totally stumped though.  A new record in my custom profile table should populate with a UserId, so when I choose to update the profile, it has a reference to which profile record to update.  So, how can I get this record with UserId to be created when a user registers?




View Complete Post


More Related Resource Links

Unable to search Custom User Property Created in User Profiles in SharePoint 2010

  

Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise


Configuring User Profiles in SharePoint Server 2010

  
Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

Cutting Edge: Personalization and User Profiles in ASP.NET 2.0

  

Personalization is growing to be more and more of an essential ingredient in many types of Web apps, including portals and shopping sites. Without it, it's quite difficult to serve your customers efficiently.

Dino Esposito

MSDN Magazine October 2005


want to launch modal Popup from created User Event handler

  

hi,

 

I have a create user wizard on my page and in the event handler (Created User) I get extra information from the user

via textboxes within the aspx etc.

 

I then do a response.redirect to another page.

What I want to happen is this

 

When the CreatedUser Event is fired, I  want a Modal Popup to show up with a message Processing your registration.

once the registration code is processed it will close and the users get redirected.

 

On my ASPX I have the Modal PopUp and a Panel.

In the code behind in the handler I put ModalPop.show()

 

but this does not work.

 

thanks for any suggestions

 

 


file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?

  

Hi,

In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.

 

 

I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?

 

     <CustomNavigationTemplate>
          
                       <div>
<br />

  <asp:UpdatePanel ID="UpdatePanel2" runat="server">
                <ContentTemplate>  


  <asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
                                            Text="Submit my Profile" />
   

How to fill out a form as another user , while using profiles database

  

I have created an InfoPath 2007 form. It works great.. I have 5 data connections to sharepoint lists and profile's database. The form displays public data (profile database) about the user, such as name, manager.. etc.

What I would like to do is have an option on the form that says " If you are not this person , click here" , manually type the persons last name , and bring up their information.

Basically , there are some people who will have someone else fill the form out for them. But I don't want them to be giving out their username and password to the system.

I want the ability to fill out a form as another user without logging off sharepoint. 


=User!UserID from windows authentication using table from another database

  

hi,

i'm using sql server 2005, sql server business intelligence development studio for my reports and deploy them in my wss3.0 site.

what i'm trying to do is i'm trying to restrict wich users can see specific data within a report.

now, the thing is. the report gets the data out of my DB1 database and my windows authenticated user are in the WSS_content database.

when i deploy my report in my wss3 site. it gets the user that is loged in. but of course it does not display any data because the tables are not in the same database.

does someone knows how to do this?


BDC User Profiles

  

HI I have a database table which has three columns "username", "certificate" and "date_objected". One employee have multiple certificates.

in the User Profiles I want to mapped with username and display all certifcates that this employee have.

Anyone have any suggestions/samples on how to do this? I was able to display one-to-one fields but I am stuck with one employee to display multiple rows.

Any good samples out there?


Why my BDC is not importing new profiles from DB table?

  
I have 72000 profiles records in SSP profiles database. I connected this BDC with SQL table. SQL table has 81000 records. When I do full Import it is importing only 72000 records only, not complete 81000 records. How to get them into SSP?
Jamsbond

Crawler fails to register date properties of user profiles with the month of January, April, August

  

This seems to be a bug when the crawler search the user profiles in MOSS 2007.  When crawled, user profiles with a SPS-HireDate in the months of January, April, August and December will be detected, but a full-text (SQL) search returns those profiles without the HireDate field.

User profiles with HireDates in other months work correctly, returning the HireDate in the search.  And changing the month of a problematic user profile also fixes the problem.

This problem is also reflected in the fact that while we have 499 user profiles using the SPS-HireDate property,  the managed property page from the search section only has 350 items with the HireDate property.

We're running MOSS 2007 32bit with SP2 with an English language base and the Spanish language pack. I'd considered date format problems, but I can't imagine how some months would work, while others wouldn't.

Any ideas?


Creating a table-valued function on a user defined type in SQL Server CLR

  
We would like to be able to create a table-valued function on a user defined type.  We would like the syntax in SQL to look like it works for the XML nodes function:   DECLARE @myXml XML = '<a><b>1</b><b>2</b><b>3</b></a>' ; SELECT  node.query('text()') FROM    @myXml.nodes('a/b') nodes (node) ;   In other words, in the FROM clause, we can access the "nodes" method of the xml variable and it returns a rowset. Thanks!

how to include a user defined table type as input for stored procedure

  
Hi ,  I have a user defined table type which i need to pass as input parameter to the stored procedure .How can i do that?

Access a user created class in the form code

  
Hi Dear i have a litle problem i am developing a database application. In this app i write made two projects in the same solution. 1st named BussinessData and the 2nd one has a name Database Application. in business data i have add a libary class and made its region for easily code writing. now i want to get access at that class code from the application form code. example: sum of two numbers pubic class Sum #region "Public variables" dim a,b,c as integer #end region ' seperate region for getting values #region "Properites" public property a() as integer Get  return _a Set (by val value as sender)         _a=value end property #end region 'region for sum #region "Methods" public function sum() as integer c=a+b return c end function #end region in this way i have written the code and i want to get access this class from the form code. 'button_click code for the sum sum() plz help me to solve this problem  

how i can access a user created class in form code

  
Hi Dear i have a litle problem i am developing a database application. In this app i write made two projects in the same solution. 1st named BussinessData and the 2nd one has a name Database Application. in business data i have add a libary class and made its region for easily code writing. now i want to get access at that class code from the application form code. example: sum of two numbers pubic class Sum #region "Public variables" dim a,b,c as integer #end region ' seperate region for getting values #region "Properites" public property a() as integer Get  return _a Set (by val value as sender)         _a=value end property #end region 'region for sum #region "Methods" public function sum() as integer c=a+b return c end function #end region in this way i have written the code and i want to get access this class from the form code. 'button_click code for the sum sum() plz help me to solve this problem

User Profiles Service Application and Import of SharePoint 2007 SSP data

  
I have setup a test SharePoint 2010 Farm. I will be using this as a test upgrade of a current live SharePoint 2007 Farm. The database attach method will be used. I have replicated the web application and AAM settings of the SharePoint 2007 Farm to the SharePoint 2010 Farm and have made the 2010 Farm a DC in a new Forest. I don't want to join this to the current domain at the moment. It also has SQL server 2005 with SP3 and cumulative update 3 installed. I have just setup the User Profiles Serice Application and when I go to Manage it, I get this. Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: a1760e87-372f-4711-afac-3ceba34bc599 Date and Time: 8/31/2010 4:22:56 PM I have verified and configured the following. Created the Managed Metadata Service. The status is started via Service Applications and Services on Server. Created the User Profiles Service Application and ensured status is started via Service Applications. I started the User Profile Service and User Profile Synchronisation Service via Manage Services on Server.      

SharePoint 2010 Server: Cannot manage all user profiles from upgraded MOSS SSP database

  
I have upgraded an SSP database to SharePoint 2010 and successfully performed User Profile Synchronization with Active Directory, however I cannot manage ALL of the user profiles in the database. I go to "Manage User Profiles" in Central Administration and perform a filtered search (i.e. I want all DOMAIN accounts beginning with "j" so I search for "DOMAIN\j" in Manage User Profiles), but I don't receive ALL the user profiles back. I receive about 8 in return when I know there are about 20 starting with "j". If I create a new AD account beginning with "j" it is successfully synched with SharePoint 2010 and I see it in the Manage User Profiles. I ran an stsadm -o sync to clear any old synchronization information, and the Forefront Synchronization Service appeared to pull in many changes to existing accounts (including ones I can't currently manage), but I still cannot manage them using "Manage User Profiles". I really need to be able to manage all the profiles so I can manually edit some fields. Can anyone please help? Thanks in advance.

New SP 2010 Installation - Can't Get User Profiles / Outlook / My Site stuff working.

  
Hello,   I have a new SP 2010 Installation. I did NOT set it up in Standalone mode. My users can log in and create their own My Sites. They can edit them, add content, etc. When using Outlook 2010, they add one another in the People Pane. It shows up under My Site > My colleagues that they are connected. However, in Outlook, the MySite icon in the People Pane has a red X on it. I thought that User Profile Sync Service might be the culprit after reading through various blogs. However, if I go to Central Administration > Manage Profile Service : User Profile Service Application... if I click Configure Synchronization Connections, the page comes up - "The query returns nothing." I try to click "Create New Connection"... I get an error message - Cannot navigate to the requested page while User Profile Synchronization is running. Please wait for the current Synchronization to finish.   OK - I thought that the query returned no results. I don't see the service running... can someone point me in the right direction?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend