can write but cant read :(

hello!

i'm working on a project for pocket pc, which is an app that registers customers, suppliers, stocks and orders. all this is stored in the ppc itself using the SQL CE server.

i'm programming with VS2005, which is great, the tableadapters make the work lot easier.
i'm just having some problems importing and exporting data from the sql tables to files.
the export function works quiet well, i just load the data from the tableadapter into a table and then use the WriteXml(file) function.

Now, for importing I do more or less the same thing:
DataSetrTableAdapters.Customers cta = new ... etc etc
DataSetr.CustomersDataTable cdt = new DataSetr.CustomersDataTable();
cdt.ReadXml("\\My Documents\\customers.xml");
cta.Update(cdt);

result: empty table! :(
i also tried adding cta.Fill(cdt) before the update, but the result is the same....
any suggestions

thank you very much


Answer this question

can write but cant read :(

  • iven stone

    Try using XmlWriteMode.WriteSchema on the write side, and this may make the Read behave more predictably.
  • can write but cant read :(