retrieve and store data from .net webservice as json string to android sqlite db

/* Employee Master */

SoapObject requeste = new SoapObject(NAMESPACE, METHOD_NAMEe);

requeste.addProperty("sname",ipa);
requeste.addProperty("sport", pa);
requeste.addProperty("uid", dbu);
requeste.addProperty("upwd", dbp);
requeste.addProperty("db", dbn);

SoapSerializationEnvelope envelopee = new SoapSerializationEnvelope(SoapEnvelope.VER11);

envelopee.setOutputSoapObject(requeste);
envelopee.dotNet = true;

HttpTransportSE ahte= new HttpTransportSE(URL);
try
{
ahte.call(SOAP_ACTIONe, envelopee);
SoapPrimitive resultString = (SoapPrimitive)envelopee.getResponse();
String resulte = resultString.toString();
//Toast.makeText(Testjson.this,resulte, Toast.LENGTH_LONG).show();
try {
JSONArray jArray = new JSONArray(resulte);
int cl=jArray.length();
// Toast.makeText(Testjson.this,String.valueOf(cl)+"employee", Toast.LENGTH_LONG).show();

for(int i=0;i

send data to .Net webservice using android client

public void getColumnData(Cursor cur)
{


if (cur.moveToFirst()) {

String name;
String price;
String quantity;
String totpri;
String custid;
String ordid;
String remark1;
String remark2;
String remark3;
String remark4;
String remark;
String space1 = ",";
String space2 = ",";
String space3 = ",";
int nameColumn = cur.getColumnIndex(Databasehelper.itemName);
int p = cur.getColumnIndex(Databasehelper.itemPrice);
int q = cur.getColumnIndex(Databasehelper.itemQuan);
int tot = cur.getColumnIndex(Databasehelper.totpri1);
int cid = cur.getColumnIndex(Databasehelper.cid);
int oid = cur.getColumnIndex(Databasehelper.orderID);
int w1 = cur.getColumnIndex(Databasehelper.bytwo);
int w2 = cur.getColumnIndex(Databasehelper.withoil);
int w3 = cur.getColumnIndex(Databasehelper.withoutoil);
int w4 = cur.getColumnIndex(Databasehelper.withpepper);


do {
// Get the field values
name = cur.getString(nameColumn);
price = cur.getString(p);
quantity = cur.getString(q);
totpri = cur.getString(tot);
custid = cur.getString(cid);
ordid = cur.getString(oid);
remark1 = cur.getString(w1);

remark2 = cur.getString(w2);
remark3 = cur.getString(w3);
remark4 = cur.getString(w4);
remark = remark1+space1+remark2+space2+remark3+space3+remark4;


SoapObject request = new SoapObject(NAMESPACE, METHOD_NAME);

request.addProperty("sname", sysname);
request.addProperty("sport", sysport);
request.addProperty("uid", userid);
request.addProperty("upwd", pass);
request.addProperty("db", dbname);
request.addProperty("name", name);
request.addProperty("price", price);
request.addProperty("quantity",quantity);
request.addProperty("totpri", totpri);
request.addProperty("custid", custid);
request.addProperty("orderid", ordid);
request.addProperty("remark", remark);

SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER11);

envelope.setOutputSoapObject(request);
envelope.dotNet = true;

HttpTransportSE aht= new HttpTransportSE(URL);
try
{
aht.call(SOAP_ACTION, envelope);
SoapPrimitive resultString = (SoapPrimitive)envelope.getResponse();

//Toast.makeText(Databasehelper.this,resultString, Toast.LENGTH_LONG).show();
// tvText.setText(resultString.toString());
}
catch (Exception E) {
Throwable error = E.getCause();
//tvText.setText(error.toString());
}

} while (cur.moveToNext());

}
}

make directory in sdcard

manifes.xml

set uses-permission :android.permission.WRITE_EXTERNAL_STORAGE


package com.mkdir;

import java.io.File;
import android.app.Activity;
import android.os.Bundle;
import android.os.Environment;
import android.os.StatFs;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.TextView;


public class mkdir extends Activity {
Button b;

TextView t;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);

t = (TextView)findViewById(R.id.tv);
b= (Button) findViewById(R.id.Button01);
File dir = new File("/sdcard/new_dir");
try{
if(dir.mkdir()) {
System.out.println("Directory created");
t.setText("Directory created");
} else {
System.out.println("Directory is not created");
t.setText("Directory is not created");
}
}catch(Exception e){
e.printStackTrace();
}

b.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
File del = new File("/sdcard/new_dir");
boolean success = del.delete();
if (!success) {
System.out.println("Deletion of directory failed!");
}
}
});
}
}