Update-Insert DetailsView, result is duplicating lines

Everytime I edit a record, and hit update I get duplicating lines in my Details View. Here's my If statement:

Any ideas???

Thanks

re: Update-Insert DetailsView, result is duplicating lines

Is this code for a System.Data.DataTable update? Please clarify.

Is the data bound to a DataGrid?
What event are you using to trigger this update/insert?

Sounds like you are manually processing updates done manually in a DataGridView.
Do you have an additional DataAdapter.Update() statement that might be automatically updating the modified rows on its own?

re: Update-Insert DetailsView, result is duplicating lines

Yes, the data is bound to a Gridview when I enter INV #.
Event I'm using is DetailsView1_ItemUpdating. No additional Update statement!

re: Update-Insert DetailsView, result is duplicating lines

Pl;ease remember to use [code] tags when posting code.

MODERATOR

Just a "by the way," you should learn how to use String.Format for building strings. Either that or System.Text.StringBuilder. Because reading long concatenated strings like that is painful, and hard to debug.

re: Update-Insert DetailsView, result is duplicating lines

OK, you are using the actual DetailsView control, which I am not familiar with. Apologies, I thought you meant "details view" in a generic way and might be using a Forms.DataGridView with which I am more familiar.

Hopefully someone with more experience can help you. Nonetheless, sounds like ItemUpdating may be getting called twice...coders familiar with the control know these quirks and will tell you in a heartbeat.

In the meantime, maybe you could add some Trace statements to the ItemUpdating event handler and see if indeed it is getting called twice. Perhaps (longshot) after executing your sql it fires the updating event again? Try removing the "UPDATE part of your logic, so that it only inserts new records. If you don't get a duplicate, then it might mean it was firing an INSERT followed by an UPDATE for some reason.

Good luck.