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 ...