Urgent !regarding sqlDataAdapter.Update Method

[Madni Abbasi]

Hi, my work hierarchy is as follows. sqlStr = "select * from voucherTransaction where CompanyCode='" & compCode & _ "' and vtCode='" & mcmbVoucherType.SelectedItem.col1 & "' and voucherNo=" & txtVoucherNo.Text parameter.Value = sql // sqlCommand parameter object davd.SelectCommand = cmd // cmd is sqlCommand and davd is sqlDataAdapter object davd.Fill(dsvd, "voucherDetail") // dsvd is DataSet davd.Dispose() //after populating dataSet i need to delete a specific row . and the deletion code is dsvd.Tables("voucherDetail").Rows.RemoveAt(lastRow)//lastrow is secific row no dsvd.Tables("voucherDetail").AcceptChanges() //now i need to add new row as dsvd.Tables("voucherDetail").Rows.Add(drow) // drow is DataRow //now updating the DataSet as follows sqlStr = "select * from voucherTransaction where CompanyCode='" & compCode & _ "' and vtCode='" & mcmbVoucherType.SelectedItem.col1 & "' and voucherNo=" & txtVoucherNo.Text parameter.Value = sqlStr davd.SelectCommand = cmd Dim cbvd As New SqlCommandBuilder(davd) davd.Update(dsvd.Tables("voucherDetail")) davd.Dispose() Now the error is " can't insert the duplicate key value" I have displayed the DataSet table (voucherDetail),there isn't any duplicate value but its showing error for that specific row because its not deleting from the database. Please help me immediately if u have some suggestions