About transaction processing

ruanzhe

I set a function for transaction processing, I do not know how to keep reporting this error, please which heroes correct me,
public bool updateDataBaseWithTran (string tempstr, string connstr)
{
this.Conn = new SqlConnection (connstr);
Conn.Open ();
SqlTransaction tx = Conn.BeginTransaction ();

SqlCommand tempCmd = new SqlCommand ();
tempCmd.Connection = Conn;
tempCmd.CommandType = CommandType.Text;
tempCmd.CommandText = tempstr;
try
{
     tempCmd.ExecuteNonQuery ();
     tx.Commit ();
     Conn.Close ();
     return true;
}
catch (Exception ex)
{
tx.Rollback ();
MessageBox.Show (ex.Message);
return false;
}
}

The error is:
When a connection assigned to a local is in a pending local transaction, the command must have a transaction object to execute. The TRansaction attribute of this command has not been initialized.

tsh6969

SqlTransaction tx = Conn.BeginTransaction ();

SqlCommand tempCmd = new SqlCommand ();

Change to
SqlCommand tempCmd = new SqlCommand ();
SqlTransaction tx = Conn.BeginTransaction ();

ruanzhe

No, it still reports the same error!

丢丢猫

Modify the program:
SqlTransaction tx = null;
using (tx = Conn.BeginTransaction ())
{
   SqlCommand tempCmd = new SqlCommand ();
tempCmd.Connection = Conn;
tempCmd.CommandType = CommandType.Text;
tempCmd.CommandText = tempstr;
try
{
     tempCmd.ExecuteNonQuery ();
     tx.Commit ();
     Conn.Close ();
     return true;
}
catch (Exception ex)
{
tx.Rollback ();
MessageBox.Show (ex.Message);
return false;
}
}

江南小色

Don't you tell me the error message?
SqlCommand.Transaction is not set

江南小色

tempCmd.Connection = Conn;
tempCmd.Transaction = Conn.BeingTransaction ();

starsport

using System.Transaction;

xxxTableAdapter xxxTA = new xxxTableAdapter ();

using (TransactionScope ts = new TransactionScope)
{
     xxxTA.Insert ("aa", "bb", "cc");
     xxxTA.Update ("dd", "ee", "mm", "cc");

     
     ts.Complete (); // Complete the transaction, write on success, or roll back automatically

}
Switch to .net 2.0. Convenient

tsh6969

Khan, only to discover that the landlord you forgot a key thing, your CommandText is not a query operation?
Need to add a sentence:
tempCmd.Transaction = tx;
I'm sure right now

tsh6969

Because your connection is already occupied by a transaction, all non-query operations should be performed with this transaction

kalian2000

SqlTransaction tx = Conn.BeginTransaction ();

SqlCommand tempCmd = new SqlCommand ();
tempCmd.Connection = Conn;
tempCmd.CommandType = CommandType.Text;
tempCmd.CommandText = tempstr;
// Add this sentence ..
tempCmd.Transaction = tx;