Transaction

[simonZ]

SqlCommand oCmd;
SqlTransaction tran;

oCmd = new SqlCommand("myStoredProcedure",myFunctions.createC onnection());
oCmd.CommandType = CommandType.StoredProcedure;

tran=oCmd.Transaction.Connection.BeginTransaction( );//I get an error: null exception

Any idea?
Without tran everything works.

regards,Simon

[Chris Fulstow]

Try something like this:

SqlConnection cnn;
SqlCommand oCmd;
SqlTransaction tran;

cnn = myFunctions.createConnection();
tran = cnn.BeginTransaction();

oCmd = new SqlCommand("myStoredProcedure", cnn);
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Transaction = tran;

In your code oCmd.Transaction is still null when you try to access the
Connection property.

simonZ wrote:

SqlCommand oCmd;
SqlTransaction tran;

oCmd = new SqlCommand("myStoredProcedure",myFunctions.createC onnection());
oCmd.CommandType = CommandType.StoredProcedure;

tran=oCmd.Transaction.Connection.BeginTransaction( );//I get an error: null exception

Any idea?
Without tran everything works.

regards,Simon