Security :: CreateUser Adding 2 Rows To Aspnet_Users?
Aug 10, 2010
I'm working with 2 sites (Intranet and Extranet) that share the same .net membership database (the standard out of the box version). The Intranet and Extranet site users are stored in separate "Applications" within the membership database. I create all users for both sites from within the intranet site. Everything seems to be working except that when i create a user for the extranet site I end up with 2 rows for that user in aspnet_users. One with userID (guid) that I send in and another with a different guid. I'm assusming that .net is creating an anonymous user. The intranet membership provider is the default.
I could delete this row through sql but am hoping for a more elegant solution. Any suggestions?
Dim objUser As MembershipUser
View 6 Replies
Similar Messages:
Aug 12, 2010
I have a problem with my membership management. I moved the aspnet membership database to my MSSQL server and I would like to create an add user form not using the CreateUserWizard (I would like to add more information then in the simple CUW). I've created the form and I would like to use the Membership.CreateUser method to add the user. After running the script (VB) the user is available in the aspnet_Users table, also in the aspnet_UserInRoles table but not in the aspnet_Membership table. I'm sure that something is wrong with the configuration, I just can't find what.
[Code]....
View 5 Replies
Nov 18, 2010
There are lots of posts about this issue but I can't work out the answers as most of them are for C# or similar. I'm trying to automatically insert the UserId generated by Membership into a custom table. I have membership working correctly, as well as the custom table (I'm able to insert other things from the registration form). But I can't get it to extract the generated UserId and insert it into the custom table. Here's my code:
[Code]....
As you can see I've experimented with the parameters for inserting the record, but that doesn't work (I get an error about ProviderKey not being a part of system.web.security.membershipuser).
View 3 Replies
Feb 28, 2011
I'm trying to use the Membership.CreateUser method without passing a security question and answer. I set them to string.empty, but no go. I have my provider set to not require a question in my web.config. What am I doing wrong?
[Code]....
View 2 Replies
Oct 26, 2010
I created a project using asp.net in visual studio 2008. In my login database table aspnet_users I noticed under the column UserName there is some usernames that I didn't create such as '668215da-b4d0-4e50-8c97-06586afc07b1' All my usernames are less than 8 characters that are generated by users. How and why was the username '668215da-b4d0-4e50-8c97-06586afc07b1' created? When I query the database table aspnet_users to approve a new user I am not interested in usernames such as '668215da-b4d0-4e50-8c97-06586afc07b1'. How do I avoid them in my query?c = squareroot(e/m)
View 3 Replies
Jun 7, 2010
I want to know that is that the value of last activity date in aspnet_users table is changed when user is logoff from the application.
View 3 Replies
Aug 8, 2010
i am using aspnetdb database and i am using createuserwizard control and i have found that i am able to create user account with same username. as far as i know i think usernames are stored uniquly but i can't figured it out why i am able to create user account with duplicate user names.
View 6 Replies
Oct 13, 2010
I'm using SqlMembershipProvider and SqlRoleProvider for user management.
Users are created by
Dim MCS As System.Web.Security.MembershipCreateStatus
Dim NewUser
As MembershipUser = Membership.CreateUser(TB_UserName.Text, TB_Pw.Text, TB_Email.Text, TB_SecQuestion.Text, TB_SecAnswer.Text,
False, MCS)
later, after email confirmation, I take the user into a specified role
Dim myUser As System.Web.Security.MembershipUser = Nothing
myUser = Membership.GetUser(New Guid(Request("RegID")))Catch
If myUser
IsNot
Nothing
Then
myUser.Comment += " approved "
Membership.UpdateUser(myUser)
Roles.AddUserToRole(myUser.UserName, "role")
End if
After this I have two entries with the same UserName in aspnet_Users table, but with different UserId's. One UserId is referenced in aspnet_Membership table and the other in the aspnet_UsersInRoles table.
View 2 Replies
Aug 10, 2010
Perhaps this is a simpler VS9 question, but I want to link a SQLServer table with additional user data to the standard SQLServer membership table using the GUID userID as a foreign key. I go into design mode of my table, right-click on relationships, and click add in the dialog. but the left hand column shows me only the tables in my database. How do I get it to show the tables in the ASPNETDB.MDF database? I went through the tutorial (http://www.asp.net/learn/security/tutorial-08-cs.aspx), but it seems to magically appear in there without explanation.
View 3 Replies
Feb 7, 2011
Is there possibility to create new user with Membership.CreateUser but not to specify the user's password?
I tried with minRequiredPasswordLength="0" minRequiredNonalphanumericCharacters="0", but it didn't work.
I also tried with "" and DBNull.Value for password in the function but it didn't work.
Is there a way to do this?
View 8 Replies
Aug 31, 2010
For my existing data, both RoleName and LoweredRoleName are same, but some are lower case and some are in same case too.
View 3 Replies
Sep 23, 2010
I am using the Membership class in System.web.security to create a bunch of users. Here is the relavent code
[Code]....
After running the above code the out parameter status says success. I take the userId (email address) as well as the password generated by Membership.GeneratePassword to attempt to login to my app, I get Login failed. What am I doing wrong?Note: I can use the ASP.Net configuration tool to generate a user and that user successfully logs in. I checked the table Application in the database to see if the application these users I am attemtping to register in code were being registered to a different application than the one I an running but there is only one application in that table.
View 1 Replies
Apr 21, 2010
I need to modify the CreateUser function because I want to pass an additional parameter to the function. I think the neatest way would be to edit the current IMembershipService interface so that the CreateUser contract includes my additional parameter in all calls to CreateUser.Is this the suggested approach when needing to modify the parameters of the 3 functions?
View 2 Replies
Aug 11, 2010
I have a CreateUserWizard control to be able to allow an anonymous user to create an account. Provided that all entered information is correct that the user enters, a new account is created for him/her. But also, when this user is created, I want to [b]also[/b] add the username to another table in my ASPNETDB database. How exactly can I "tap" into the event that creates a user and adds it to the appropriate tables (aspnet_Users, Members, etc.) and make it add the username to yet another table?
View 1 Replies
Jul 26, 2010
How can i customize or change createuserwizard in visual studio to suite my purpose, for example i want to additional function apart from username , i want to include lastname , country name etc which are not available in createuser wizard, i have done
it in the database table but it is not working.
View 2 Replies
Jul 5, 2010
I am attempting to create a user programatically with Email as the username. My code calls one of the CreateUser overloads, passing only Username, Password and Email. It consistently fails with a status of MembershipCreateStatus.InvalidAnswer. How can this be? I'm not even passing it a security question or answer.
[Code]....
View 2 Replies
Apr 14, 2010
I need to produce a from where I can add multiple parts. Each time a user enters a part number, the description should be populated. The user can then click add and this part and description will be shown below. They have the option to add as many parts as they require. Once all parts are added the user fills in some general info eg description and then once a submit button is clicked all part info will be inserted into a table and general info will be inserted into another table with one unique ID.
View 5 Replies
Apr 14, 2010
If I am going to use the asp.net membership and roles, the asp.net 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
Aug 9, 2010
I developed a site for a client a couple of years ago. It uses the the standard ASP.NET Membership, authentication, etc. I just added the profile section with (2) fields: CustID AgntID. Now whenever I load the page with any Profile code in it I receive this error: Violation of UNIQUE KEY constraint 'IX_aspnet_Users'. Cannot insert duplicate key in object 'dbo.aspnet_Users'. The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Pr__UserI__3CA9F2BB". The conflict occurred in database "broo001", table "dbo.aspnet_Users", column 'UserId'. The statement has been terminated. The statement has been terminated. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_aspnet_Users'. Cannot insert duplicate key in object 'dbo.aspnet_Users'. The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Pr__UserI__3CA9F2BB". The conflict occurred in database "broo001", table "dbo.aspnet_Users", column 'UserId'. The statement has been terminated. The statement has been terminated. Source Error:
[Code]....
Stack Trace:
[Code]....
Here is the code from my web.config:
[Code]....
Here is some of my page code:
[Code]....
View 3 Replies
Mar 19, 2010
What are the best practices implementing this situation:
Members Area:
Name Age Location Contact Num
Joe 16 New York xxxxxx Add Button
Save Button
Once the Add button would be clicked, another set of entries can be entered below the previous row.
Once the Save Button will be clicked then all the entered data would be save to a table on a database..
View 4 Replies
Jun 9, 2010
How can I add rows in a table from server-side?
if (!Page.IsPostBack)
{
Session["table"] = TableId;
}
else
{
TableId = (Table)Session["table"];
}
protected void btnAddinRow_Click(object sender, EventArgs e)
{
num_row = (TableId.Rows).Count;
TableRow r = new TableRow();
TableCell c1 = new TableCell();
TableCell c2 = new TableCell();
TextBox t = new TextBox();
t.ID = "textID" + num_row;
t.EnableViewState = true;
r.ID = "newRow" + num_row;
c1.ID = "newC1" + num_row;
c2.ID = "newC2" + num_row;
c1.Text = "New Cell - " + num_row;
c2.Controls.Add(t);
r.Cells.Add(c1);
r.Cells.Add(c2);
TableId.Rows.Add(r);
Session["table"] = TableId;
}
in debug I found out the number in the "TableID", but the rows are not drawn. Have you got an idea about this issue?
View 4 Replies
Dec 6, 2011
I have added a row to a datatable and displayed this datatable by binding it to gridview.. Later if i add another row to the same table, the data table displays only the recently added row.. I need to display the previously added row along with the newly added row.. How to do this?
View 1 Replies
Dec 15, 2010
I just have a simple ASP Table seen here:
<asp:Table ID="tblCategories" runat="server" CssClass="oneColTable padded-table dataTable">
<asp:TableHeaderRow CssClass="tableHeader">
<asp:TableHeaderCell>Category Name</asp:TableHeaderCell>
<asp:TableHeaderCell Width="50">Delete</asp:TableHeaderCell>
</asp:TableHeaderRow>
</asp:Table>
And if the user wants to add an additional row I use the jQuery Clone method to copy and append a new row.
My issue comes when I want to count the rows present on the C# side it always lists 1 Row. The row for the header entry.
How can I correctly grab the accurate row count on the C# (Codebehind) side?
View 3 Replies
Nov 25, 2010
recently i created a table programatically using c#.
now i want to format the table.
i want to give colors to the alternative rows of the table.
i am having the color values.(#E9F1F3,#98C1CA)
this is the code i have used to create rows and cells...
TableRow tr=new
TableRow();
TableCell tc = new
TableCell();
tc.Controls.Add(new
LiteralControl("...."));
tr.Cells.Add(tc);
DriverTable.Rows.Add(tr);
DriveTAble is the table name.
so i want to add colors to the rows..the colors should be in the hexadecimal code which i have specified above..
View 3 Replies
Jan 27, 2010
I am trying to achieve the multiple attachments. In order to do this, I am trying to add a new row to a html table. It must have 2 columns
1) The File Name which is a hyperlink
2) a button (html button preferably) on click of which I want to delete that particular row.
View 1 Replies
