没有删除或更新命令 [英] 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屋!