Databases
StackOverflow2013
Postsdbo
POViolation of UNIQUE KEY constraint while updating field
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POViolation of UNIQUE KEY constraint while updating field
    primarykey
    data
    text
    <p>I am using a gridview i that adding the row with text box and adding the data which is successfully done.. But when i am update a field Email it is showing the error.. Violation of UNIQUE KEY constraint while updating field</p> <pre><code>function: Update_U_Anonymoususerdetails int InsId=0, UserId=0,UserInstLink=0,UserCreditRecord=0; SqlConnection Cn = new SqlConnection(Conn); Cn.Open(); for (int i = 0; i &lt; GridView1.Rows.Count; i++) { Label Id = GridView1.Rows[i].FindControl("lblId") as Label; TextBox Name = GridView1.Rows[i].FindControl("txtName") as TextBox; TextBox MName = GridView1.Rows[i].FindControl("txtMName") as TextBox; TextBox LName = GridView1.Rows[i].FindControl("txtLName") as TextBox; TextBox Degree = GridView1.Rows[i].FindControl("txtDegree") as TextBox; TextBox Title = GridView1.Rows[i].FindControl("txtTitle") as TextBox; TextBox Email = GridView1.Rows[i].FindControl("txtEmail") as TextBox; TextBox Institution = GridView1.Rows[i].FindControl("txtInstitution") as TextBox; if (Name.Text.Trim() != null &amp;&amp; Name.Text.Trim() !="") { int AId = 0; if (Id != null) AId = Convert.ToInt32(Id.Text); else AId = 0; SqlCommand Cmd = new SqlCommand("UpdateOtherAuthors", Cn); Cmd.CommandType = CommandType.StoredProcedure; SqlParameter InID = new SqlParameter("@uiID", SqlDbType.Int); InID.Direction = ParameterDirection.Output; Cmd.Parameters.Add(InID); Cmd.Parameters.AddWithValue("@Name", Name.Text); Cmd.Parameters.AddWithValue("@MName", MName.Text); Cmd.Parameters.AddWithValue("@LName", LName.Text); Cmd.Parameters.AddWithValue("@Degree", Degree.Text); Cmd.Parameters.AddWithValue("@Title", Title.Text); Cmd.Parameters.AddWithValue("@Email", Email.Text); Cmd.Parameters.AddWithValue("@Institution", Institution.Text); Cmd.Parameters.AddWithValue("@Id", AId); Cmd.Parameters.AddWithValue("@CaseId", CaseId); Cmd.ExecuteNonQuery(); UserId = int.Parse(Cmd.Parameters["@uiID"].Value.ToString());//getting error in this line first } if (Institution.Text.Trim() != null &amp;&amp; Institution.Text.Trim() != "") { SqlCommand cmd = new SqlCommand("AddInstitution", Cn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter oParam = new SqlParameter("@Institution", Institution.Text.ToString()); SqlParameter InID = new SqlParameter("@InID",SqlDbType.Int); oParam.Direction = ParameterDirection.Input; InID.Direction = ParameterDirection.Output; cmd.Parameters.Add(oParam); cmd.Parameters.Add(InID); cmd.ExecuteNonQuery(); InsId = int.Parse(cmd.Parameters["@InID"].Value.ToString()); } UserInstLink= UserInstutionLink(UserId, InsId);// I am getting the error in this line UserCreditRecord = UserCreditRecordID(UserInstLink, Name.Text, MName.Text, LName.Text, Degree.Text, Title.Text); AssignContentManagementPrivileges(UserId,CaseId); CreateCaseCredits(InsId, CaseId, UserCreditRecord); } Cn.Close(); store procedure i am using CREATE PROCEDURE [dbo].[UpdateOtherAuthors] ( @Name nvarchar(50), @MName nvarchar(50), @LName nvarchar(50), @Degree nvarchar(50), @Title nvarchar(50), @Email nvarchar(50), @Institution nvarchar(50), @Id int, @CaseId int, @uiID int output ) AS BEGIN Declare @SameId nvarchar(50) if(@Id='0') begin INSERT INTO tbl_AuthorDetails VALUES(@Name,@Degree,@Title,@Email,@Institution,@CaseId,@LName,@MName) Select @Id=COUNT(Email) from [User] where Email=@Email if(@Id=0) begin exec CreateOtherAuthorsAccount @Name,@LName,@MName,@Degree,@Email end end else begin set @SameId=(Select (Email) from tbl_AuthorDetails where Id=@Id) if(@SameId = @Email) Update tbl_AuthorDetails set Name=@Name,Degree=@Degree,Title=@Title,Email=@Email,Institution=@Institution,LName=@LName,MName=@MName where Id=@Id else begin INSERT INTO tbl_AuthorDetails VALUES(@Name,@Degree,@Title,@Email,@Institution,@CaseId,@LName,@MName) Update tbl_AuthorDetails set CaseId=NULL where Id=@Id exec CreateOtherAuthorsAccount @Name,@LName,@MName,@Degree,@Email end end END set @uiID= (Select ID from [User] where Email=@Email) RETURN @uiID </code></pre> <p>calling the function: </p> <pre><code>objGetBaseCase.Update_U_Anonymoususerdetails(GridView1, Convert.ToInt32(Request.QueryString[0])); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBenjamin
    1. USRocky
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POViolation of UNIQUE KEY constraint while updating field
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload