Loading

ho can i copy table records to another table..

Yogie Riadie

15y2.2k

hi..

i have two table in my data base..

1. common task (filled with 62 basic task)
2. task

then when the form is loaded i want to copy the 62 basic task in commonTask table to task table..
so anyone can help me please...

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
query got resolved?
0
Suthish Nair15y ago
Yogie,

Welcome to C# Corner.

You need to explain your query in detail...

"when the form is loaded i want to copy"

you want to do the copy on Form or at DB level
0
sanjay dobhal15y ago
if Structure is same of Both Table.. Then just Fire... Insert into Table1 select * from Table2... This will copy all record from table 2 to table1
0
Krishna Garad15y ago
yes you can do it. If the structure of both table is same then just fire insert query on task table which will take values from commontask by select query.
0