Tuesday, 17 February 2015

How to create Database without using DBHelper Class


public Method()
{
 ...
//create database
SQLiteDatabase db = this.openOrCreateDatabase("DatabaseName.db", 0, null);

 //create table
db.execSQL("CREATE TABLE tableName ( columname1,columname2,columname3);");
            
//insert row
String sql="Insert into tableName(columname1,columname2,columname3) values(v1,v2,v3
db.execSQL(sql);


//update row
String insertId="UPDATE tableName SET columname1 = " + demovalue
                        + " where columname2=" + Hello";
db.execSQL(insertId);

//drop table
db.execSQL("DROP TABLE tableName;");


if( existsColumnInTable(db,tableName, columname3))
{
   // colum is duplicate
}
...
}
private boolean existsColumnInTable(SQLiteDatabase inDatabase,
            String inTable, String columnToCheck) {
        try {
            Cursor mCursor = inDatabase.rawQuery("SELECT * FROM " + inTable
                    + " LIMIT 0", null);
            if (mCursor.getColumnIndex(columnToCheck) != -1)
                return true;
            else
                return false;

        } catch (Exception Exp) {
            Log.d("... - existsColumnInTable",
                    "When checking whether a column exists in the table, an error occurred: "
                            + Exp.getMessage());
            return false;
        }
    }

Monday, 11 August 2014

Select image from Gallery or capture images from Camera in Android

select image from Gallery call :

                        Intent intent = new Intent();
                        intent.setType("image/*");
                        intent.setAction(Intent.ACTION_GET_CONTENT);
                        startActivityForResult( Intent.createChooser(intent, "Select Picture"),
                                SELECT_PICTURE);

select captured  image from Camera  call :

                        Intent intent = new Intent(
                        MediaStore.ACTION_IMAGE_CAPTURE);
                        intent.putExtra(MediaStore.EXTRA_OUTPUT,
                                MediaStore.Images.Media.EXTERNAL_CONTENT_URI.getPath());
                        startActivityForResult(intent, CAMERA_CAPTURE);


protected void onActivityResult(int requestCode, int resultCode, Intent data) {
        super.onActivityResult(requestCode, resultCode, data);

        switch (requestCode)
        {
        case (SELECT_PICTURE)://select picture from gallary

            try
            {
                Uri selectedImageUri = data.getData();
                selectedImagePath = getPath(selectedImageUri);
                System.out.println("Image Path : " + selectedImagePath);

            }
            catch(Exception e)
           {
            }

            break;

        case (CAMERA_CAPTURE)://select captured picture from camera
            if (resultCode == Activity.RESULT_OK)
            {
                Bitmap bitmap;
                bitmap = (Bitmap) data.getExtras().get("data");

             }
            break;
        }
    }

Tuesday, 22 April 2014

Display FullScreen Ad in Android applicaton

Step1:
 Add GoogleAdMobAdsSdk-4.1.1.jar file in your project.
step2:
Implement AdListener
Step3:
Override Method of interface .

step4:
declare variable private InterstitialAd interstitial;

Step5:
class Demo implements AdListener
{
............
private InterstitialAd interstitial;
..........
write this in your onCreate()
{
     ......
               interstitial = new InterstitialAd(activity, "xxxxxxxx");//replace xxxxxxx is Admob Id
              AdRequest adRequest = new AdRequest();
              interstitial.loadAd(adRequest);
              adFlag=true;
              interstitial.setAdListener(GameOverWindow.this);

    .....
}
 ..............

@Override
        public void onReceiveAd(Ad arg0) {
            // TODO Auto-generated method stub
                          interstitial.show();
        }
}

how Display Banner size Ad in Android Application

Banner Size Ad:-

Window window1 = this.getWindow();
                    LinearLayout adsLayout = new LinearLayout(this);
                    LinearLayout.LayoutParams lp2 = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.WRAP_CONTENT, LinearLayout.LayoutParams.FILL_PARENT);
                    // Displays Ads at the bottom of your sketch, use Gravity.TOP to display them at the top
                    adsLayout.setGravity(Gravity.BOTTOM);
                   
         AdView           adView = new AdView(this, AdSize.BANNER, "xxxxxxxxxx");

                    adsLayout.addView(adView);
                    AdRequest newAdReq = new AdRequest();

                    adView.loadAd(newAdReq);
                    window1.addContentView(adsLayout,lp2);



