sabdul_haq
New member
- Joined
- Aug 7, 2005
- Messages
- 2
- Programming Experience
- 1-3
Hi,
I'm a new member, I need some help.
Can anyone tell how to copy records from one table to another table with the same columns using dataset and dataadapter.I'm using MS Access and VB .Net.
i'm trying to use importrow method as follows but its not working :
"row" is from the first table.
ds.Tables("TargetTable").ImportRow(row)
.... proper insert query
da.update(ds,"TargetTable")
i'm also trying to copy the required row directly to the target table in dataset but it says
"this row already belongs to another table".
can anyone help.Its quite urgent
regards
Abdulhaq
I'm a new member, I need some help.
Can anyone tell how to copy records from one table to another table with the same columns using dataset and dataadapter.I'm using MS Access and VB .Net.
i'm trying to use importrow method as follows but its not working :
"row" is from the first table.
ds.Tables("TargetTable").ImportRow(row)
.... proper insert query
da.update(ds,"TargetTable")
i'm also trying to copy the required row directly to the target table in dataset but it says
"this row already belongs to another table".
can anyone help.Its quite urgent
regards
Abdulhaq
Last edited: