Hello readers this is the part two of the login App of android using the information on the remote SQl server database

Now we have our SQL server database and the WCF service that verifies the login so now its time to start the Android App

For this you have to create a normal app and create a UI with two textboxes , a label and a button.

The XML for the UI is given below

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical" >

    <TextView
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="@string/hello" />

    <EditText
        android:id="@+id/txtUserName"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="User Name"
        >

        <requestFocus />
    </EditText>

    <EditText
        android:id="@+id/txtPassword"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="Password"
        android:inputType="textPassword"
        />

    <Button
        android:id="@+id/btnLogin"
        android:layout_width="128dp"
        android:layout_height="wrap_content"
        android:text="Button" />

    <TextView
        android:id="@+id/lblStatus"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Status"
        android:textAppearance="?android:attr/textAppearanceLarge" />

</LinearLayout>

The text boxes are for user name and password

Before we go to the next step we have to add internet permission to the App that is add internet permission to the Manifest file.

Here the code for that (you can use the UI too)

<uses-permission android:name="android.permission.INTERNET" />

Now the UI is ready we can continue to the coding

package com.Android.JSONApp;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;

import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.DefaultHttpClient;

import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class JSONSampleAppActivity extends Activity implements OnClickListener{
    /** Called when the activity is first created. */

	//Property declaration
	Button btnLogin;
	TextView lblStatus;
	EditText txtUserName,txtPassword;

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

        btnLogin=(Button)findViewById(R.id.btnLogin);
        btnLogin.setOnClickListener(this);

        lblStatus=(TextView)findViewById(R.id.lblStatus);

        txtUserName=(EditText)findViewById(R.id.txtUserName);
        txtPassword=(EditText)findViewById(R.id.txtPassword);
    }

	@Override
	public void onClick(View v) {

		switch(v.getId())
		{
			case R.id.btnLogin:
				String userName=txtUserName.getText().toString();
				String password=txtPassword.getText().toString();
				if(verifyLogin(userName,password))
				{
					lblStatus.setText("Login Successful");
				}
				else
				{
					lblStatus.setText("Login Failed");
				}
				break;
		}
	}

    public static String convertStreamToString(InputStream is)
    {
    	BufferedReader reader = new BufferedReader(new InputStreamReader(is));
    	StringBuilder sb = new StringBuilder();

    	String line = null;
    	try {
    		while ((line = reader.readLine()) != null) {
    			sb.append(line + "\n");
    		}
    	}
    	catch (IOException e) {
    		e.printStackTrace();
    	}
    	finally {
    		try {
    			is.close();
    		} catch (IOException e) {
				e.printStackTrace();
    		}
    	}
    	return sb.toString();
    }

    public static boolean verifyLogin(String UserName,String Password)
    {
    	try
    	{
    		System.out.println("guru");
    		DefaultHttpClient httpClient=new DefaultHttpClient();

    		//Connect to the server
               //here the 10.0.2.2 is the local host
    		HttpGet httpGet=new HttpGet("http://10.0.2.2:51220/Service1.svc/checkLogin?name="+UserName+"&pass="+Password);
    		//Get the response
    		HttpResponse httpResponse = httpClient.execute(httpGet);
            HttpEntity httpEntity = httpResponse.getEntity();
        	InputStream stream=httpEntity.getContent();

        	//Convert the stream to readable format
            String result= convertStreamToString(stream);

            if(result.charAt(1)=='1')
            {
            	return true;
            }
            else
            {
            	return false;
            }
    	}
    	catch(Exception e)
    	{
    		return false;
    	}

    }

}

Now run the app and try it
i’ve used the login information in my DB
so i get this output

Here is the link to download the source code

http://www.mediafire.com/?ocmzcc4jl9blsrh