firas daw

firas daw

  • NA
  • 5
  • 0

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

Nov 1 2010 1:37 AM
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

Answers (4)