我从SQL查询中删除了一个字段，但是在更新数据源配置向导后没有反映出来 [英] I deleted a field from an SQL query, but it is not reflecting after updating the Datasource configuration wizard

问题描述

大家好，

我遇到了一个奇怪的问题，我无法解决.
我从SQL 2000查询中删除了一个字段，然后转到VB.net 2008并单击了数据源配置向导以更新更改，一切正常，我未选择红色的感叹号(即我删除的字段)，它工作正常到目前为止.

而且，在数据源"窗格中，我删除的字段不再存在，因此在数据集设计器中不存在，这是正确的.

这里的问题是，当我将以数据网格视图编辑的表格拖放到表格上时，删除的字段仍然会出现，并且不会出现错误，直到我运行程序并加载包含该表格的表格为止(即列"找不到").那么如何反映我在这种情况下所做的更改.
请注意，这是我第一次发生这种情况，因为我总是进行更改，这不是问题.
在此先感谢

FIras Daw

[edit]仅标记-OriginalGriff [/edit]

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

[edit]Tags only - OriginalGriff[/edit]

推荐答案

好，我找到了解决方案，数据集自定义工具"为空白.我安装了XSDObjectGen，它会自动更新自定义工具.
:))

ok I found the solution, the dataset "Custom tool" was blank. I installed XSDObjectGen which automatically update the custom tool.
:))

我建​​议您一个解决方案.
如果您已经打开，请关闭代码.
打开您的表单所在的文件夹.
搜索给出错误的表格(来自包含数据网格)
将该表格打开到写字板中
搜索已删除的列字段.
如果得到它，则在该特定行中进行适当的更改.

我在上一个项目中尝试过此操作，但问题与您不同.
但是用同样的方法，我从卡住中得到了缓解.

I suggest you one solution.
close the code if you have open up.
open the folder where your forms are located.
search for the form which gives your error (the from contain data grid)
open that form into wordpad
search for the deleted column fields.
if you get it then make the proper changes in that particular line.

I tried this in my last project but my issue was different than you have.
but with same approach i got relief from stuck.

感谢您的快速回复，
好了，问题更复杂了，因为我打开了新表格，并将datagridview拖到新表格上，并且仍然存在相同的问题.在其中，我仍在datagridview中获取已删除的字段.
:(
问候

Thank u for ur quick reply,
Well, the problem is more complicated coz , I opened new form and I dragged the Table as datagridview to the new form and the same issue still exist. In which, i am still getting the deleted field in my datagridview.
:(
Regards

这篇关于我从SQL查询中删除了一个字段，但是在更新数据源配置向导后没有反映出来的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！