Posted on: 4/14/2011 4:28:35 AM | Views : 385

Hi everyone!
I started a project where the database was installed/copied to the pc's on which the program(.net program) is installed. But soon afterwards, the database was moved to host on the internet (web africa). So now I'm working from that database. There was only 3 tables when the database was uploaded, but after the database was uploaded I created a new table.
The problem that I'm having is that when I try to update the databse it gives me the error:
"cannot update identity column"   -- which is the primary key of that table and which shouldn't be changed at all... This error only started with the new table that I created and only since it has been hosted....
This is what I've done:
if ((dataChange["TaskDateCompleted"] == System.DBNull.Value)) { < ...

Go to the complete details ...