'Update' ExecuteNonQuery Deleting Record ???

[Adrian Turner]

I have a very simple update query that if I run several times(keep refreshing
the page) the update command deletes the record. Any Ideas ?

 

[Ken]

I have a very simple update query that if I run several times(keep
refreshing the page) the update command deletes the record. Any Ideas ?

I have had something similar. I had a parent child relationship with
the child datasource on a grid. When I added a record it appeared in the
grid. BUT I had the wrong keys. When I refreshed the grid and it
asserted the proper keys it disappeared.

Are you updating something that will cause a parent child relationship to
stop showing the record?

 

[Jie Wang [MSFT]]

Hi Adrian,

Thank you for posting.

Before we begin finding the root cause of this problem, would you please
let me know more information regarding the problem so I can get a better
picture of it? Like what kind of application are we working on (sounds like
ASP.NET?), the version of Visual Studio, the programming language, and what
database are we using?

Sounds like it could be a "Double postback" problem, or it could be like
what Ken said, a Table Relation problem.
Is there any other controls & code on your page that can perform the Delete
operation?

If possible, any code snippets would be very helpful for troubleshooting.

Thank you for your time and I'll be looking forward to hear from you with
more detailed explanation.

Regards,

Jie Wang ([email protected], remove 'online.')

Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business days is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jie Wang [MSFT]]

Hi Adrian,

Would you mind letting us know the result of this issue?

If it has not been sovled yet, I'd be happy to be of assistance.

Best regards,

Jie Wang ([email protected], remove 'online.')

Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business days is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.