How to get rid of duplicate table where one is invisible C#

Nozibulla Bashar

I have a table where i did store data. But after adding some extra column in that table when i try to insert some value in the new columns it shows an exception that "invalid column name". But when i tried to insert value to the old column of my table it store the value and i can also retrieve those value in a form, But the newly added value cant be shown in the existing table. I think there is a invisible table in my default database schema with the same name of my dbo schema table. Where my data is being stored and retrieved.And in those visible table my newly added column has not been added that is why its shows this exception. Can any one suggest me what can i do to get rid of this problem?Really i am in a great problem.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nozibulla Bashar11y ago
Actually column name or table name was not the problem. But i have solved the problem. Thanks anyway.
0
Gowtham Rajamanickam11y ago
Insert query syntax is - Insert into tablename (column_name1,column_name2,column_name3,column_name4,column_name5)values (value1,value2,value3,value4,value5) -----------------
0
Riddhi Valecha11y ago
Hi..

I think there must be a spelling mistake for column name...

Insert query syntax is -

Insert into tablename (column_name1,column_name2,column_name3,column_name4,column_name5)values
(value1,value2,value3,value4,value5)
-----------------

Replace the table name and column names.....
0