username should be unique

Question

when user register its profile then username should be unique for every user using entity framework in asp.net c#

Jenith Thakkar · Answer

Hi before this line var usersadd = context.Set (); just check like below var Data = context.Users.where(u=>u.username==newusermodel.username).firstordefault() if (Data== null ) { then do code for save user } else { print message }

Jay Krishna Reddy · Answer

user.Name = newusermodel.Name; Check here with the existing username replace the code var response = user.Where(c=>c.Username.Equals(newusermodel.username)).firstordefault(); string result = response != null ? "New User" : "Existing Username"

Jenith Thakkar · Answer

Okay please mark as a answer if it's helpful for you so it would helpful for me also

Guest User · Answer

Its working now..i just simply take a label and print message on it..Thanks Everyone For Ur Help...

Guest User · Answer

its doesnot add new user but the problem is it doesnt show any message of User exists or not. var usersadd = context.Set (); var response = context.Users.Where(u => u.UserName == newusermodel.UserName).FirstOrDefault(); if(response == null) { usersadd.Add(user); context.SaveChanges(); } else { string messagebox = response != null ? "New User" : "Existing Username"; }

Guest User · Answer

i am bit confused.can u please tell me..where should i use this senerio.... here is my register page.. Aspx code.. Registration Image: Name: Style="top:182px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate="TxtName" ErrorMessage="Name required**" font-size="Small" ForeColor ="Red"> UserName: Style="top: 224px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate="TxtUserName" ErrorMessage="Username required** " font-size="Small" ForeColor="Red"> EmailID: Style="top:271px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate="TxtEmailID" ErrorMessage="Valid EmailID required" font-size="Small" ForeColor="Red"> Password: Style="top:321px; left: 774px; position: absolute; height: 26px; width: 162px" ControlToValidate="TxtPassword" ErrorMessage="It contains 1-special character and 0-9 numbers required" font-size="Small" ForeColor="Red"> Confirm Password: onclick="Button1_Click" /> Aspx.cs.. using System; using System.Configuration; using System.Data; using System.Data.Entity; using System.Data.SqlClient; using System.IO; using System.Security.Cryptography; using System.Text; using WalPaper.Model; namespace WalPaper { public partial class WebForm2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { Model.User newusermodel = new Model.User(); newusermodel.Image = TxtImg.ToString(); newusermodel.Name = TxtName.Text; newusermodel.UserName = TxtUserName.Text; newusermodel.EmailID = TxtEmailID.Text; newusermodel.Created_Date = DateTime.Now; newusermodel.User_Type_Id = 3; newusermodel.Password = TxtPassword.Text; using (WallpaperEntities3 context = new WallpaperEntities3()) { User user = new User(); { string str = TxtImg.FileName; TxtImg.PostedFile.SaveAs(Server.MapPath("~/Upload/" + str)); string Image = "~/Upload/" + str.ToString(); string name = TxtImg.ToString(); user.Image = newusermodel.Image; user.Name = newusermodel.Name; user.UserName = newusermodel.UserName; user.EmailID = newusermodel.EmailID; user.Created_Date = newusermodel.Created_Date; user.User_Type_Id = newusermodel.User_Type_Id; user.Password = newusermodel.Password; }; var usersadd = context.Set (); usersadd.Add(user); context.SaveChanges(); string message = "Your details have been saved successfully."; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); Response.Redirect("/Login.aspx"); } } } }

Jenith Thakkar · Answer

If you checked my code properly then you notice that what I do their I have matched entered username with the database username if both are same then return 1 else 0 so if it retuns a 0 then you just show you message

Guest User · Answer

Dear Experts !! am working on Asp.net,c# using entity framework In my project, i have a Registration Form. and also i have User Table in database. So i need to create a Usernames as Unique. Suppose if the User Registered with one name and the other users should not create with this name. So , i need a Message like Already Exists with this Name, Try another name. Please Suggest me, and help me, How to do this ?

Jay Krishna Reddy · Answer

Pass the Current post value to check with the Database users table and if a user exists with the same name we won't allow saving Public string ValidateUserName( string username) { string finalresult = string .Empty; var result = db.context.table.Where(c=>c.username.Equals(username)).firstordefault(); return finalresult = result!= null ? "username Saved" : "Already Exists ,Try Another one" ; } else saved.

Jenith Thakkar · Answer

FOr that you can check passed username parameter like public int DoOperation (UserDetails user) { int userexist = 0; var data =db.context.users.where(u=>u.username==user.username).firstordefault(); if (data!= null ) { userexist =1; } else { userexist = 0; } return userexist; } Thank you

username should be unique

Answers (10)