- public XmlDocument CustomertList()
- {
-
- conn = ConfigurationManager.AppSettings["ConnectionString"];
-
- SqlXmlCommand cmd = new SqlXmlCommand(conn);
- cmd.CommandType = SqlXmlCommandType.Sql;
-
- cmd.CommandText = "select name_english,ID from customers FOR XML AUTO,ELEMENTS XSINIL,ROOT('patients')";
- XmlReader xr = cmd.ExecuteXmlReader();
-
-
- XmlDocument myXmlDocument = new XmlDocument();
- myXmlDocument.Load(xr);
-
- return myXmlDocument;
- }
|