INSERT RECORD IN SQLSERVER 2008 By ANDROID APP Through WCF Service

See more:

SQL-Server

Mobile

WCF

Android

hi i am kuldeep singh i am new on android. iahve a problem with android app. i wanna insert record in sqlserver 2008 throgh WCF Service. my service works fine fro Dotnet But it not working on android app. my code for Maniactivity.java in android

import java.io.IOException;
import java.io.UnsupportedEncodingException;

import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.DefaultHttpClient;
import org.json.JSONException;
import org.json.JSONStringer;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends Activity {
	private final static String SERVICE_URI = "http://125.16.63.234/WCFANDROID/Service.svc?wsdl";
	
	   
	    @Override
	   protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		//final Button button = (Button) findViewById(R.id.buttonsubmit);
	   // button.setOnClickListener(new View.OnClickListener() {
            //public void onClick(View v) 
           // {
            	//onSaveVehicleClick(view)
           // }
        //});
	}

	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		// Inflate the menu; this adds items to the action bar if it is present.
		getMenuInflater().inflate(R.menu.activity_main, menu);
		return true;
	}
	
	public void onSaveVehicleClick(View view)
	{ 
	    	EditText tvname = (EditText) findViewById(R.id.editTextVname);
	        String sUsername =tvname.getText().toString() ;
	        EditText tlocation = (EditText) findViewById(R.id.editTextloc);
	        String tvlocation = tlocation.getText().toString();
	        EditText tAddress = (EditText) findViewById(R.id.editTextadd);
	        String stAddress = tAddress.getText().toString();
	        EditText tvmobileno = (EditText) findViewById(R.id.editTextmobileno);
	        String stvmobileno = tvmobileno.getText().toString();
	        if (tvname.getText().toString().equals("")) 
	        {
	            Toast.makeText(getApplicationContext(), "You did not enter a Vender Name", Toast.LENGTH_SHORT).show();
	            return;
	        }
	        if (tlocation.getText().toString().equals("")) {
	            Toast.makeText(this, "You did not enter a Location", Toast.LENGTH_SHORT).show();
	            return;
	        }
	        if (tAddress.getText().toString().equals("")) {
	            Toast.makeText(this, "You did not enter a Address", Toast.LENGTH_SHORT).show();
	           	return;
	        }
	        if (tvmobileno.getText().toString().equals("")) {
	            Toast.makeText(this, "You did not enter a Mobile no", Toast.LENGTH_SHORT).show();
	            return;
	        }
	        if (tvmobileno.getText().toString().length()!=10) {
	            Toast.makeText(this, "Please Enter Correct Mobile No", Toast.LENGTH_SHORT).show();
	            return;
	        }
	        // POST request to <service>/SaveVehicle
            HttpPost request = new HttpPost(SERVICE_URI + "/SaveVender");
            request.setHeader("Accept", "application/json");
            request.setHeader("Content-type", "application/json");
 
            // Build JSON string
           try
           {
       
            JSONStringer venderjson = new JSONStringer()
                .object()
                    .key("vname")
                        .object()
                            .key("VName").value(sUsername)
                            .key("Vlocation").value(tvlocation)
                            .key("Address").value(stAddress)
                            .key("MobileNo").value(Integer.parseInt(stvmobileno.toString()))
                        .endObject()
                    .endObject();
            StringEntity entity = new StringEntity(venderjson.toString());
 
            request.setEntity(entity);
 
            // Send request to WCF service
            DefaultHttpClient httpClient = new DefaultHttpClient();
            HttpResponse response = httpClient.execute(request);
            Log.v("response code", response.getStatusLine()
                    .getStatusCode() + ""); 
            Toast.makeText(this, "save record Succesfully", Toast.LENGTH_SHORT).show();
            Toast.makeText(this, "save record Succesfully", Toast.LENGTH_SHORT).show();
            Log.d("WebInvoke", "Saving : " + response.getStatusLine().getStatusCode());
             
           }
         catch (Exception e) 
   	    {
   	    	e.printStackTrace();
   	    	
   	    }  // Reload plate numbers

Plesae help

[Edit]Code block added[/Edit]