DeleteCommand.e xecutenonquery with ADO.NET - How do I know if a record was deleted?

[Rodger Dusatko]

After entering the sql statement da.deletecomman d.commandtext = "Delete from
Users where username = @username" I set the parameter to the username I wish
to delete.

This successfully deletes the user. However, even if I enter an non-existant
user, I cannot discern whether a user was deleted or not. Is there a way to
do this? (I would rather not use a dataset, since I am trying to increase
performance).

thanks in advance

Rodger Dusatko

[Armin Zingler]

"Rodger Dusatko" <ro****@dusatko .com> schrieb

After entering the sql statement da.deletecomman d.commandtext =
"Delete from Users where username = @username" I set the parameter to
the username I wish to delete.

This successfully deletes the user. However, even if I enter an
non-existant user, I cannot discern whether a user was deleted or
not. Is there a way to do this? (I would rather not use a dataset,
since I am trying to increase performance).

There's an ADO.Net group for ADO.Net related questions:
microsoft.publi c.dotnet.framew ork.adonet
--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Cor Ligthert]

Hi Rodger,

Then you want only to do deletecommands, have than a look at the normal
command executecommands

http://msdn.microsoft.com/library/de...querytopic.asp

When you have more questions about that I advice you as well to ask it in
the newsgroup Armin did pointed you on.

Cor

[Jay B. Harlow [MVP - Outlook]]

Rodger,
Have you looked at the return value from ExecuteNonQuery , it returns the #
of rows affected.

Something like (untested):
Dim deleteCommand As SqlCommand

If deleteCommand.E xecuteNonEquery () = 0 then
MessageBox.Show "User not Deleted"
End If

Hope this helps
Jay

"Rodger Dusatko" <ro****@dusatko .com> wrote in message
news:c9******** *****@news.t-online.com...

After entering the sql statement da.deletecomman d.commandtext = "Delete from Users where username = @username" I set the parameter to the username I wish to delete.

This successfully deletes the user. However, even if I enter an non-existant user, I cannot discern whether a user was deleted or not. Is there a way to do this? (I would rather not use a dataset, since I am trying to increase
performance).

thanks in advance

Rodger Dusatko

[Rodger Dusatko]

Thanks! That was the answer.
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> schrieb im
Newsbeitrag news:eA******** ******@TK2MSFTN GP12.phx.gbl...

Rodger,
Have you looked at the return value from ExecuteNonQuery , it returns the #
of rows affected.

Something like (untested):
Dim deleteCommand As SqlCommand

If deleteCommand.E xecuteNonEquery () = 0 then
MessageBox.Show "User not Deleted"
End If

Hope this helps
Jay

"Rodger Dusatko" <ro****@dusatko .com> wrote in message
news:c9******** *****@news.t-online.com...

After entering the sql statement da.deletecomman d.commandtext = "Delete

from

Users where username = @username" I set the parameter to the username I

wish

to delete.

This successfully deletes the user. However, even if I enter an

non-existant

user, I cannot discern whether a user was deleted or not. Is there a way

to

do this? (I would rather not use a dataset, since I am trying to increase performance).

thanks in advance

Rodger Dusatko