Violation of PRIMARY KEY constraint 'PK_Customers'.
-
i am trying to update my customers table in the northwind database from XML file. Getting an Wrror Violation of PRIMARY KEY constraint 'PK_Customers'. Cannot insert duplicate key in object 'dbo.customers'. i used SqlCommandBuilder to build insert,update and delecte commands. DataSet DSRead = new DataSet(); DSRead.ReadXml("output.xml"); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand (queryString, connection); SqlCommandBuilder builder = new SqlCommandBuilder(adapter); connection.Open(); DataSet dataSet = new DataSet(); adapter.Fill(dataSet, tableName); dataSet = DSRead; //code to modify data in DataSet here builder.GetUpdateCommand(); //Without the SqlCommandBuilder this line would fail adapter.Update(dataSet, tableName); how can i write CommandBuilder to update, insert and delete. Thx