how to return xml while using webservice?

i have created a webservice using c# asp.net as below

string ok = "1Success";
[WebMethod]
public string GetcontsXML(string agent_no,string username,string password)
{
OracleConnection conn = new OracleConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
string query = "select cont,cont_code from cont where cont>0 order by cont";
conn.Open();
OracleCommand cmd = new OracleCommand(query, conn);
OracleDataAdapter oda = new OracleDataAdapter(query,conn);
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
response = response + "" + dr["cont"].ToString() + "" + dr["cont_code"].ToString() + "";
}
return ok+response;
}

and it retrive everything ok

<string xmlns="http://tempuri.org/">
<Result>
<ResultCode>1ResultCode>
<ResultDesc>SuccessResultDesc>
Result>
<Code>1Code><Name>JORName>
<Code>2Code><Name>EGYName>
string>

but when i tried to consume this webservice

it returns the following response

<Result><ResultCode>1</ResultCode><ResultDesc>Success</ResultDesc></Result><Code>1</Code><Name>JOR</Name><Code>2</Code><Name>EGY</Name><Code>3</Code><Name>IRQ</Name><Code>4</Code><Name>AUS</Name><Code>5</Code><Name>ABW</Name><Code>6</Code><Name>AFG</Name><Code>7</Code><Name>AGO</Name><Code>8</Code><Name>AIA</Name><Code>9</Code><Name>ALB</Name><Code>10</Code><Name>AND</Name><Code>11</Code><Name>ANT</Name><Code>12</Code><

;Name>ARE</Name><Code>13</Code><Name>ARG</Name><Code>14</Code><Name>ARM</Name><Code>15</Code><Name>ASM</Name><Code>16</Code><Name>ATA</Name><Code>17</Code><Name>ATF</Name><Code>18</Code><Name>ATG</Name><Code>19</Code><Name>AUT</Name><Code>20</Code><Name>AZE</Name><Code>21</Code><Name>BDI</Name><Code>22</Code><Name>BEL</Name><Code>23</Code><Name>BEN</Name><Code>24</Code><Name>BFA</Name><Code>25</Code><Name>BGD</Name><Code>26</Code><Name>BGR</Name><Code>27</Code><Name>BHR</Name><Code>28</Code><Name>BHS</Name><Code>29</Code><Name>BIH</Name><Code>30</Code><Name>BLR</Name><Code

i know it returns "@gt" instead of ">" and "<" instead of "<"

but i want my my response as xml not string

any help ? thanks in advanced

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kiran Mohanty5y ago
are you using jQuery ajax? if so, have you defined "dataType"?

For XML response, you should set it as
$.ajax({
    url: "url",
    dataType: "xml",
    success: function(data) {
        console.log(data);// xml data
    }
});
0
Omar Kh5y ago
I have no error even on online xmlparser it works greate but i want the xml tag to be visible
0
Salman Beg5y ago
Hey. Are you getting any error? Probably check this link to rectify if any error if you have, https://www.c-sharpcorner.com/UploadFile/ansh06031982/creating-web-services-in-net-which-returns-xml-and-json-dat/
0