How to update CSV file by OleDBDataAdapter?

  • Thread starter Thread starter Evgeny Zoldin
  • Start date Start date
E

Evgeny Zoldin

Hi ALL,

there a lot of examples how to read data from CSV file, but I could not find
any about how to save changed or newly inserted data back to the file. I
tried to call method Update on OleDbDataAdapter which filled respective
table, but debugger jumped out of the called function back to the caller
without any exception, while no chaged data were saved into the CSV file!

Why oDataAdapter.Update( oDataTable ) does not work and is it possible to
save changes "automatically" (not "manually" - row by row, field by
field...)?

Thanks
 
Hi,

you cannot open any text file in an updatable mode. This is a limitation.
You would need to find another way to do this - writing directly to the
file, but not through the Oledb Provider
 
Back
Top