Member Avatar for Anwar_2

I have a dataTable with records and I want to insert those records in another table in database, so I was writing

adapter.insertcommand="Insert into SourceTable(select * from " & DataTable &")"

but this code does't work.
help me out...

  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by jireh
Member Avatar for jireh

make sure to supply the correct number of fields. the best way is to elaborate it one by one.

insert into table1(field1,field2,field3) select field1,field2,field3 from table2
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.