Hi All,
I am generating temporary xml files to bind it to tree view control.
A unique xml file is generated for each user. I generating these files
Using streamwriter class. Later when I try to delete the file with
File.Dlete in page unload event I gets an error File already in use by
another process. When I examine process explorer aspnet_wp.exe is hold
these files.
Here is the code I am working on.. Any advise please.
Thanks in advance
Rao
private void Page_UnLoad(obj ect sender, System.EventArg s e)
{
try
{
if (File.Exists(Se rver.MapPath(xm lDocPath+Projec tsDoc)))
{ ProjectTree.Dis pose();
File.Delete(Ser ver.MapPath(xml DocPath+Project sDoc));
}
}
catch(Exception ex)
{SetErrorMessag e(ex.Message.To String(),true);
}
}
private void InitializeTreeV iew()
{
//Add data to treeview based on the projectXML stored procedure
//ProjectTree.Tre eNodeSrc=
DataRetrieval.f ormatXMLforTree ("eacollin.Proj ectXML");
ProjectsDoc=Dat aRetrieval.Prep areProjectsXMLd oc("eacollin.Pr ojectXML");
ProjectTree.Tre eNodeSrc= Server.MapPath( xmlDocPath+Proj ectsDoc);
ProjectTree.Def aultStyle.CssTe xt="color: black;font-family:
verdana;font-size: 8pt;";
ProjectTree.Dat aBind();
ProjectTree.Dis pose();
}
private void InitializeCompo nent()
{
this.Load += new System.EventHan dler(this.Page_ Load);
this.Unload+=ne w System.EventHan dler(this.Page_ UnLoad);
//ProjectTree.Unl oad+=new System.EventHan dler(this.Delet eXmlFiles);
}
public static string PrepareProjects XMLdoc(string SPname)
{
// added by rao 8/27/2004
// added projects cache to avoid round trip to sql server, and
// additional processing involved in process returned xml from
// stored procedure
string strXML;
strXML="";
DataSet ds=new DataSet();
string OutFileName="";
System.IO.Strin gWriter strWriter = new StringWriter();
try
{
if(System.Web.H ttpContext.Curr ent.Cache["Projects"]==null)
{
ds = SqlHelper.Execu teDataset(Confi gurationSetting s.AppSettings[ASPNET.StarterK it.TimeTracker. Web.Global.CfgK eyConnString],
SPname);
strXML = "";
ds.WriteXml(str Writer);
strXML = strWriter.ToStr ing();
//get rid of the text version of < and > tags
strXML = Regex.Replace(s trXML, "<", "<");
strXML = Regex.Replace(s trXML, ">", ">");
//get ride of the XML headers
string search =
@"</XML_F52E2B61-18A1-11d1-B105-00805F49916B>\s *</Table>\s*<Table >\s*<XML_F52E2B 61-18A1-11d1-B105-00805F49916B>";
strXML = Regex.Replace(s trXML,search,"" );
//Get rid of apostrophes which do not show up properly on the
webpage
strXML = Regex.Replace(s trXML,"&apo s;","'");
//find the part of the xml that starts and ends with TREENODES
int firstoccurance = strXML.IndexOf( "TREENODES" );
int secondoccurance =
strXML.IndexOf( "TREENODES",fir stoccurance+1);
int delta = secondoccurance - firstoccurance;
strXML = strXML.Substrin g(firstoccuranc e,delta);
strXML = "<" + strXML + "TREENODES> ";
ds.Dispose();
// generate uniqe filename for each user
lock(System.Web .HttpContext.Cu rrent.Cache)
{
System.Web.Http Context.Current .Cache.Insert(" Projects",strXM L,null,
DateTime.Now.Ad dHours(HoursLef t),Cache.NoSlid ingExpiration);
}
}
else
{
strXML =(string)System .Web.HttpContex t.Current.Cache["Projects"];
}
string NewGuid = System.Guid.New Guid().ToString ();
OutFileName=New Guid+"_Projects .xml";
using(StreamWri ter wr = new
StreamWriter(Sy stem.Web.HttpCo ntext.Current.S erver.MapPath(x mlDocPath+OutFi leName)))
{
wr.Write(strXML );
}
strWriter.Close ();
//return OutFileName;
}
catch(Exception ex)
{
System.Web.Http Context.Current .Response.Write (ex.Message);
}
return OutFileName;
}
