SQL changes are not reflecting on VB.et after Datasource configuration wizard

Question

Hi all I have a strange problem that occurred with me and I am not able to solve. I deleted a field from SQL 2000 query then I went to my VB.net 2008 and hit the Datasource configuration wizard to update the changes Everything was ok and I unselected the red exclamation mark which is the field I deleted it was working fine so far. Moreover in the Datasource pane the field that I deleted is no longer exists and so it doesn't exist in the Dataset designer which is correct. HERE IS THE PROBLEM when I drag and drop the table that I edited as a datagridview then the field I had deleted is still appearing and no errors appears until I run my program and load the form that includes this table (it is saying Column is not found). So How to reflect the changes I made in this case. Note that it is the first time this case happens with me coz I always make changes and it is wasn't an issue. Thanks in advance FIras Daw

firas daw · Answer

I first made the connection as normal Data source connection and the datagrids and textboxes are through  kindly find the attached for more details Thanks :)

Suthish Nair · Answer

how you binding the datasource from store procedure function...?

firas daw · Answer

Santhish  thank u for ur reply  but the issue is quite different coz I the fields that i deleted from the query in SQL and which reflected correctly when I went trough the Datasource configuration wizard (i mean that the deleted fields disappeared from the dataset tables and from the tables in the Data Source pane). but if I dragged it from the data source the issue showed up because the deleted field appears and so it is appearing in the Databinding for the texboxes. :(

Suthish Nair · Answer

do a Crtl + F on whole project/solution for the deleted column.