Click here to Skip to main content
15,917,618 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have an C# asp page, which has an upload button to upload xml file:
Then I can choose the xml and display in grid view, which is working fine,
and whenever I upload a file which has been already uploaded, it rejects the xml file with duplicate records validation.
But I want to add the non duplicate values which exists in a xml which has duplicate records.
Now when i upload an xml file which has 'a''b''c' , and when i upload another xml which has values 'a''b''c','d''e''f', the whole xml is not getting added and shows error duplicate validation.

What I have tried:

I have a sproc where i use the 'IF EXISTS condition' where x=x,y=y,z=z,then error else add
Member 15627495 11-Nov-22 6:00am    
usually x=x return true, but it's a bad request to check your xml.
It's where x = x_2 for a good checking.

show some piece of code please. It's hard to understand like this.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900