I am getting to like how to use a profiles in aspnetdb membership
But these profiles are stores in a string.
Q: How does one get this profile data into a table, or get TSQL to show data in a column format.
I have developed a Silverlight app using forms authentication and the asp net membership, aspnetdb, the whole enchilada.The bug I see is that the password for my users change by them self every bow and then, the way I fix them is by deleting the user and creating them again, this has been I problem all the time.In a post I read the problem was manifesting because I didn't have a machineKey in my web.config, I now do, so I dunno what the problem is this time...Is there a definitive fix to this? can you please provide assistance?
View 11 RepliesI am in the begininng stages of designing (or redisigning) a site. I am using VWD Express 2010 and the project is configured for .net 4.0. I am designing it offline so its currently just on my laptop, which is also running sql server express 2008 R2.
When I ran the ASP.Net Configuration tool, it automatically created a database called aspnetdb in the app_data folder where it stores all the user and roll info. How can I use a different database that has the same schema as well as some additional tables of my own. I want to point it to mylocally running sql server.
I have deployed an MVC application that uses ASPNetDB for Membership and Role Provider.
now when i browse to the site on the actual server where it was deployed to i can use the login page to login on to the site and gain access to views that are restricted to users like myself by role.
However when i try and access the web application from any client computer who has access to sites on the server since the server is on the same domain - i experience the following strange behaviour:
when i navigate to my login page and enter my username and password (as stored in the aspnetdb database)
and click login
the page refreshes (looses my userid and name) and it does not go to the view i requested.
it also does not show in the top right links that i am logged on.
it is as though it spits out my username and password and refresh the page and that is that!
Why does it work on the server where the site is hosted - but not from external clients?
i can access all pages that do not require users to be logged on or haev a specific role - but cannot log on and view them since login is broken?
I have searched for an answer to my problem and could not find an answer anywhere.
I am rebuilding a website (converting it to use masterpages, usercontrols, asp.net memberships, etc using asp.net 4.0 C#) that has two different types of users. The problem is, the two different users have different roles ie. customers and employeers. Depending
on the role the user is assigned to they will have different things that should be stored in their profile.
For instance a customer would have all the basic elements of a profile, name, address, phone, etc. But it would also have some extra stuff like, a little bit about themselves, their resume, where they went to school, etc. On the other hand an employer would
have the basic elements but it would include details such as the position, a description of the position, contact for that position, etc.
Is there any way to have multiple profiles and still use the asp.net sql membership and profile provider?
i working on event managment registration and i need to make a roll for visitors and roll for exhibitors isitor most enter data to visitor profile with data likefirst name,last name , DOB, Mobile Number, tel , fax and exhibitor most enter data to exhibitors profile data with different data .it's easy to make it for visitor or exhibitors with one profile how to make it with different data profiles what the logic to make that
View 2 RepliesI'm modifying Scottgu's tutorial for adding profile information to a login.I have put in a provider tag and the profile tag parts in the web config, and hooked it up to a connection to my SQL Server DB.I have modified the create user wizard step 1 to contain extra controls to capture forename and surname. I then altered the tutorial code to match this.however, though the _CreatedUser event code fires, nothing is stored in the aspnet_Profiles table in my DB.I took the tutorial code for the display profile info page and modified it to displAy the users name, but nothing appears on the page, even though the users username appears using the loginname control.all I would like to do is display message in the master page that says 'welcome, John Doe, you are logged in as doej'
View 8 RepliesI have just put my first ASP.Net site live on the internet but im having problems with my login. When i try to login my sit is throwing an error.
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
I have run my script from visual studio so the profiles are there but i cant login?
If I use System.Web.Profile.ProfileManager.GetAllProfiles, I get all profiles for users that have logged in since I implemented saving a custom profile item. A few problems I need to solve.
1) when I use the GetAllProfiles method listed above, the custom profile items are not available. For the current user, I can get the value using HttpContext.Current.Profile.Item("MyCustomItem"). I need to be able to get to all the profile items programmatically.
2) I also need to programmatically create profile items for other users (a migration to this format).
3) I cannot get to the items like the documentation says like Profile.MyCustomItem.
I've been using the CreateUserWizard to create my users as well as to assign them roles/permissions. My problem is that, once created, I have no idea how to edit or delete their details without using the Asp.net Website Administration Tool. Where can I get some extensive but easy to understand literature on the subject?
View 4 RepliesIve searched quite a while to do this.. havent found any revelant answer i already have a database named GAD.MDF with tables inside. However i wanna use the membership API to use the tables generated in the aspnetdb.mdf. Is there a way to generate thoses tables in my own database and then use my database instead? cause many host only enable us to use one database.
View 4 RepliesI used aspnet_regsql -W wizard approach to create DB for membership tables. and added script as follows in web.Config
[code]....
I'm just curious, why its not bigint or int ? is that because GUID is easy to generate ?
View 8 RepliesI have setup a Web Site Administration Tool for a web application and it work great
Now i have another custom application that was built on a different server and site but i want to use the users in the existingWeb Site Administration Tool for authentication and authorisation.So i deployed the custom application to the the same server where the Web Site Administration Tool resides. and just changed the connection string to point to the same database.But when i login with a username and pass it says login no correct.http://myserver/IntranetAdminTool/default.aspx?pplicationPhysicalPath=C:Inetpubmyapplication&applicationUrl=/myapplicationwhen i go to the link above it works and i can see all my usershttp://myserver/IntranetAdminTool/default.aspx?pplicationPhysicalPath=C:Inetpubmyapplication2&applicationUrl=/myapplication2When i go to this link i can't see users as its th new custom application i just moved to the site.
I get error There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem:Server cannot access application directory 'C:Inetpubmyapplication2'. The directory does not exist or is not accessible because of security settings.Is my approach a resonable one and is this possible?
In one of my web app's pages, the code behind needs to grab the UserId of the person logged in, so that it can then be inserted into a table which was added to the original aspnetdb.mdf. This table contains a column with a uniqueidentifier primary key which is in direct relationship with the aspnet_Users table; however I seem to have trouble retrieving the UserId. This table contains the additional information of a user which is not included in the provider, and it has a one-to-one relationship with aspnet_Users.
I hope this makes sense. I haven't written any code for it yet; I'm only at the thinking part of this stage. But my mind keeps going blank.(perhaps I need a break from the solution???).
I am using C# in my Web app's code behind.
I had a web application. We needed to move it to anotherserver, after we moved that, the membership database (aspnetdb) did not work.....finally i solved the problem, and now I have another problem. although in the web.config enablepasswordretrieval is set to true, and the type is clear, i get error in password retrieval.
View 7 RepliesI am using Visual Studio 2008 Express.
I did this simple test:
I created a new Web project with a simple page that has a Log In. There were no databases in App_Data.
I used the configuration tool to create a Role and User.
I refreshed the project folder and behold AspNetDB.mdf has appeared in the App_Data folder.
I have checked the Web.Config file and there is NO Connection string to this database.
So how do I move the Roles/Users application data storage away from AspNetDB.mdf to my own database ?
I am creating a website, where my client is planning to target 1000's or user registrations with their login area etc. Is it a good idea to use role management/aspnetdb for this purpose?
View 9 RepliesCurrently in security setting in website configuration, there us only User, Roles, And Access Rules.i want to add Groups as top level for Users. is it possible?
View 4 RepliesI used the wizard and went through the steps to set it up and clicked DONE and closed the ASP.NET configuration window/wizard and the database was not created. What might be wrong here?
View 1 Replies[Code]....
[Code]....
I built a website that tracks submissions online (SQL server express 08 edition). It has its own User table thats linked to other data tables specific to the business of the website. But I found out recently that I can save lot of time by integrating ASP.NET standard Login Controls that can automate lot of coding and make my life easier. Now since then, I added the login controls, integrated the work flow into my website (just user , role navigation so far) and noticed VS creates its own user tables , view, SPs etc. I am okay with that.I need all my submissions to be linked to a particular user that enters each sumission. Now since my user (userid) moved from my personal custom table to a standard ASPNETDB.mdf table... how do I link my original website database and tables to this Default User table / (ASPNETDB.mdf) created by VS.
View 5 RepliesHow to get the username and password of the user in ASPNETDB. I am using ASP.NET 2.0 and C#.
I have configured the membership provider. I want to retrieve the username and password from the aspnet db?
I'm using VWD 2010 asp.net 4.0 and SQL Server 2008 Express
I created a website that uses security with aspnetdb configuration
now I have hundred users that need to access this website
And I don't want manually insert them one by one
Is there any way (T SQL Stored Proc or ASP.NET VB code) to automated this bulk insert?
I currently have a website up and running and working correctly with godaddy.com using the out-of-the box authentication with an aspnetdb sqlserver database. I have users on this site and am very hesitant to change anything with this database or the web.config file from the working site for fear of wrecking it
So, my challenge is that I need to authenticate a separate application using the same aspnetdb.mdf file without any crossover to my 1st application. I've noticed that the ApplicationName that is currently in my aspnetdb database for the working application is just "/". I know that I'll need to have 2 separate entries in the aspnet_Applications table to define these two applications and then somehow register those names within their respective web.config files - but wanted to have step by step instructions on how to this so as to not "break" the 1st working application that is already live.
Can anyone point me to a document on what changes I will need to make?
Also, with the default create user wizards I'm using, how will it know to create the new user information with the correct application ID so that the user information from one application is not visible to managers of the second application and vice/versa?