SqlConnection mySqlConnection;
mySqlConnection = new SqlConnection(sConnection);
mySqlConnection.Open();
            
XmlReader xmlReader = new SqlCommand("Select * From Table1 FOR XML AUTO, Elements", mySqlConnection).ExecuteXmlReader();

System.Xml.XmlDocument doc= new System.Xml.XmlDocument ();
        doc.Load(xmlReader );