<div>
Or simply the columname in the SQL statement doesn't match the one in the Database.<br />
Triple Check..
</div>


Or simply the columname in the SQL statement doesn't match the one in the Database.
Triple Check..

<div>
Are you using a stored procedure or class layer to hit the database? &nbsp;I would do a search on the whole project and make sure that you got all instances of the variable name updated. &nbsp;If notthing else, post the code and table layout for review. &nbsp;
</div>


Are you using a stored procedure or class layer to hit the database?  I would do a search on the whole project and make sure that you got all instances of the variable name updated.  If notthing else, post the code and table layout for review.  

<div>
<div class="content wysiwyg-content">
I am working in an ASP.Net project that I inherited. &nbsp;I was doing some cleanup and found some table column names that were misspelled. &nbsp;I wanted to rename the columns so that future searches would find all instances of this name. &nbsp;So, I renamed the field in SQL using Enterprise Manager, then going to Design Table and then renaming the field. &nbsp;Then, I updated all the code with the references to the column.<br />
<br />
Now, when I am running debug testing, I get to the ExecuteNonQuery command (I am updating the table), I get the 'SqlException was caught' error. &nbsp;The errors list 'Invalid column name 'oldname'.<br />
<br />
There must be something cached somewhere but I'm not sure how to correct this.<br />
<br />
We are running Visual Studio 2005, SQL2000.<br />
Thanks for any help.
</div>
</div>


I am working in an ASP.Net project that I inherited.  I was doing some cleanup and found some table column names that were misspelled.  I wanted to rename the columns so that future searches would find all instances of this name.  So, I renamed the field in SQL using Enterprise Manager, then going to Design Table and then renaming the field.  Then, I updated all the code with the references to the column.

Now, when I am running debug testing, I get to the ExecuteNonQuery command (I am updating the table), I get the 'SqlException was caught' error.  The errors list 'Invalid column name 'oldname'.

There must be something cached somewhere but I'm not sure how to correct this.

We are running Visual Studio 2005, SQL2000.
Thanks for any help.

Invalid Column Name SQL error after renaming table field name

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications