Sql database to xml document

private void WriteXmlMethod()
        {
            string constring = ConfigurationManager.ConnectionStrings["NorthwindConnectionString1"].ToString();
            SqlConnection con = new SqlConnection(constring);
            con.Open();
            string query = "select * from tbl_newsBee";
            SqlCommand cmd = new SqlCommand(query, con);
            SqlDataReader dr = cmd.ExecuteReader();
            XDocument doc = new XDocument();
            XDeclaration declaration = new XDeclaration("1.0","utf-8","yes");
            doc.Add(declaration);
            XElement element1 = new XElement("Newses");
            XElement element2 = null;
            while (dr.Read())
            {
                element2 = new XElement("News",new XAttribute("link", dr[2].ToString()),new XAttribute("des",dr[1].ToString()));
                element2.Add(dr[3].ToString());
                element1.Add(element2);
            }
            con.Close();
            string filename = Server.MapPath("YourFolder/myXmlDoc.xml");
            doc.Save(filename);
        }

private void WriteXmlMethod()
        {
           
            string constring = ConfigurationManager.ConnectionStrings["ConnectionStringNews"].ToString();
            SqlConnection con = new SqlConnection(constring);
            con.Open();
            string query = "select * from tbl_newsBee";
            SqlCommand cmd = new SqlCommand(query, con);
            SqlDataReader dr = cmd.ExecuteReader();
            XmlDocument myXml = new XmlDocument();
            XmlElement el;
            XmlElement root = myXml.CreateElement("newses");
            myXml.AppendChild(root);
            while (dr.Read())
            {
                el = myXml.CreateElement("news");
                el.SetAttribute("link", dr[2].ToString());
                el.SetAttribute("des", dr[1].ToString());
                el.InnerText = dr[3].ToString();
                root.AppendChild(el);
            }
            con.Close();
            myXml.Save(favXml);
        }

private void WriteXmlMethod()
        {
            string constring = ConfigurationManager.ConnectionStrings["YourConnectionString"].ToString();
            SqlConnection con = new SqlConnection(constring);
            con.Open();
            string query = "SELECT newsbee_ID, newsBee, title FROM  tbl_newsBee";
            SqlCommand cmd=new SqlCommand(query,con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            string filename =Server.MapPath("YourFolder/myXmlDoc.xml");
           
            System.IO.FileStream myFileStream = new System.IO.FileStream
            (filename, System.IO.FileMode.Create);
            System.Xml.XmlTextWriter myXmlWriter =new System.Xml.XmlTextWriter(myFileStream, System.Text.Encoding.Unicode);
            ds.WriteXml(myXmlWriter);
            myXmlWriter.Close();
        }

public string favXml = "E:/My Webs/NIBS Website/www.microsquirrel.com/www.microsquirrel.com/News/news.xml";

private void WriteXmlMethod()
    {
        string constring = ConfigurationManager.ConnectionStrings["ConnectionStringNews"].ToString();
        SqlConnection con = new SqlConnection(constring);
        con.Open();
        string query = "select * from tbl_newsBee";
        SqlCommand cmd = new SqlCommand(query, con);
        SqlDataReader dr = cmd.ExecuteReader();
        
        XmlDocument myXml = new XmlDocument();
        XmlElement el = myXml.CreateElement("news");
while(dr.read())
{
        el.SetAttribute("link", dr[2].ToString());
        el.SetAttribute("des", dr[1].ToString());
        el.InnerText = dr[3].ToString();
        if (!File.Exists(favXml))
        {
            XmlElement root = myXml.CreateElement("newses");
            myXml.AppendChild(root);
            root.AppendChild(el);
            LabelMessageDel.Text = "Item Created";
        }
        else
        {
            myXml.RemoveAll();
            XmlElement root = myXml.CreateElement("newses");
            myXml.AppendChild(root);
            root.AppendChild(el);
            LabelMessageDel.Text = "Item Created";
        }
}
        con.Close();
        myXml.Save(favXml); 
}

private void WriteXmlMethod()
{
string constring = ConfigurationManager.ConnectionStrings["ConnectionStringNews"].ToString();
SqlConnection con = new SqlConnection(constring);
con.Open();
string query = "select * from tbl_newsBee";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader dr = cmd.ExecuteReader();
XmlDocument myXml = new XmlDocument();
XmlElement el;
XmlElement root = myXml.CreateElement("newses");
myXml.AppendChild(root);
while (dr.Read())
{
el = myXml.CreateElement("news");
el.SetAttribute("link", dr[2].ToString());
el.SetAttribute("des", dr[1].ToString());
el.InnerText = dr[3].ToString();
root.AppendChild(el);
}
con.Close();
myXml.Save(favXml);
}