ExecuteNonQuery

[.]

Hi,

I'm studying for a Microsoft exam.

Can you tell me what will be returned if say I try to update a table in a
database using something like:
myCommand.ExecuteNonQuery();

and no rows are actually updated? Will it return zero?

Thanks.

[Nicholas Paldino [.NET/C# MVP]]

..,

It should return zero.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"." <do*@dotworld.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi,

I'm studying for a Microsoft exam.

Can you tell me what will be returned if say I try to update a table in a
database using something like:
myCommand.ExecuteNonQuery();

and no rows are actually updated? Will it return zero?

Thanks.

[Alan Pretre]

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:OV**************@TK2MSFTNGP11.phx.gbl...

It should return zero.

Can you tell me what will be returned if say I try to update a table in a database using something like:
myCommand.ExecuteNonQuery();

and no rows are actually updated? Will it return zero?

However, CREATE TABLE and DROP TABLE return -1, not 0.

-- Alan

[.]

Thanks all.
"Alan Pretre" <no@spam> wrote in message
news:OK*************@tk2msftngp13.phx.gbl...

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in message news:OV**************@TK2MSFTNGP11.phx.gbl...

It should return zero.

Can you tell me what will be returned if say I try to update a table

in a database using something like:
myCommand.ExecuteNonQuery();

and no rows are actually updated? Will it return zero?

However, CREATE TABLE and DROP TABLE return -1, not 0.

-- Alan