Note :U need to add GoogleAdMobAdsSdk-4 jar file in u r project
xxxxxxxxx replace with your ad mob Id

Saturday, 12 April 2014

Maharashtra RTO passings...!



Code District
MH-01 Mumbai (Central) - RTO is located in Tardeo
MH-02 Mumbai (West) - RTO is located in Andheri West
MH-03 Mumbai (East) - RTO is located in Wadala
MH-04 Thane
MH-05 Thane (Central Suburbs): Kalyan, Dombivli, Ulhasnagar, Ambernath and Badlapur - RTO is located in Kalyan
MH-06 Raigad - RTO is located in Pen (does not include Navi Mumbai, Kharghar to Panvel)
MH-07 Sindhudurg
MH-08 Ratnagiri
MH-09 Kolhapur
MH-10 Sangli
MH-11 Satara
MH-12 Pune
MH-13 Solapur
MH-14 Pune (Outskirts) - RTO is located in Pimpri-Chinchwad
MH-15 Nashik
MH-16 Ahmednagar
MH-17 Shrirampur
MH-18 Dhule
MH-19 Jalgaon
MH-20 Aurangabad
MH-21 Jalna
MH-22 Parbhani
MH-23 Beed
MH-24 Latur
MH-25 Osmanabad
MH-26 Nanded
MH-27 Amravati
MH-28 Buldana
MH-29 Yavatmal - RTO is located on Nagpur Road
MH-30 Akola
MH-31 Nagpur
MH-32 Wardha
MH-33 Gadchiroli
MH-34 Chandrapur
MH-35 Gondia
MH-36 Bhandara
MH-37 Washim
MH-38 Hingoli
MH-39 Nandurbar
MH-40 Wadi, Nagpur (rural)
MH-41 Malegaon
MH-42 Baramati
MH-43 Navi Mumbai - RTO is located in Vashi (Sanpada)
MH-44 Ambejogai
MH-45 Akluj
MH-46 Panvel
MH-47 Borivali, Mumbai (Western Suburbs from Goregaon to Dahisar)[2]
MH-48 Vasai Thane (Western Suburbs from Vasai) - RTO is located in Virar
MH-49 Nagpur (East) - RTO is located on Bhandara Road
MH-50 Karad (Satara Rural) - RTO is located in Karad

Sunday, 23 February 2014

Units of Computer Memory Measurements

1 Bit = Binary Digit
8 Bits = 1 Byte
1024 Bytes = 1 KB (Kilo Byte)
1024 KB = 1 MB (Mega Byte)
1024 MB = 1 GB(Giga Byte)
1024 GB = 1 TB(Terra Byte)
1024 TB = 1 PB(Peta Byte)
1024 PB = 1 EB(Exa Byte)
1024 EB = 1 ZB(Zetta Byte)
1024 ZB = 1 YB (Yotta Byte)
1024 YB = 1 (Bronto Byte)
1024 Brontobyte = 1 (Geop Byte)

Sunday, 9 February 2014

More Than 100 Keyboard Shortcuts

