webreference.Lists myList = new webreference.Lists();



            myList.Credentials = new NetworkCredential(Username, Password, Domain);

           // myList.Url = "http://193.82.85.1/HelpDesk/_vti_bin/lists.asmx";



            XmlDocument xmlDoc = new XmlDocument();



            XmlNode ndQuery = xmlDoc.CreateElement("Query");

    

    XmlNode ndViewFields = xmlDoc.CreateElement("ViewFields");

    XmlNode ndQueryOptions = xmlDoc.CreateElement("QueryOptions");



    ndQueryOptions.InnerXml = "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>" + "<DateInUtc>FALSE</DateInUtc>" + "<IncludeAttachmentUrls>TRUE</IncludeAttachmentUrls>/>";





    ndViewFields.InnerXml = "<FieldRef Name='Title' /> <FieldRef Name='SRDetail'/> <FieldRef Name='Priority'/> <FieldRef Name='Raised_x0020_By'/> <FieldRef Name='Date_x0020_Raised'/> <FieldRef Name='Category'/> <FieldRef Name='Centre'/> <FieldRef Name='ResolutionType' />";

    ndQuery.InnerXml = "<OrderBy><FieldRef Name='Date_x0020_Raised'/></OrderBy>";



    //"<Query><Where><Eq><FieldRef Name='Raised_x0020_By' /><Value Type='Text'>ddlRaisedBy.Value</Value></Eq></Where></Query>" 



    XmlNode nodeListItems = myList.GetListItems("{002DD75F-2F5A-407C-95A7-2C8CC7156C58}", "{3D3A5BB0-4994-4D64-891C-24D6ECB31991}", ndQuery, ndViewFields, "5", ndQueryOptions, null);

    XmlReader reader = new XmlNodeReader(nodeListItems);

  



    DataSet ds = new DataSet();

    ds.ReadXml(reader);



   

   // GridView1.DataMember = "yourmembers";

    GridView1.DataSource = ds.Tables[1];

    GridView1.DataBind();

/*

 * To change this template, choose Tools | Templates

 * and open the template in the editor.

 */



package Programs;



import java.util.ArrayList;

import javax.ws.rs.core.Context;

import javax.ws.rs.core.UriInfo;

import javax.ws.rs.Consumes;

import javax.ws.rs.PUT;

import javax.ws.rs.Path;

import javax.ws.rs.GET;

import javax.ws.rs.Produces;

import java.util.List;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.logging.Level;

import java.util.logging.Logger;







/**

 * REST Web Service

 *

 * @author Dhanya_Kurup

 */



@Path("ProgramList")

public class ProgramListResource {



    @Context

    private UriInfo context;

     private Logger logger = Logger.getLogger(this.getClass().getName());





    /** Creates a new instance of ProgramListResource */

    public ProgramListResource() {

    }



    /**

     * Retrieves representation of an instance of Programs.ProgramListResource

     * @return an instance of java.lang.String

     */

    @GET

    @Produces("application/xml")

    public ProgramDetailsList getXml() {

        

        

        //TODO return proper representation object

        //throw new UnsupportedOperationException();        

        //String Strqry;

        Connection connection = null ;

        String connectionURL = "jdbc:mysql://localhost:3306/test";

        ProgramDetailsList Details = new ProgramDetailsList();



        try

        {



         ResultSet programResults = null;

         Class.forName("com.mysql.jdbc.Driver").newInstance();

         connection = (Connection) DriverManager.getConnection(connectionURL, "root", "bharani");

          

            logger.log(Level.INFO, "conncetion: " + connection);

            

            Statement stmt = connection.createStatement();

            stmt.setQueryTimeout(120);

            

            programResults = stmt.executeQuery("select * from programlist");

            

            //programResults=Strqry;

           

 System.out.println("hii");









        

            List<String> programName=new ArrayList<String>();

            //programName=null;

            List<String> duration=new ArrayList<String>();

            List<String> days=new ArrayList<String>();

            List<String> programType=new ArrayList<String>();

           List<String> description=new ArrayList<String>();



            while(programResults.next())

            {

                programName.add(programResults.getString("ProgramName"));

               duration.add(programResults.getString("Duration"));

             days.add(programResults.getString("Days"));

              programType.add(programResults.getString("ProgramType"));

             description.add(programResults.getString("Description"));

            }





            int length=programName.size();

            List<ProgramDetails> program_list=new ArrayList<ProgramDetails>();



            for(int k=0;k<length;k++)

            {

               ProgramDetails program = new ProgramDetails();

               program.ProgramName=programName.get(k);

               program.Duration=duration.get(k);

               program.Days=days.get(k);

               program.ProgramType=programType.get(k);

               program.Description=description.get(k);

               

                program_list.add(program);

            }



            Details.programDetailsList=program_list;

            stmt.close();

            programResults.close();





        }



        catch (Exception ex)

        {

            Logger.getLogger(ProgramListResource.class.getName()).log(Level.SEVERE, null, ex);

        }

    finally

        {

            try

            {

                connection.close();

            }

            catch (SQLException ex)

            {

          

                Logger.getLogger(ProgramListResource.class.getName()).log(Level.SEVERE, null, ex);

            }

        }



        return Details;

    }



