Posts

Showing posts from August, 2013

Sqlite Join - Android, IOS

Sqlite join is used to combine two or more tables in a database. Here is the examples for understanding sqlite join.

sqlite> .schema
CREATE TABLE  EMPLOYEE(EmpId INTEGER, EmpName TEXT);
CREATE TABLE COMPANY(EmpId INTEGER, Position INTEGER,JoiningDate DATE);

Joining Two Tables:


sqlite > select EMPLOYEE.EmpName, COMPANY.Position from EMPLOYEE JOIN COMPANY;

Fused Location Provider android- Google I/O 2013 - Beyond the Blue Dot: New Features in Android

Android Internet Connectivity Check Api

   ConnectivityManager connManager = (ConnectivityManager) contex.getSystemService(Context.CONNECTIVITY_SERVICE);

 android.net.NetworkInfo wifi = connManager
                    .getNetworkInfo(ConnectivityManager.TYPE_WIFI);

 android.net.NetworkInfo mobile = connManager
                    .getNetworkInfo(ConnectivityManager.TYPE_MOBILE);

            if (wifi.isAvailable()) {
                return true;
            } else if (mobile.isAvailable()) {
                return true;
            } else {
                return false;

            }