Transaction

[simonZ]

SqlCommand oCmd;
SqlTransaction tran;

oCmd = new SqlCommand("myStoredProcedure",myFunctions.createConnection());
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.