Can someone tell me why my dataset wont save correctly to the database in simple winforms app?

Posted by Mike on Stack Overflow See other posts from Stack Overflow or by Mike
Published on 2010-03-29T22:41:29Z Indexed on 2010/03/29 22:43 UTC
Read the original article Hit count: 156

Filed under:

winforms

|

.NET

|

ADO.NET

I have been struggling with this all day and I know it is probably something stupid. My code is below. If I call save then exit my program and start again I can save images to my events but if I just call save when I try to add an image and call save again I get a foreign key error. From what I know I thought my save method was updating the database from my dataset so the event associated with the image should exist. Anyway here is my save method...

Private Sub Save()
    Me.Validate()

    EventsBindingSource.EndEdit()
    ImagesBindingSource.EndEdit()

    TableAdapterManager.UpdateAll(EventDataSet)
    EventDataSet.AcceptChanges()        
End Sub

Am I doing this wrong? Is this enough detail?

© Stack Overflow or respective owner

Related posts about winforms

Redirect WinForms web browser Control pop ups to another WinForms web browser control with form data

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a c# web browser and one of the pages it displays has a form. When the form is submitted it posts data to a new window in IE. I want to catch that data and forward it to another C# web browser that I have in my application. So I don't want it to open an IE browser when the javascript function… >>> More
Responding to MS Wireless Notebook Presenter Mouse 8000 presenter buttons in WPF/WinForms

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know how to respond to the presentation buttons of the Microsoft Wireless Notebook Presenter Mouse 8000 in WPF or WinForms? >>> More
WinForms Web Browser control forcing refocus?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to automate a web process where I need to click a button repeatedly. When my code "clicks" that button (an HtmlElement obtained from the WebBrowser control I have on my form) then it brings focus back to my application, more specifically the WebBrowser control. I wish to better automate… >>> More
Creating a Persistent Panel Web Control

as seen on Code Project - Search for 'Code Project'
Extending ASP.NET's Built in Panel Control to create Sticky control values between page visits. >>> More
Moving from Winforms to WPF

as seen on Programmers - Search for 'Programmers'
I am a long time experienced Windows Forms developer, but now it's time to move to WPF because a new WPF project is comming soon to me and I have only a short lead time to prepare myself to learn WPF. What is the best way for a experienced Winforms devleoper? Can you give me some hints and recommendations… >>> More

Related posts about .NET

Apt-Get Update: failure to fetch; can't connect to any sources

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I realize there are dozens of "apt-get update: failure to fetch" questions (I read through all I could find), but my present circumstance is unique to 12.04 and it affects all sources; not just launchpad. Additionally, I've tried several different servers in Europe and the U.S. as well as the "main… >>> More
12.04: Apt-Get Update: failure to fetch; can't connect to any sources

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I realize there are dozens of "apt-get update: failure to fetch" questions (I read through all I could find), but my present circumstance is unique to 12.04 and it affects all sources; not just launchpad. Additionally, I've tried several different servers in Europe and the U.S. as well as the "main… >>> More
What's New in ASP.NET 4

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The .NET Framework version 4 includes enhancements for ASP.NET 4 in targeted areas. Visual Studio 2010 and Microsoft Visual Web Developer Express also include enhancements and new features for improved Web development. This document provides an overview of many of the new features that are included… >>> More
.NET Reflector 6, .NET Reflector Pro, TestDriven.NET, .NET 4.0 and Mono

as seen on Simple Talk - Search for 'Simple Talk'
By now you may well have noticed that .NET Reflector 6 and .NET Reflector Pro are out in the wild. The official launch happened today, although we actually put the software out last Thursday as part of a phased release plan to ensure that everything went smoothly today which, so far, it seems to have… >>> More
Redmine on Apache2 with Passenger issue

as seen on Server Fault - Search for 'Server Fault'
I installed Redmine and run it in Apache2 with the Passenger module. Apache2 boots, Passenger module gets loaded and the Redmine welcome page is shown, however when trying to login or navigate to other parts of the Redmine site, the browser keeps loading and loading and loading forever, although the… >>> More