automatically in a transaction?

[szabelin]

no, you have to say
SqlTransaction trans = conn.BeginTransaction();
sqlComd.Transaction = trans;
sqlCmd.executeNonQuery();

and then commit or rollback on your transaction depending
on your needs. Read up on SqlTransaction class and samples.

 

[Nick]

Thanks, it looks it's much easy to use:

dim str = "begin tran; insert......; commit tran"