Ali Mahmoud

Ali Mahmoud

  • NA
  • 55
  • 0

web service issue

Feb 7 2011 1:40 PM

Hi all , 

I use the following web method to give xml file

 
  1.     public XmlDocument CustomertList()  
  2.         {  
  3.   
  4.             conn = ConfigurationManager.AppSettings["ConnectionString"];  
  5.   
  6.             SqlXmlCommand cmd = new SqlXmlCommand(conn);  
  7.             cmd.CommandType = SqlXmlCommandType.Sql;  
  8.            // cmd.RootTag = "WorkList";  
  9.             cmd.CommandText = "select name_english,ID from customers FOR XML AUTO,ELEMENTS XSINIL,ROOT('patients')";  
  10.             XmlReader xr = cmd.ExecuteXmlReader();  
  11.   
  12.               
  13.             XmlDocument myXmlDocument = new XmlDocument();  
  14.             myXmlDocument.Load(xr);  
  15.             // load xml content or build it up dynamically, etc  
  16.             return myXmlDocument;  
  17.         }

I want to get the XmlDocument by type the url (for example ) http://localhost:8088/IOSService.asmx?op=CustomertList

I need to have rss xml file , I mean I want to give the user url that give him / her the resulted xml


any suggestion please


Answers (2)