[RESOLVED] Transfering Data from one part to other of database to other!!!

[GaryMazzone]

Try this and what happend?\

cmd = New OleDbCommand("Update Table1 set From_Balance= From_Balance-@Fsum where From_Bank_Name=@FBankName and  From_Account_No=@FAccountNo", con)
cmd.Parameters.AddWithValue("@Fsum", TextBox1.Text)
cmd.Parameters.AddWithValue("@FBankName", ComboBox1.Text)
cmd.Parameters.AddWithValue("@FAccountNo", ComboBox2.Text)
Dim rowseffected1 as Integer - cmd.ExecuteNonQuery()
cmd2 = New OleDbCommand("Update Table1 set To_Balance= To_Balance+@Tsum where To_Bank_Name=@TBankName and  To_Account_No=@TAccountNo", con)
cmd2.Parameters.AddWithValue("@Tsum", TextBox2.Text)
cmd2.Parameters.AddWithValue("@TBankName", ComboBox3.Text)
cmd2.Parameters.AddWithValue("@TAccountNo", ComboBox4.Text)
Dim rowsaffected As Integer = cmd2.ExecuteNonQuery
cmd.Dispose()
cmd2.Dispose()
MsgBox("Number of rows affected from first Query are: " & rowseffected1.ToString())
MsgBox("Number of rows affected from second Query are: " & rowseffected.ToString())

ps Paul I tried to tell him that at least once already