aryaonmesh

aryaonmesh

  • NA
  • 21
  • 0

How to Assign two stored procedure

Aug 26 2004 1:55 PM
How to assign two stroed procedure in a transaction strSQL = "Update TableOne set dbalance = dBalance - " + Amt.Text + " where AccNumber = '" + txtFrom.Text + "'"; cmd.CommandText=strSQL; cmd.ExecuteNonQuery(); strSQL = "Update TableTwo set dbalance = dBalance + " + Amt.Text + " where AccNumber = '" + txtTo.Text + "'"; cmd.CommandText = strSQL; cmd.ExecuteNonQuery(); Above is using two Sql statements in a transaction. I want to use two SP in a transaction. HOw to do? Help greatly apprecitated Thanks in advance

Answers (3)