Error when using transaction

Question

Possible Duplicate:
ExecuteNonQuery requires the command to have a transaction error in my code

strSQL = "insert into............";

SqlTransaction objSqlTransaction = Master.objSqlDbComm.SqlConnectionObject.BeginTransaction();
try
{
    Master.objSqlDbComm.ExecuteNonQuery(strSQL);
    objSqlTransaction.Commit();
}
catch(Exception)
{
    objSqlTransaction.Rollback();
}
finally
{
    objSqlTransaction.Dispose();
}

When I use above code getting error

ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.

You need to set reference of Transaction object `objSqlTransaction` to `command.Transaction` property. — KV Prajapati, Dec 03 '12 at 05:47
When you get an error message, type it into google and click the first link that leads to stack overflow. Chances are above average that that's your answer! — Sergey Kalinichenko, Dec 03 '12 at 05:49

Ravindra Bagale · Accepted Answer · 2012-12-03T06:00:12.183

1

you need to give command object to ExecuteNonQuery

do something like this:

SqlCommand cmd = new SqlCommand(your_sqlText, your_sqlcon, your_sqlTrans);  

    cmd.ExecuteNonQuery();

edited Dec 03 '12 at 06:00

answered Dec 03 '12 at 05:48

Ravindra Bagale

17,226
9
43
70

why i have to create new sqlcommand object. – lax Dec 03 '12 at 05:54
@lax: because executenonquery is method of command object – Ravindra Bagale Dec 03 '12 at 05:56

Error when using transaction

1 Answers1