Where does the Windows store the DataSet?

[Jason Huang]

Hi,

In our C# Windows application project, we have a DataSet resulting from the
query string.
I'm wondering where does the Windows XP store the DataSet, and what's the
size of the DataSet.
Thanks for help.


Jason

 

[meh]

Unless you are persisting it then it is resident in memory.
There are many ways to persist i.e.

ds = new DataSet("myData");
da = new SqlDataAdapter(cmd);

da.Fill(ds, "myData");
table = ds.Tables[0];
//Places the file in this app's bin directory
ds.WriteXmlSchema(Application.StartupPath + "\\bin\\" +
"myData.xsd");
ds.WriteXml(Application.StartupPath + "\\bin\\" +
"myData.xml");
cn.Close();
cn.Dispose();

hope this helps
meh