Hello,
First, Please excuse me for my bad english.
I developped a small webservice in C# who execute a sored procedure in a
sql server 2005.
Everything was OK, but our client have a problem to integrate it on java
plateform, because the XML was formatting in microsoft standard format.
Could you help me please, or send me a link about , how to format XML
response, or how to include the response in a array var considering my C#
code.
I join my code here:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
[WebService(Namespace = "toto_CHECK")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Webservicetoto : System.Web.Services.WebService {
public Webservicetoto () {
}
[WebMethod]
public DataSet Get_status_for_pitchs_and_location(int id_camp)
{
SqlConnection myConnection = new
SqlConnection("server=localhost;uid=***;pwd=******;database=****;");
SqlDataAdapter myCommand1 = new SqlDataAdapter("EXECUTE
CHECK_HEB_FOR_toto " + id_camp, myConnection);
DataSet ds = new DataSet();
myCommand1.Fill(ds);
return ds;
}
}
Draggi - 29 Dec 2005 12:20 GMT
For someone who have the same problem this is the solution :
> using System;
> using System.Data;
> using System.Data.SqlClient;
> using System.Web.Services;
using System.Xml;
> [WebService(Namespace = "toto_CHECK")]
> [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[quoted text clipped - 15 lines]
> DataSet ds = new DataSet();
> myCommand1.Fill(ds);
XmlDataDocument dataDoc = new XmlDataDocument(ds);
return dataDoc;
> }
> }