    /**

     * PUT method for updating or creating an instance of ProgramListResource

     * @param content representation for the resource

     * @return an HTTP response with content of the updated or created resource.

     */

    @PUT

    @Consumes("application/xml")

    public void putXml(String content) {

    }

}

<?xml version ='1.0' encoding ='UTF-8' ?> 

<definitions name='Save' 

  targetNamespace='http://my-site.com/save.wsdl' 

  xmlns:tns='http://my-site.com/save.wsdl' 

  xmlns:soap='http://schemas.xmlsoap.org/wsdl/soap/' 

  xmlns:xsd='http://www.w3.org/2001/XMLSchema' 

  xmlns:soapenc='http://schemas.xmlsoap.org/soap/encoding/' 

  xmlns:wsdl='http://schemas.xmlsoap.org/wsdl/' 

  xmlns='http://schemas.xmlsoap.org/wsdl/'> 



<message name='SaveRequest'> 

  <part name='rangeName' type='xsd:string'/>  

  <part name='value' type='xsd:string'/> 

</message> 



<portType name='SavePortType'> 

  <operation name='saveEntry'> 

    <input message='tns:SaveRequest'/>  

  </operation> 

</portType> 



<binding name='SaveBinding' type='tns:SavePortType'> 

  <soap:binding style='rpc' transport='http://schemas.xmlsoap.org/soap/http'/> 

  <operation name='saveEntry'> 

    <soap:operation soapAction='saveEntry'/> 

    <input> 

      <soap:body use='encoded' namespace='urn:examples:Save' encodingStyle='http://schemas.xmlsoap.org/soap/encoding/'/> 

    </input>

  </operation> 

</binding> 



<service name='SaveService'>

  <port name='SavePort' binding='SaveBinding'> 

    <soap:address location='http://my-site.com/newpatientvalue/soap-server.php'/> 

  </port> 

</service>

</definitions>

public class WebLibSvcs {

                public List<DocumentInfo> getAllDocuments(BigDecimal workflow_id) {

                                boolean statusWL = WLGlobalVar.getInstance().isDctmWLRun();

                                logger.info("Status of WebLibrary: " + statusWL);

                                WebLibSvcAction callSVC = new WebLibSvcAction();

                                List<DocumentInfo> results = new ArrayList<DocumentInfo>();

                                results = callSVC.getAllDocumentsImpl(workflow_id);

                                return results;

                }

}

public class WebLibSvcAction {

                public List<DocumentInfo> getAllDocumentsImpl(BigDecimal workflow_id) {

                                List<DocumentInfo> result = new ArrayList<DocumentInfo>();

                                   try{

DocumentInfo docInfo = new DocumentInfo();

                                  for (int i = 0; i < 5; i++) {

                                       docInfo.setObject_name(“test”);

                                        result.add(docInfo);

                          }

                                }catch (ServiceException e){

                                    e.printStackTrace();

                                }

                                                return result;

                }

}

public class DocumentInfo implements Serializable{



                public String version_label;

                public String title;

                public String object_name;

                public String subject;

                public String linkUrl;

                

                public String getVersion_label() {

                                return version_label;

                }

                public void setVersion_label(String r_version_label) {

                                this.version_label = r_version_label;

                }

                public String getTitle() {

                                return title;

                }

                public void setTitle(String title) {

                                this.title = title;

                }

                public String getObject_name() {

                                return object_name;

                }

                public void setObject_name(String object_name) {

                                this.object_name = object_name;

                }

                public String getSubject() {

                                return subject;

                }

                public void setSubject(String subject) {

                                this.subject = subject;

                }

                public String getLinkUrl() {

                                return linkUrl;

                }

                public void setLinkUrl(String linkUrl) {

                                this.linkUrl = linkUrl;

                }

                

}

 Dim RequestNewCont(0) As RemoteSite.NewContributor

        Dim AnswerValue As RemoteSite.ResponseNewSON

        Dim CallService As New RemoteSite.wsReceptionResquestDeal()

 'I use below to send the parameters

' In debug mode it crashes at the next line

        RequestNewCont(0).ID = "222"

        RequestNewCont(0).MEMBERFIRSTNAME = "Adewale"

        RequestNewCont(0).MEMBERTITLE = "Mr"

        RequestNewCont(0).PRESENTADDRESS = "4, Samson Street"

                       

       CallService.wmReceptionResquestNEW(RequestNewCont, "MyUs", "MyFun")

' I use below variables to get the response       

           Dim IDDE As String = AnswerValue.IDD

        Dim NameE As String = AnswerValue.Name

        Dim ClassE As String = AnswerValue.Class

 <wsdl:definitions xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://localhost/wsDealsystem/wsDeal/wsReceptionResquestDeal" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" targetNamespace="http://localhost/wsDealsystem/wsDeal/wsReceptionResquestDeal" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">

- <wsdl:types>

