C# Datatable Local Copy

Question

I have an in memory DataTable in C#. I want to save a local copy of that on to my file system and retrive it . This C# datatable captures results from an excel formula and saves it. When the same excel file is opened again, I want to have the datatable loaded. This table is like a local cache that I want to reuse.

Is there any other structure that I can use apart from a data table for such a caching behavior?

How do I do that?

Rory · Accepted Answer · 2010-01-07 05:56:40Z

2

If you aren't really worried about the format of the output, the easiest solution are the WriteXml and ReadXml methods on the DataSet.

DataSet data = new DataSet();

// Populate from excel

data.WriteXml(fileName, XmlWriteMode.WriteSchema); // Save to file
data.ReadXml(fileName); // Restore from file

answered Jan 7, 2010 at 5:56

Rory

2,7421 gold badge20 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rodrick Chapman · Accepted Answer · 2010-01-07 05:35:25Z

0

Sounds like you want XML Serialization.

http://devhood.com/Tutorials/tutorial_details.aspx?tutorial_id=236

answered Jan 7, 2010 at 5:35

Rodrick Chapman

5,5732 gold badges33 silver badges34 bronze badges

Comments

Andrew Hare · Accepted Answer · 2010-01-07 05:40:28Z

0

I would imagine a relational database like SQL Server would work quite well (especially since you are already storing the data in a tabular structure).

answered Jan 7, 2010 at 5:40

Andrew Hare

353k75 gold badges649 silver badges642 bronze badges

1 Comment

Sandy Over a year ago

0 vote down check I do not want a database like SQL. To explain my case clearly , I have a user defined function that an excel user uses. The formula does its calculations that writes to a data table or any other object on C# . I want this data table or object to be made available when an user opens the excel file again.

Collectives™ on Stack Overflow

C# Datatable Local Copy

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related