TableAdapter.Update Error

-
Error Exception: InvalidOperationException

Error Message: Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

Problem: The update command is missing from the table adapter.

Cause: I believe that this must have occured by changing the database structure after the dataset was created from it.

Solution: Configure the data table of for the table in question. Assure that "Generate Insert, Update and Delete Statments" is checked inside of Advanced Options. Finish the wizard. Your command statements will be rebuilt (including the Update command).

Comments

Post a Comment

Popular posts from this blog

Form.Show() From Another THread - C#.Net

-
Today I ran into a mojor headache. I have a main form that instantiates a secondary form from its constructor. I also register to a receive data event that I have based on a socket. Because the socket uses threading, when my event delegate is called, it is being called from the context of another thread. It is inside the execution of the delegate that I ran into trouble. When I receive data from the socket, I want to open the secondary form and do something with it. Immediately I know that I am going to have to use Invoke on the secondary form in order to safely modify it from the other thread. My original attempt looked like this (I will use an inline delegate here to simplify this listing): void dataReceived() { If(secondaryForm.InvokeRequired) { MethodInvoker myDelegate = delegate { secondaryForm.Show(); //do other work on secondaryForm }; secondaryForm.Invoke(myDelegate)...
Read more

Recover deleted files from a jailbroke iPhone (or *nix)

-
Here I will describe a process that will allow you to recover deleted files from an jailbroken iPhone hard drive. If you do not know what jailbroken means, your device most likely does not fall into this category. This method should also work with virtually any *nix based distribution as well. I will split this up into two parts: create disk image and analyze disk image. You will also find a list of my resources at the end. I suggest reading completely through each section before attempting it. Do not be intimidated by the length of this post. I have tried to provide a lot of information, but this operation boils down to using only 2 commands. CREATE DISK IMAGE The instant you realize that you need to recover a deleted file, stop using the device immediately. The more you continue to use the device, the higher the chance that the files you need will be overwritten. The first thing we need to do is to make a copy of the data on the device's hard drive. The technique we ...
Read more

Triple-Boot MacBook Pro

-
I am now the proud owner of a triple-boot MacBook Pro featuring OSX, Windows XP, and Ubuntu 10.4; One big happy family! I primarily followed the article here: http://fletcherpenney.net/2009/04/create_the_ultimate_triple-boo I already had OSX with Windows XP set up on boot camp. To get the full house, I only needed to add Ubuntu to the mix. I began by shrinking the OSX partition to make room for Ubuntu using OSX's disk utility. I then installed Ubuntu onto the new partition using a single partition (no separate swap partition) being sure to install the grub boot loader to the same partition (not into the MBR). The key to getting all of the OSs to play nicely together is to use a utility called 'rEFIt' which acts as a boot loader as well as syncs the EFI and MBR for you. It is easily installed from OSX and is available here: http://refit.sourceforge.net/ At that point, all seemed well accept for a nice new BSOD when booting into Windows with the error "UNMOUNTABL...
Read more