How to transfer a data from one table to another

Question

 

  cmd.CommandText = "insert into TBL_DEPOSITTRANS (DepositName, AccountNo, Receipt, InterestAmt, Date1, TransNo) select (name, acc_no, amount, fine, date, recept_no ) from temp WHERE status='N'"
      

but during execution an error occured like

Incorrect syntax near ','

Answer 1

Does the table tbl_DepositTrans have any triggers?

Also, you don't need () after SELECT. In other words, your code should be

cmd.CommandText = "insert into TBL_DEPOSITTRANS (DepositName, AccountNo, Receipt, InterestAmt, Date1, TransNo) select name, acc_no, amount, fine, date, recept_no FROM temp WHERE status='N'"
      

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

 

  cmd.CommandText = "insert into TBL_DEPOSITTRANS (DepositName, AccountNo, Receipt, InterestAmt, Date1, TransNo) select (name, acc_no, amount, fine, date, recept_no ) from temp WHERE status='N'"
      

but during execution an error occured like

Incorrect syntax near ','

you dont need brackets with Select statement..

cmd.CommandText = "insert into TBL_DEPOSITTRANS (DepositName, AccountNo, Receipt, InterestAmt, Date1, TransNo) select name, acc_no, amount, fine, date, recept_no from temp WHERE status='N'"

Try this it will work )

---

Please Mark as Answer if my post works for you or Vote as Helpful if it helps you. Kapil Singh