I am writing a code in Visual studio 2005.
Database is SQL server CE.
I created a table, saved it, and used it for some times before realising that I need more columns.
I added new columns, but when i try to insert to these new columns, it returns an error indicating that the columns are invalid.
So, I decided to create a new table altogether with all the columns, and when I run an insert query into the table, it returns an error indicating that the table does not exist.
I have checked the spelling of the columns and the table, and the names are alright.
What could be the problem and how do i fix it?