Posted on: 4/18/2014 7:31:56 PM | Views : 583

Dear All, 
I am using the following code for implemeting transactioscope.

Try Using ts = New TransactionScope() Using db_acc = New SqlConnection(ConfigurationManager.AppSettings("connectionString")) 'db_acc.Open() Using sqlcmd_acc As SqlCommand = db_acc.CreateCommand() sqlcmd_acc.CommandType = Data.CommandType.Text sqlcmd_acc.CommandText = String.Format("INSERT INTO bill_main VALUES (" & CInt(bill_no.Text.ToString) & ",'" _ & c.ToString & "','" _ & rfr.Value.ToString & "'," & CDbl(ttsrv.Text.ToString) & "," & CDbl(srvtx.Text.ToString) & "," & CDbl(tt.Text.ToString) & "," & CInt(ct.Value.ToString) & ",'Pending','" & findcustID(clt_nm.Text.ToString) & "',1,'" & txt_dt.Text & "',0,0,0,0," & CDbl(tt.Text.ToString) & ")&quo ...

Go to the complete details ...