没有删除或更新命令 [英] No Delete or Update Commands

问题描述

我正在使用VS2005。我创建了一个Windows Appication项目。在

服务器资源管理器中，我创建了一个新的SQLExpress数据库，然后创建了一个新的

表。我添加了行，使我的第一行成为整数，并将

标识属性设置为true。我将该行设置为我的主键。然后我在
添加了一个数据集，并将我的表添加到数据集中。当我配置

表时，我没有更新或删除命令，即使向导具有

相应的选中标记，并且最终屏幕显示它创建了这些

命令。如何创建这些命令？

I am using VS2005. I created a Windows Appication project. Inside the
Server Explorer, I created a new SQLExpress database, and then created a new
table. I added the rows, making my first row an integer, and setting the
identity property to true. I set that row to be my primary key. I then
added a dataset, and added my table to the dataset. When I configure the
table, I have no Update or Delete commands, even though the wizard has the
appropriate checkmarks, and the final screen says that it created these
commands. How do I create these commands?

推荐答案

Vernon，


您使用的是什么向导。一个SQLExpress数据库完全独立

来自一个程序。


这些之间的联系可能是无穷无尽的，一个简单的例子是

使用数据源。

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252


Cor

Vernon Peppers < Ve *********** @ discussion.microsoft.comschreef

bericht新闻：EA ***************** ***************** @ microsof t.com ...

Vernon,

What wizards are you using. A SQLExpress database is completely independent
from a program.

The connections between those can be endless, a simple sample for this is
using the datasource.

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252

Cor

"Vernon Peppers" <Ve***********@discussions.microsoft.comschreef in
bericht news:EA**********************************@microsof t.com...

>我正在使用VS2005。我创建了一个Windows Appication项目。在

服务器资源管理器中，我创建了一个新的SQLExpress数据库，然后创建了一个

新的

表。我添加了行，使我的第一行成为整数，并将

标识属性设置为true。我将该行设置为我的主键。然后我在
添加了一个数据集，并将我的表添加到数据集中。当我配置

表时，我没有更新或删除命令，即使向导具有

相应的选中标记，并且最终屏幕显示它创建了这些

命令。如何创建这些命令？

>I am using VS2005. I created a Windows Appication project. Inside the
Server Explorer, I created a new SQLExpress database, and then created a
new
table. I added the rows, making my first row an integer, and setting the
identity property to true. I set that row to be my primary key. I then
added a dataset, and added my table to the dataset. When I configure the
table, I have no Update or Delete commands, even though the wizard has the
appropriate checkmarks, and the final screen says that it created these
commands. How do I create these commands?

我进入了Server Explorer，并选择了Add Connection。然后我将DataSet添加到我的项目中，然后使用TableAdapter

配置向导进行配置。我意识到有很多方法可以与SQL Server建立连接，但这是使用SQLExpress数据库直接内置到
Visual Studio的方式。


" Cor Ligthert [MVP]"写道：

I went into the Server Explorer, and chose "Add Connection". I then added
the DataSet to my project, and then configured it with the TableAdapter
Configuration Wizard. I realize that there are myriad ways to make a
connection to a SQL Server, but this is the way that is built right into
Visual Studio, using the SQLExpress database.

"Cor Ligthert [MVP]" wrote:

弗农，


来自一个程序。


这些之间的联系可能是无穷无尽的，一个简单的例子是

使用数据源。

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252


Cor

Vernon Peppers < Ve *********** @ discussion.microsoft.comschreef

bericht新闻：EA ***************** ***************** @ microsof t.com ...

Vernon,

What wizards are you using. A SQLExpress database is completely independent
from a program.

The connections between those can be endless, a simple sample for this is
using the datasource.

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252

Cor

"Vernon Peppers" <Ve***********@discussions.microsoft.comschreef in
bericht news:EA**********************************@microsof t.com...

我正在使用VS2005。我创建了一个Windows Appication项目。在

服务器资源管理器中，我创建了一个新的SQLExpress数据库，然后创建了一个

新的

表。我添加了行，使我的第一行成为整数，并将

标识属性设置为true。我将该行设置为我的主键。然后我在
添加了一个数据集，并将我的表添加到数据集中。当我配置

表时，我没有更新或删除命令，即使向导具有

相应的选中标记，并且最终屏幕显示它创建了这些

命令。如何创建这些命令？

I am using VS2005. I created a Windows Appication project. Inside the
Server Explorer, I created a new SQLExpress database, and then created a
new
table. I added the rows, making my first row an integer, and setting the
identity property to true. I set that row to be my primary key. I then
added a dataset, and added my table to the dataset. When I configure the
table, I have no Update or Delete commands, even though the wizard has the
appropriate checkmarks, and the final screen says that it created these
commands. How do I create these commands?

您的桌子是否分配了主键？


Robin S.

--------------------------------

Vernon Peppers < Ve *********** @ discussion.microsoft.com写信息

新闻：EA ***************** ***************** @ microsof t.com ...

Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:EA**********************************@microsof t.com...

>我正在使用VS2005。我创建了一个Windows Appication项目。在

服务器资源管理器中，我创建了一个新的SQLExpress数据库，然后创建了一个

新的

表。我添加了行，使我的第一行成为整数，并将

标识属性设置为true。我将该行设置为我的主键。然后我在
添加了一个数据集，并将我的表添加到数据集中。当我配置

表时，我没有更新或删除命令，即使该向导具有

相应的选中标记和最终结果屏幕上说它创建了这些

命令。如何创建这些命令？

>I am using VS2005. I created a Windows Appication project. Inside the
Server Explorer, I created a new SQLExpress database, and then created a
new
table. I added the rows, making my first row an integer, and setting the
identity property to true. I set that row to be my primary key. I then
added a dataset, and added my table to the dataset. When I configure the
table, I have no Update or Delete commands, even though the wizard has
the
appropriate checkmarks, and the final screen says that it created these
commands. How do I create these commands?

这篇关于没有删除或更新命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！