具有存储过程的 Visual Studio 数据集设计器？这个图标是什么
这个图标的意思是Visual studio，可视化数据集设计器。 我有几个存储过程。
你能帮我理解
- 为什么列表顶部的那个有一个 小“复选标记”
- 为什么我无法在需要时删除它。
- 其余的情况并非如此。 为什么这很“特别”？
谢谢
What does this icon mean is Visual studio, visual Data Set designer.
I have several stored procedures.
can you help me understand,
- why the one on top of the list has a
small "check mark" - why I can't delete it if I need to.
- This is not the case with the rest.
Why is this "special" ?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
因为该项目包含定义 TableAdapter 所属表的架构的方法。
默认名称为 Fill 和 GetData。看来你给它们重命名了。
Because that item contains the method(s) that define the schema of the table the TableAdapter is part of.
The default names are Fill and GetData. Looks like you renamed them.
每个表都有一个默认查询（顶部带有检查的查询）。当您将表拖入数据集以创建查询时，它会编写一条 SQL 语句，用于架构您的表。保持该查询简单，您可能实际上不会在代码中使用它，并且您始终可以编辑该查询以更新表架构。在您提供的图片中，您的默认查询实际上是一个存储过程。
每次打开默认查询时，它都会连接到您的数据源，并允许您选择以前不存在的新列。如果要更新现有列，请在尝试打开查询之前从表中删除所有列。当您保存查询时，更新的列将被添加回来。
确保您的连接字符串有权查看列信息。
Each table has a default query (The one on top with the check on it). When you dragged your tables in to the dataset to create the query, it wrote a SQL statement which it uses to schema your table. Keep that query simple, you might not actually use it in code, and you can always edit that query to update the table schema. In the picture you provided, your default query is actually a stored procedure.
Every time you open the default query it connects to your datasource and allows you to select new columns that weren't in there before. If you want to update your existing columns, delete all the columns out of the table before you attempt to open the query. When you save the query, your updated columns get added back.
Make sure your connection string has permissions to view column information.