Successfully executing queries

[John]

Hi

I need to run separate insert & update queries. I suppose I can use
execute.nonquery to execute the queries. How can I tell if the queries were
successful?

Thanks

Regards

[Sahil Malik [MVP C#]]

The simplest way is to check the return value of that method, and see the
number of rows affected. Alternatively, you could add some exception
throwing stuff in your SQL commands.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
__________________________________________________ ________

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:uq**************@TK2MSFTNGP03.phx.gbl...

Hi

I need to run separate insert & update queries. I suppose I can use
execute.nonquery to execute the queries. How can I tell if the queries
were successful?

Thanks

Regards

[Cor Ligthert [MVP]]

John,

Be aware that if you do use the executenonquery to update, than you have not
the inbuild concurency checking from the dataadapter. (checking if the old
is not already changed).

Just as little warning,

Cor

"John" <Jo**@nospam.infovis.co.uk> schreef in bericht
news:uq**************@TK2MSFTNGP03.phx.gbl...

Hi

I need to run separate insert & update queries. I suppose I can use
execute.nonquery to execute the queries. How can I tell if the queries
were successful?

Thanks

Regards