AddaxSoft

The full error string is: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

You will be shocked and have no clue what the heck does this even mean. After spending hourse and hours of trying to solve this in my C# code, the real problem was not in my C# code! it was in the SQL Data base table!

simply why this error occurred is because my awesome table has no primary key. I was trying to update my table with a local data set in the code.

So remember this lesson: No update from a local data set (DataSet)  unless you have a primary key in your remote table.

Related posts:

1. Post tweets/status to both Twitter & Facebook in the same time!
2. Fotobook + Facebook Connect, the incompatibility fix
3. Convert Key Strokes to ASCII & ASCII to Keystrokes