By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,126 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,126 IT Pros & Developers. It's quick & easy.

No Delete or Update Commands

P: n/a
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?
Feb 27 '07 #1
Share this Question
Share on Google+
13 Replies


P: n/a
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...
>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?

Feb 28 '07 #2

P: n/a
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:
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...
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?


Feb 28 '07 #3

P: n/a
Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:EA**********************************@microsof t.com...
>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?

Feb 28 '07 #4

P: n/a
Vernon,

I have almost the same effect if there is a timestamp in the data, is it
like that?

Cor
..
"Vernon Peppers" <Ve***********@discussions.microsoft.comschreef in
bericht news:D7**********************************@microsof t.com...
>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:
>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...
>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?



Feb 28 '07 #5

P: n/a
Yes, it does. I am aware that without the primary key being assigned in the
table adapter, there will be no Delete and Update, but I have that assigned.

"RobinS" wrote:
Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:EA**********************************@microsof t.com...
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?


Mar 1 '07 #6

P: n/a
There is no time stamp. It's a pretty vanilla table. Just a few strings,
along with an autonumber ID field set as the primary key.

"Cor Ligthert [MVP]" wrote:
Vernon,

I have almost the same effect if there is a timestamp in the data, is it
like that?

Cor
..
"Vernon Peppers" <Ve***********@discussions.microsoft.comschreef in
bericht news:D7**********************************@microsof t.com...
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:
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...
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?


Mar 1 '07 #7

P: n/a
I found this confusing:
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.
If I assume that you meant columns, does that mean you only have one
column? If so, that might explain why you can't update it, with it being a
primary key. Try adding some more fields to your table and regenerating
your dataset and see what it does.

Robin S.
----------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:77**********************************@microsof t.com...
Yes, it does. I am aware that without the primary key being assigned in
the
table adapter, there will be no Delete and Update, but I have that
assigned.

"RobinS" wrote:
>Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:EA**********************************@microso ft.com...
>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?



Mar 1 '07 #8

P: n/a
I'm a dope. I meant columns, not rows. I have no data in the table, as I
haven't been able to Update.

"RobinS" wrote:
I found this confusing:
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.

If I assume that you meant columns, does that mean you only have one
column? If so, that might explain why you can't update it, with it being a
primary key. Try adding some more fields to your table and regenerating
your dataset and see what it does.

Robin S.
----------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:77**********************************@microsof t.com...
Yes, it does. I am aware that without the primary key being assigned in
the
table adapter, there will be no Delete and Update, but I have that
assigned.

"RobinS" wrote:
Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:EA**********************************@microsof t.com...
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?


Mar 1 '07 #9

P: n/a
It's okay, I just wanted to make sure I was understand. So you can't get
Insert to work, either, huh?

Just for grins, now that the table is there, try creating your dataset
again. To just create a dataset, right-click on your project, choose Add
New Item, and pick Data Set.

After it's created, click on the table adapter, and look at the properties.
Are the command objects given?

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
---------------------------------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:26**********************************@microsof t.com...
I'm a dope. I meant columns, not rows. I have no data in the table, as
I
haven't been able to Update.

"RobinS" wrote:
>I found this confusing:
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.

If I assume that you meant columns, does that mean you only have one
column? If so, that might explain why you can't update it, with it being
a
primary key. Try adding some more fields to your table and regenerating
your dataset and see what it does.

Robin S.
----------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:77**********************************@microso ft.com...
Yes, it does. I am aware that without the primary key being assigned
in
the
table adapter, there will be no Delete and Update, but I have that
assigned.

"RobinS" wrote:

Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:EA**********************************@microso ft.com...
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?



Mar 1 '07 #10

P: n/a
Nope. Same result. No Update command, no Delete command.

"RobinS" wrote:
It's okay, I just wanted to make sure I was understand. So you can't get
Insert to work, either, huh?

Just for grins, now that the table is there, try creating your dataset
again. To just create a dataset, right-click on your project, choose Add
New Item, and pick Data Set.

After it's created, click on the table adapter, and look at the properties.
Are the command objects given?

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
---------------------------------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:26**********************************@microsof t.com...
I'm a dope. I meant columns, not rows. I have no data in the table, as
I
haven't been able to Update.

"RobinS" wrote:
I found this confusing:

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.

If I assume that you meant columns, does that mean you only have one
column? If so, that might explain why you can't update it, with it being
a
primary key. Try adding some more fields to your table and regenerating
your dataset and see what it does.

Robin S.
----------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:77**********************************@microsof t.com...
Yes, it does. I am aware that without the primary key being assigned
in
the
table adapter, there will be no Delete and Update, but I have that
assigned.

