Databases
StackOverflow2013
Postsdbo
POGet array item from webservice object to android
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGet array item from webservice object to android
    primarykey
    data
    text
    <p>Im trying to get details like. District, name, Id ect... from MsSql DB through .Net web Service from a array object.</p> <p>My web Service</p> <p>[WebMethod]</p> <pre><code>public DisAndPanDetails[] GetDistrictNameDetails() { DisAndPanDetails[] objDetails = new DisAndPanDetails[1]; SQLHelper objHelper = new SQLHelper(); DataTable dtblDetails = new DataTable(); string sQuery = string.Empty; try { sQuery = "SELECT DISTINCT District FROM OnlineTaxMerchantIdDetails ORDER BY District"; objHelper.CreateConnection("Connect"); dtblDetails = objHelper.FillDataTableByQueryString(sQuery); if (dtblDetails.Rows.Count &gt; 0) { DisAndPanDetails[] objDetail = new DisAndPanDetails[dtblDetails.Rows.Count]; for (int iRowIdx = 0; iRowIdx &lt; dtblDetails.Rows.Count; iRowIdx++) { objDetail[iRowIdx] = new DisAndPanDetails(); objDetail[iRowIdx].District = dtblDetails.Rows[iRowIdx]["District"].ToString(); } } } catch (Exception ex) { objDetails[0] = new DisAndPanDetails(); objDetails[0].Error = ex.Message.ToString(); } finally { objHelper = null; dtblDetails = null; } return objDetails; } </code></pre> <p>My KvmSerializable class</p> <pre><code> public class DisAndPanDetails implements KvmSerializable { public String District; public DisAndPanDetails() { } public DisAndPanDetails(String District) { this.District= District; } public Object getProperty(int arg0) { // TODO Auto-generated method stub switch(arg0) { case 0: return District; } // return null; return null; } public int getPropertyCount() { // TODO Auto-generated method stub return 1; } public void getPropertyInfo(int index, Hashtable arg1, PropertyInfo info) { // TODO Auto-generated method stub switch(index) { case 0: info.type = PropertyInfo.STRING_CLASS; info.name = "District"; break; default: break; } } public void setProperty(int index, Object value) { // TODO Auto-generated method stub switch(index) { case 0: District = value.toString(); break; default: break; } } </code></pre> <p>My Activity Class</p> <pre><code> DisAndPanDetails C = new DisAndPanDetails(); PropertyInfo pi = new PropertyInfo(); pi.setName("C"); pi.setValue(C); pi.setType(C.getClass()); Request.addProperty(pi); SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER11); envelope.dotNet = true; envelope.setOutputSoapObject(Request); envelope.addMapping(NAMESPACE, "DisAndPanDetails",new DisAndPanDetails().getClass()); HttpTransportSE androidHttpTransport = new HttpTransportSE(URL); try { androidHttpTransport.call(SOAP_ACTION, envelope); SoapObject response = (SoapObject)envelope.getResponse(); C.District = response.getProperty(0).toString(); System.out.println("Result yash= Dist: "+C.District1+" count:"+intPropertyCount); } KvmSerializable ks = (KvmSerializable)envelope.bodyIn; for(int i=0;i&lt;ks.getPropertyCount();i++) { String obj[] = soap.getProperty(0).toString(); String values[] = (String[])Request.getAttribute("District1"); } System.out.println("rrrr"+response); TextView tv = (TextView)findViewById(R.id.text123); tv.setText(C.District); System.out.println("kkkk"+C.District); } catch(Exception e) { e.printStackTrace(); System.out.println("error:"+e); } } </code></pre> <p>I need to get all district ,name, id into spinner. <strong>I can bind it to spinner but how can I get those detail of array obj as string from web service</strong>. Pls do help.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USYashwanth
    1. USYashwanth
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGet array item from webservice object to android
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhy don't you have web service give you output in Tags, which means you don't write queries in your parsing code. You only get those tags in Array using Bean class(Get and Set methods). Then fill that array in Spinner using adapter(BaseAdapter preferred).
      singulars
      1. POGet array item from webservice object to android
      1. USDhaval
    2. COIt's an existing web service. No privilege for me to modify the web service. I can only get the service. I need to see How can I make use of it. And data is stored in Mssql DB.
      singulars
      1. POGet array item from webservice object to android
      1. USYashwanth
    3. COIs your service invokable? Does it give XML output? Because Service can call related query from its .NET code and give you result in tags. This is a swift way of doing it. For better performance you shouldn't sort or process web service output. Make sure you get only what you need. Make different services if there are different queries. I have experience with this approach and believe me, it's way better.
      singulars
      1. POGet array item from webservice object to android
      1. USDhaval
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload