how to read data from database first time or read data from xml filw in 2nd time

[mrutyunjaya]

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();

        }



    }

}

[Frinavale]

Call the Dispose() method when you are finished with the XML file to release the resource.