Updating (inserting) into database

  • Thread starter Thread starter Leszek Gruszka
  • Start date Start date
L

Leszek Gruszka

I made connection with sql2000. I'm collecting data from database/table
(name - "Base1").
Then I'm transposing it. All is in dataset, by dataadapter etc.
I'm trying to write values to new table in the same database (name -
"Base2").
Is there any posibility to write it by UPDATE, INSERT or something like
this?
Maybe i must read and write every row from dataset, but i don't know what
names will columns have....
 
Fill the dataset with an adapter that has its AcceptChangesDuringFill
property to false. When you call fill, provided this property is set to
false, all of the rows will have a rowstate marked as Inserted. Then just
call Update with the second adapter.
 
Back
Top