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

Answer 1

A db with indices can also be fast tho :)

I think it depends pretty much on what kind of data you would like to store, what you want to to use it for and how you use it.

Answer 2

What kind of files you have? Storing in binary format may be the faster unless you are doing any search kind of operations.