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

firas daw

16y8.5k

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

4 Replies

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

firas daw16y ago
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 Nair16y ago
how you binding the datasource from store procedure, function...?
firas daw16y ago
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 Nair16y ago
do a Crtl + F on whole project/solution for the deleted column.