- <s:schema elementFormDefault="qualified" targetNamespace="http://localhost/wsDealsystem/wsDeal/wsReceptionResquestDeal">

- <s:element name="wmReceptionResquestNEW">

- <s:complexType>

- <s:sequence>

  <s:element minOccurs="0" maxOccurs="1" name="data" type="tns:ArrayOfNewContributor" /> 

  <s:element minOccurs="0" maxOccurs="1" name="usu" type="s:string" /> 

  <s:element minOccurs="0" maxOccurs="1" name="fun" type="s:string" /> 

  </s:sequence>

  </s:complexType>

  </s:element>

- <s:complexType name="ArrayOfNewContributor">

- <s:sequence>

  <s:element minOccurs="0" maxOccurs="unbounded" name="NewContributor" nillable="true" type="tns:NewContributor" /> 

  </s:sequence>

  </s:complexType>

- <s:complexType name="NewContributor">

- <s:sequence>

  <s:element minOccurs="0" maxOccurs="1" name="ID" type="s:string" /> 

  <s:element minOccurs="0" maxOccurs="1" name="MEMBERFIRSTNAME" type="s:string" /> 

  <s:element minOccurs="0" maxOccurs="1" name="PRESENTADDRESS" type="s:string" /> 

  <s:element minOccurs="0" maxOccurs="1" name="MEMBERTITLE" type="s:string" /> 

  </s:sequence>

  </s:complexType>

- <s:element name="wmReceptionResquestNEWResponse">

- <s:complexType>

- <s:sequence>

  <s:element minOccurs="0" maxOccurs="1" name="wmReceptionResquestNEWResult" type="tns:ArrayOfResponseNewSON" /> 

  </s:sequence>

  </s:complexType>

  </s:element>

- <s:complexType name="ArrayOfResponseNewSON">

- <s:sequence>

  <s:element minOccurs="0" maxOccurs="unbounded" name="ResponseNewSON" nillable="true" type="tns:ResponseNewSON" /> 

  </s:sequence>

  </s:complexType>

- <s:complexType name="ResponseNewSON">

- <s:sequence>

  <s:element minOccurs="0" maxOccurs="1" name="IDD" type="s:string" /> 

  <s:element minOccurs="0" maxOccurs="1" name="Name" type="s:string" /> 

  <s:element minOccurs="0" maxOccurs="1" name="Class" type="s:string" /> 

    </s:sequence>

  </s:complexType>

- </wsdl:types>

- <wsdl:message name="wmReceptionResquestNEWSoapIn">

  <wsdl:part name="parameters" element="tns:wmReceptionResquestNEW" /> 

  </wsdl:message>

- <wsdl:message name="wmReceptionResquestNEWSoapOut">

  <wsdl:part name="parameters" element="tns:wmReceptionResquestNEWResponse" /> 

  </wsdl:message>

- 

- <wsdl:portType name="wsReceptionResquestDealSoap">

- <wsdl:operation name="wmReceptionResquestNEW">

  <wsdl:input message="tns:wmReceptionResquestNEWSoapIn" /> 

  <wsdl:output message="tns:wmReceptionResquestNEWSoapOut" /> 

  </wsdl:operation>

-

  </wsdl:portType>

- <wsdl:binding name="wsReceptionResquestDealSoap" type="tns:wsReceptionResquestDealSoap">

  <soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="document" /> 

- <wsdl:operation name="wmReceptionResquestNEW">

  <soap:operation soapAction="http://localhost/wsDealsystem/wsDeal/wsReceptionResquestDeal/wmReceptionResquestNEW" style="document" /> 

- <wsdl:input>

  <soap:body use="literal" /> 

  </wsdl:input>

- <wsdl:output>

  <soap:body use="literal" /> 

  </wsdl:output>

  </wsdl:operation>

- <wsdl:operation name="wmReceptionResquestUPDATE">

  <soap:operation soapAction="http://localhost/wsDealsystem/wsDeal/wsReceptionResquestDeal/wmReceptionResquestUPDATE" style="document" /> 

- <wsdl:input>

  <soap:body use="literal" /> 

  </wsdl:input>

- <wsdl:output>

  <soap:body use="literal" /> 

  </wsdl:output>

  </wsdl:operation>

- <wsdl:operation name="wmTest">

  <soap:operation soapAction="http://localhost/wsDealsystem/wsDeal/wsReceptionResquestDeal/wmTest" style="document" /> 

- <wsdl:input>

  <soap:body use="literal" /> 

  </wsdl:input>

- <wsdl:output>

  <soap:body use="literal" /> 

  </wsdl:output>

  </wsdl:operation>

  </wsdl:binding>

- <wsdl:service name="wsReceptionResquestDeal">

- <wsdl:port name="wsReceptionResquestDealSoap" binding="tns:wsReceptionResquestDealSoap">

  <soap:address location="https://RemoteSite/wsDealsystem/wsDeal/wsReceptionResquestDeal.asmx" /> 

  </wsdl:port>

  </wsdl:service>

  </wsdl:definitions>