"RobinS" wrote:

Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:EA**********************************@microsof t.com...
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?



Mar 1 '07 #11

P: n/a
Are there Insert and Select command objects?

Robin S.
-----------------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:51**********************************@microsof t.com...
Nope. Same result. No Update command, no Delete command.

"RobinS" wrote:
>It's okay, I just wanted to make sure I was understand. So you can't get
Insert to work, either, huh?

Just for grins, now that the table is there, try creating your dataset
again. To just create a dataset, right-click on your project, choose Add
New Item, and pick Data Set.

After it's created, click on the table adapter, and look at the
properties.
Are the command objects given?

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
---------------------------------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:26**********************************@microso ft.com...
I'm a dope. I meant columns, not rows. I have no data in the table,
as
I
haven't been able to Update.

"RobinS" wrote:

I found this confusing:

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.

If I assume that you meant columns, does that mean you only have one
column? If so, that might explain why you can't update it, with it
being
a
primary key. Try adding some more fields to your table and
regenerating
your dataset and see what it does.

Robin S.
----------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:77**********************************@microso ft.com...
Yes, it does. I am aware that without the primary key being
assigned
in
the
table adapter, there will be no Delete and Update, but I have that
assigned.

"RobinS" wrote:

Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote
in
message
news:EA**********************************@microso ft.com...
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?




Mar 1 '07 #12

P: n/a
Yes, the insert and select commands are there.

"RobinS" wrote:
Are there Insert and Select command objects?

Robin S.
-----------------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:51**********************************@microsof t.com...
Nope. Same result. No Update command, no Delete command.

"RobinS" wrote:
It's okay, I just wanted to make sure I was understand. So you can't get
Insert to work, either, huh?

Just for grins, now that the table is there, try creating your dataset
again. To just create a dataset, right-click on your project, choose Add
New Item, and pick Data Set.

After it's created, click on the table adapter, and look at the
properties.
Are the command objects given?

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
---------------------------------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:26**********************************@microsof t.com...
I'm a dope. I meant columns, not rows. I have no data in the table,
as
I
haven't been able to Update.

"RobinS" wrote:

I found this confusing:

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.

If I assume that you meant columns, does that mean you only have one
column? If so, that might explain why you can't update it, with it
being
a
primary key. Try adding some more fields to your table and
regenerating
your dataset and see what it does.

Robin S.
----------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:77**********************************@microsof t.com...
Yes, it does. I am aware that without the primary key being
assigned
in
the
table adapter, there will be no Delete and Update, but I have that
assigned.

"RobinS" wrote:

Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote
in
message
news:EA**********************************@microsof t.com...
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?




Mar 1 '07 #13

P: n/a
Figures. Maybe the delete and update commands aren't created because you
have no data in the table to delete or update. What if you add a couple of
rows (in Server Explorer, open until you find the table, and right-click on
it and choose ShowTableData. Then you can type some data into the table.
This is not unlike Access; you have to hit return or go to a different line
to commit the change on a line.

Then try recreating your dataset and see if the Update and Delete commands
are created.
Robin S.
---------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in message
news:0D**********************************@microsof t.com...
Yes, the insert and select commands are there.

"RobinS" wrote:
>Are there Insert and Select command objects?

Robin S.
-----------------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:51**********************************@microso ft.com...
Nope. Same result. No Update command, no Delete command.

"RobinS" wrote:

It's okay, I just wanted to make sure I was understand. So you can't
get
Insert to work, either, huh?

Just for grins, now that the table is there, try creating your
dataset
again. To just create a dataset, right-click on your project, choose
Add
New Item, and pick Data Set.

After it's created, click on the table adapter, and look at the
properties.
Are the command objects given?

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
---------------------------------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote in
message
news:26**********************************@microso ft.com...
I'm a dope. I meant columns, not rows. I have no data in the
table,
as
I
haven't been able to Update.

"RobinS" wrote:

I found this confusing:

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.

If I assume that you meant columns, does that mean you only have
one
column? If so, that might explain why you can't update it, with it
being
a
primary key. Try adding some more fields to your table and
regenerating
your dataset and see what it does.

Robin S.
----------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.comwrote
in
message
news:77**********************************@microso ft.com...
Yes, it does. I am aware that without the primary key being
assigned
in
the
table adapter, there will be no Delete and Update, but I have
that
assigned.

"RobinS" wrote:

Does your table have a primary key assigned?

Robin S.
--------------------------------
"Vernon Peppers" <Ve***********@discussions.microsoft.com>
wrote
in
message
news:EA**********************************@microso ft.com...
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?





Mar 2 '07 #14

This discussion thread is closed

Replies have been disabled for this discussion.