Database

ConstraintException was unhandled:
Column 'cd_id' is constrained to be unique.  Value '9463216602' is already present.

<br />
SqlConnection myConnection;<br />
SqlDataAdapter daCD, daTemas;<br />
DataSet myDataSet = new DataSet("MusicaTeca");<br />
DataViewManager myDVM;<br />
CurrencyManager cm;<br />

<br />
private void frmProduto_Load(object sender, EventArgs e)<br />
{<br />
   myConnection = new SqlConnection(<br />
      "Server=(local)\\SQLEXPRESS;DataBase=musicateca;" +<br />
      "integrated Security=SSPI");<br />
<br />
   daCD = new SqlDataAdapter("SELECT * FROM tbl_cds", myConnection);<br />
   daCD.TableMappings.Add("Table", "tbl_scds");<br />
   daCD.Fill(myDataSet, "tbl_cds");<br />
<br />
   daTemas = new SqlDataAdapter("SELECT * FROM tbl_temas", myConnection);<br />
   daTemas.TableMappings.Add("Table", "tbl_temas");<br />
   daTemas.Fill(myDataSet, "tbl_temas");<br />
<br />
   myDVM = myDataSet.DefaultViewManager;<br />
<br />
   DataRelation relCD_Tema;<br />
   DataColumn parentCol, childCol;<br />
   parentCol = myDataSet.Tables["tbl_cds"].Columns["cd_id"];<br />
   childCol = myDataSet.Tables["tbl_temas"].Columns["cd_id"];<br />
   relCD_Tema = new DataRelation("RelCD_Temas", parentCol, childCol);<br />
   myDataSet.Relations.Add(relCD_Tema);<br />
<br />
   txtAlbum.DataBindings.Add("Text", myDVM, "tbl_cds.album");<br />
   txtAno.DataBindings.Add("Text", myDVM, "tbl_cds.ano");<br />
   txtArtista.DataBindings.Add("Text", myDVM, "tbl_cds.artista");<br />
   txtEditora.DataBindings.Add("Text", myDVM, "tbl_cds.editora");<br />
   txtGenero.DataBindings.Add("Text", myDVM, "tbl_cds.genero");<br />
   txtID.DataBindings.Add("Text", myDVM, "tbl_cds.cd_id");<br />
<br />
   dbGrid.DataSource = myDVM;<br />
   dbGrid.DataMember = "tbl_cds.RelCD_Temas";<br />
   dbGrid.Columns["reg_id"].Visible = false;<br />
   dbGrid.Columns["cd_id"].Visible = false;<br />
<br />
   cm = (CurrencyManager)this.BindingContext[myDVM, "tbl_cds"];<br />
}<br />

<br />
private void btnLocalizar_Click(object sender, EventArgs e)<br />
{<br />
    int intRow;<br />
<br />
    myDVM.DataViewSettings["tbl_cds"].Sort = "cd_id";<br />
    intRow = myDataSet.Tables["tbl_cds"].DefaultView.Find(txtID.Text);<br />
<br />
    if (intRow > 0)<br />
    {<br />
        cm.Position = intRow;   // The Error is in this line.<br />
        cm.Refresh();<br />
    }<br />
    else<br />
    {<br />
         MessageBox.Show("Registo não localizado!");<br />
    }<br />
}<br />