More Than 100 Keyboard Shortcuts
Keyboard Shortcuts (Microsoft Windows)
1. CTRL+C (Copy)
2. CTRL+X (Cut)
... 3. CTRL+V (Paste)
4. CTRL+Z (Undo)
5. DELETE (Delete)
6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
7. CTRL while dragging an item (Copy the selected item)
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
9. F2 key (Rename the selected item)
10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
15. CTRL+A (Select all)
16. F3 key (Search for a file or a folder)
17. ALT+ENTER (View the properties for the selected item)
18. ALT+F4 (Close the active item, or quit the active program)
19. ALT+ENTER (Display the properties of the selected object)
20. ALT+SPACEBAR (Open the shortcut menu for the active window)
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneously)
22. ALT+TAB (Switch between the open items)
23. ALT+ESC (Cycle through items in the order that they had been opened)
24. F6 key (Cycle through the screen elements in a window or on the desktop)
25. F4 key (Display the Address bar list in My Computer or Windows Explorer)
26. SHIFT+F10 (Display the shortcut menu for the selected item)
27. ALT+SPACEBAR (Display the System menu for the active window)
28. CTRL+ESC (Display the Start menu)
29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command)
30. F10 key (Activate the menu bar in the active program)
31. RIGHT ARROW (Open the next menu to the right, or open a submenu)
32. LEFT ARROW (Open the next menu to the left, or close a submenu)
33. F5 key (Update the active window)
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer)
35. ESC (Cancel the current task)
36. SHIFT when you insert a CD-ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing)
Dialog Box - Keyboard Shortcuts
1. CTRL+TAB (Move forward through the tabs)
2. CTRL+SHIFT+TAB (Move backward through the tabs)
3. TAB (Move forward through the options)
4. SHIFT+TAB (Move backward through the options)
5. ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
6. ENTER (Perform the command for the active option or button)
7. SPACEBAR (Select or clear the check box if the active option is a check box)
8. Arrow keys (Select a button if the active option is a group of option buttons)
9. F1 key (Display Help)
10. F4 key (Display the items in the active list)
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Microsoft Natural Keyboard Shortcuts
1. Windows Logo (Display or hide the Start menu)
2. Windows Logo+BREAK (Display the System Properties dialog box)
3. Windows Logo+D (Display the desktop)
4. Windows Logo+M (Minimize all of the windows)
5. Windows Logo+SHIFT+M (Restorethe minimized windows)
6. Windows Logo+E (Open My Computer)
7. Windows Logo+F (Search for a file or a folder)
8. CTRL+Windows Logo+F (Search for computers)
9. Windows Logo+F1 (Display Windows Help)
10. Windows Logo+ L (Lock the keyboard)
11. Windows Logo+R (Open the Run dialog box)
12. Windows Logo+U (Open Utility Manager)
13. Accessibility Keyboard Shortcuts
14. Right SHIFT for eight seconds (Switch FilterKeys either on or off)
15. Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
16. Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either on or off)
18. NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
19. Windows Logo +U (Open Utility Manager)
20. Windows Explorer Keyboard Shortcuts
21. END (Display the bottom of the active window)
22. HOME (Display the top of the active window)
23. NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
24. NUM LOCK+Plus sign (+) (Display the contents of the selected folder)

MMC Console keyboard shortcuts

1. SHIFT+F10 (Display the Action shortcut menu for the selected item)
2. F1 key (Open the Help topic, if any, for the selected item)
3. F5 key (Update the content of all console windows)
4. CTRL+F10 (Maximize the active console window)
5. CTRL+F5 (Restore the active console window)
6. ALT+ENTER (Display the Properties dialog box, if any, for theselected item)
7. F2 key (Rename the selected item)
8. CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

Remote Desktop Connection Navigation
1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
2. ALT+PAGE UP (Switch between programs from left to right)
3. ALT+PAGE DOWN (Switch between programs from right to left)
4. ALT+INSERT (Cycle through the programs in most recently used order)
5. ALT+HOME (Display the Start menu)
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
7. ALT+DELETE (Display the Windows menu)
8. CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the entire client window area on the Terminal server clipboardand provide the same functionality aspressing ALT+PRINT SCREEN on a local computer.)

Microsoft Internet Explorer Keyboard Shortcuts
1. CTRL+B (Open the Organize Favorites dialog box)
2. CTRL+E (Open the Search bar)
3. CTRL+F (Start the Find utility)
4. CTRL+H (Open the History bar)
5. CTRL+I (Open the Favorites bar)
6. CTRL+L (Open the Open dialog box)
7. CTRL+N (Start another instance of the browser with the same Web address)
8. CTRL+O (Open the Open dialog box,the same as CTRL+L)
9. CTRL+P (Open the Print dialog box)
10. CTRL+R (Update the current Web page)
11. CTRL+W (Close the current window)