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 RepliesI 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 RepliesI'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.
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 RepliesI 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 RepliesI 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]....
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 RepliesFor my existing data, both RoleName and LoweredRoleName are same, but some are lower case and some are in same case too.
View 3 RepliesI'm trying to build a website which has a two-tier membership system, a bit like Basecamp. The first level of membership will be the administrators, who must have unique usernames. The second level will be the clients of the administrators, so they must allow duplicate usernames (e.g 'johnsmith' can register under 'administrator1' but 'johnsmith' can also register under 'administrator2'.To give a bit of background on this, evenutally each administrator will have their own sub-domain (exactly like Basecamp) using their username as a sub-domain, like this:http://administrator1.example.comhttp://administrator2.example.comThen each administrator may have lots of clients, with their own username as part of the URL when they log in. e.g:[URL]this type of membership system? Presumably it has to be a custom provider? Would I be better just creating my own database table structure (perhaps 2 tables, one for each membership type) then build the code around these, with my own authentication etc?What I'm thinking is a database schema something like this:AdminMembers table:Id (primary key)Username (must be unique)EmailPasswordClientMembers table:Id (primary key)UsernameEmailPasswordAdminMembersIdWould something like this work? If so, would I need to make this into a custom provider? Any good references for this type thing?I'm a total ASP.NET MVC newby (and have limited ASP.NET experience anyway) but I'm trying to use this project to learn,
View 5 RepliesI am wondering if the aspnet_Users table is always sorted (by UserName) even if I add new users which are alphabetically between two already existing users.
I've noticed that the method Membership.GetAllUsers() always seems to return a sorted collection of MembershipUsers.
Also when I look into SQL Server Management Studio and run a simple SQL query without ORDERBY clause...
SELECT [UserName]
FROM [MyDb].[dbo].[aspnet_Users]
...I get always a sorted result list.
I'm still very unfamiliar with SQL Server but I expected that when I add a new row to a table it is (physically) appended to the end of the table. And when I run a select statement without ORDERBY the rows will be selected in the order they were initially inserted into the database (so without any specific sort order).
I am wrong I guess. But how does it really work? Is it perhaps something special with the aspnet_Users table?
I am happy that the MemberShipUserCollection returned by GetAllUsers() is sorted but is it always guaranteed?
Update
I've just noticed that the database contains a stored procedure called aspnet_Membership_GetAllUsers. This procedure actually contains an ORDER BY clause by UserName. So if this stored procedure is indeed always called when I use Membership.GetAllUsers() in my code (at least if I am using the SqlMembershipProvider) it explains why the collection returned by Membership.GetAllUsers() is sorted by UserName.
Remains the question: Is Membership.GetAllUsers() actually based on this stored procedure?
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
I have an ASP:Table that has one row in by default. I would like to give the user the ability to, by clicking a button, add the same row again to enable more data entry. The end result being that I can commit the data in the rows to a SQL database.
My Table Code
<asp:Table ID="Table1" runat="server" Height="50%" Width="100%">
<asp:TableHeaderRow CssClass="lblrow2" HorizontalAlign="Left" BackColor="AliceBlue">
<asp:TableHeaderCell ID="haccountref">Account Ref:</asp:TableHeaderCell>
<asp:TableHeaderCell ID="hproduct">Product</asp:TableHeaderCell>
[Code]....
The question here is how would I achieve this properly and will I then be able to send the data as separate rows to SQL?
I want to create duplicate table, in oracle I am using "create table dup3 as (select distinct * from dup2) " this sql query but when I run this query in SqlServer then error is coming.
View 5 RepliesI am writing a project in MVC . I have an Admin section wherby initially all the data is entered .
I have a table called STUDENTS fields STUDENT_ID (Primary Key and auto generated number) and field STUDENT_NAME .
I have a controller , model and view . I can add entries to this table but how can I make it error if same name is entered again - .
I would like to duplicate each row in a table.
View 5 RepliesI have a site where users can enter their profile and password-protect certain details. I would like search engines to crawl the 'unprotected' parts of the profile (which varies from user to user). Similar to how if you enter a user's name in facebook, their Facebook profile comes up in the search results. Do I have to do anything special to ensure that the bot doesn't crawl the password-protected sections, but still crawls the (always-public) username?I'm not sure if this is even an issue, but I'd like to update my robots.txt to allow for this.
Also, how do I ensure that the usernames are available to the bots (in a safe manner)? Do I have to create a separate directory with a list of names, or is there a better way?
The three Dropdowns filter based on what is selected, kind of like a cascading drop down but I want it to cascade down and up.
When the 3rd DD is changed it doesn't clear the DD of the 1 and 2 ... just adds to the DD.
[Code]....
I'm using SQL Server 2005 in a project, and i need to duplicate a record from a table and all it's relationships.
View 9 Repliesnow the system always prompts a error message about insert duplicate key into Sybase database.how can i prompt a message box instead of this error message when i insert duplicate key into sybase database table. any code can check what type of error then prompt different alert message.
View 1 RepliesI have 2 tables Order and Order_Detailrder_dtl_id is the primary key Order_id is the foreign key that referrence Order_Id in Order Table
View 4 RepliesI have Revision column in Quote table with time stamp (MySql table) now i am viewing the entire date and time my end user want to view only Date he doesnot want to see time how can i pull only date.i am displaying revision column in two ways one in grid view and another one in field value
Query in my Grid view
Dim query As String = "SELECT QuoteNumber,Revision,Vendor,PartNumber,status,Customer,Requestor from quotes"
On select check box in grid view, filed values will be loaded with data.
field value
txtRev.Text = dt.Rows(indx)("Revision").ToString()
I am using SQL Server2005 with asp.net. I want validation at server side to restrict duplicate entries, Here i am using two tables companies and Branches. In Branches Table i had maintain a foreign key of CompanyId. In Branches the BranchName can be duplicate but not for the Particular CompanyId
View 2 RepliesWe have developed the Application using Visual Studio 2008, After publish we got the issue like After Submitting the Form the user can able to Move Backward and do the Refresh. This will again triggers the Submit Post Back and the Duplicate Record Created As Well.
This is happening for all the Web Forms. How to Avoid this ? I need a Generic Solution where i can implement that logic in Base Page then the rest of the Pages this functionality will be covered by default.
Moreover, Before Refresh We should also intimate user "Do you Want to Post the Same Data Again ?", if the user clicks Yes then it can allow the same record can be posted again.
How to do this ?? But i cannot disable the Browser Features like back, forward and Others. I have found many solutions in various web sites but it is also happening for the Validation Part Also...
How do I remove duplicate rows from a data table based upon a two column values;I want to pass in a Data Table and a column names and get the data table back with data rows where that columns value are unique.
I have a Data Table with Duplicate Rows i want to delete the duplicates rows based upon two column values if both columns values are there then Delete the row.
Is it possible to setup the CreateUserWizard to check for a duplicate entry in the aspnet_profile table (for a custom field) before the new user is created? For example, if I added a phone number field and wanted to make sure nobody else could create an account using that same phone number if a user already has an account with that phone number in the aspnet_Profile table's PropertyValuesString row?
View 10 Replies