when i used this code when i running second time from xml file it shows that testdbo.xml used by another user
-
//StreamWriter xmlDoc = new StreamWriter(Server.MapPath("~/Testdo.xml"), false);
-
-
DataSet dsbase = new DataSet();
-
StreamWriter xmlDoc = new StreamWriter(Server.MapPath("~/Testdo.xml"), false);
-
//dsbase.ReadXml(MapPath("Testdo.xml"));
-
// dsbase.ReadXml(MapPath("~/Testdo.xml" ));
-
if (xmlDoc.ToString () == "")
-
{
-
-
string database = "select * from tbldatabase";
-
// DataSet dsbase = new DataSet();
-
SqlDataAdapter dabase = new SqlDataAdapter(database, con);
-
dabase.Fill(dsbase);
-
-
////GridView1.DataSource = document;
-
////GridView1.DataBind();
-
if (dsbase.Tables[0].Rows.Count > 0)
-
{
-
GridView1.DataSource = dsbase;
-
GridView1.DataBind();
-
}
-
-
// Get a FileStream object
-
-
-
// Apply the WriteXml method to write an XML document
-
dsbase.WriteXml(xmlDoc);
-
xmlDoc.Close();
-
}
-
else
-
{
-
StreamReader strreader = new StreamReader(Server.MapPath("~/Testdo.xml"));
-
dsbase.ReadXml(strreader);
-
-
GridView1.DataSource = dsbase;
-
GridView1.DataBind();
-
-
}
-
-
-
-
}
-
-
}
