Friday, March 29, 2013
You can edit PDF files with in a browser. check this out
Download
               Extension for Mozilla Fire fox
               Extension for Google Chrome
         
Thursday, March 28, 2013
Managing office Add Ins (enabling, disabling or removing)
Word
Click the Microsoft Office Button , click Word Options, and then click Add-Ins.
View the add-ins and application extensions that are categorized as follows:
Active Application Add-ins Lists the extensions that are registered and currently running in your Office program.
Inactive Application Add-ins Lists the add-ins that are present on your computer but are not currently loaded. For example, smart tags or XML Schemas are active only when the document that references them is open. Another example is the COM add-ins that are listed in the COM Add-ins dialog box. If the check box for a COM add-in is selected, the add-in is active. If the check box for a COM add-in is cleared, the add-in is inactive.
Document Related Add-ins Lists template files that are referenced by currently open documents.
Disabled Application Add-ins Lists add-ins that were automatically disabled because they are causing Office programs to crash.

For other office tools visit this Microsoft article.
Finding Duplicates in a table wit SQL

Sometimes finding rows with some duplicate values in some column(s) may be necessary. Let's see how can we manage this thing.
SELECT [Column_Name], COUNT([Column_Name]) AS Number_of_Occurrences
FROM [Table_Name]
GROUP BY [Column_Name]
HAVING ( COUNT( [Column_Name] ) > 1 )

And the query to get all PKs ( primary keys ) for rows with duplicate [Column_Name]
SELECT [Primary_key_Column]
FROM [Table_Name]
WHERE [Column_Name] IN (
SELECT [Column_Name]
FROM [Table_Name]
GROUP BY [Column_Name]
HAVING ( COUNT([Column_Name]) > 1 ))

Let's see it with an example. Let's say we have a tale called  Students and the column we are working on is students first name.
So the above code will become


SELECT [First_Name], COUNT([First_Name]) AS Number_of_Occurrences
FROM [Students]
GROUP BY [First_Name]
HAVING ( COUNT( [First_Name] ) > 1 )
And the query to get all PKs ( primary keys ) for rows with duplicate [First_Name]:
SELECT [Student_ID]
FROM [Students]
WHERE [First_Name] IN (
SELECT [First_Name]
FROM [Table_Name]
GROUP BY [First_Name]
HAVING ( COUNT([First_Name]) > 1 ))
This is simple right? yes it is. :D


Error:-
Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
Personal Note:- This occurred in my ASP.NET web application
Solution:- 
Delete all or related files inside the folder 
C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files

Windows system key combinations
  • F1: Help
  • CTRL+ESC: Open Start menu
  • ALT+TAB: Switch between open programs
  • ALT+F4: Quit program
  • SHIFT+DELETE: Delete item permanently
  • Windows Logo+L: Lock the computer (without using CTRL+ALT+DELETE)
Windows program key combinations
  • CTRL+C: Copy
  • CTRL+X: Cut
  • CTRL+V: Paste
  • CTRL+Z: Undo
  • CTRL+B: Bold
  • CTRL+U: Underline
  • CTRL+I: Italic
Mouse click/keyboard modifier combinations for shell objects
  • SHIFT+right click: Displays a shortcut menu containing alternative commands
  • SHIFT+double click: Runs the alternate default command (the second item on the menu)
  • ALT+double click: Displays properties
  • SHIFT+DELETE: Deletes an item immediately without placing it in the Recycle Bin
General keyboard-only commands
  • F1: Starts Windows Help
  • F10: Activates menu bar options
  • SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an object
  • CTRL+ESC: Opens the Start menu (use the ARROW keys to select an item)
  • CTRL+ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)
  • CTRL+SHIFT+ESC: Opens Windows Task Manager
  • ALT+DOWN ARROW: Opens a drop-down list box
  • ALT+TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window)
  • SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature
  • ALT+SPACE: Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
  • ALT+- (ALT+hyphen): Displays the Multiple Document Interface (MDI) child window's System menu (from the MDI child window's System menu, you can restore, move, resize, minimize, maximize, or close the child window)
  • CTRL+TAB: Switch to the next child window of a Multiple Document Interface (MDI) program
  • ALT+underlined letter in menu: Opens the menu
  • ALT+F4: Closes the current window
  • CTRL+F4: Closes the current Multiple Document Interface (MDI) window
  • ALT+F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed, ALT+F6 switches between the Find dialog box and the main Notepad window)
Shell objects and general folder/Windows Explorer shortcuts
For a selected object:
  • F2: Rename object
  • F3: Find all files
  • CTRL+X: Cut
  • CTRL+C: Copy
  • CTRL+V: Paste
  • SHIFT+DELETE: Delete selection immediately, without moving the item to the Recycle Bin
  • ALT+ENTER: Open the properties for the selected object

To copy a file

Press and hold down the CTRL key while you drag the file to another folder.

To create a shortcut

Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.
General folder/shortcut control
  • F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)
  • F5: Refreshes the current window.
  • F6: Moves among panes in Windows Explorer
  • CTRL+G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only)
  • CTRL+Z: Undo the last command
  • CTRL+A: Select all the items in the current window
  • BACKSPACE: Switch to the parent folder
  • SHIFT+click+Close button: For folders, close the current folder plus all parent folders
Windows Explorer tree control
  • Numeric Keypad *: Expands everything under the current selection
  • Numeric Keypad +: Expands the current selection
  • Numeric Keypad -: Collapses the current selection.
  • RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first child
  • LEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parent
Properties control
  • CTRL+TAB/CTRL+SHIFT+TAB: Move through the property tabs
Accessibility shortcuts
  • Press SHIFT five times: Toggles StickyKeys on and off
  • Press down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and off
  • Press down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and off
  • Left ALT+left SHIFT+NUM LOCK: Toggles MouseKeys on and off
  • Left ALT+left SHIFT+PRINT SCREEN: Toggles high contrast on and off
Microsoft Natural Keyboard keys
  • Windows Logo: Start menu
  • Windows Logo+R: Run dialog box
  • Windows Logo+M: Minimize all
  • SHIFT+Windows Logo+M: Undo minimize all
  • Windows Logo+F1: Help
  • Windows Logo+E: Windows Explorer
  • Windows Logo+F: Find files or folders
  • Windows Logo+D: Minimizes all open windows and displays the desktop
  • CTRL+Windows Logo+F: Find computer
  • CTRL+Windows Logo+TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)
  • Windows Logo+TAB: Cycle through taskbar buttons
  • Windows Logo+Break: System Properties dialog box
  • Application key: Displays a shortcut menu for the selected item
Microsoft Natural Keyboard with IntelliType software installed
  • Windows Logo+L: Log off Windows
  • Windows Logo+P: Starts Print Manager
  • Windows Logo+C: Opens Control Panel
  • Windows Logo+V: Starts Clipboard
  • Windows Logo+K: Opens Keyboard Properties dialog box
  • Windows Logo+I: Opens Mouse Properties dialog box
  • Windows Logo+A: Starts Accessibility Options (if installed)
  • Windows Logo+SPACEBAR: Displays the list of Microsoft IntelliType shortcut keys
  • Windows Logo+S: Toggles CAPS LOCK on and off
Dialog box keyboard commands
  • TAB: Move to the next control in the dialog box
  • SHIFT+TAB: Move to the previous control in the dialog box
  • SPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option.
  • ENTER: Equivalent to clicking the selected button (the button with the outline)
  • ESC: Equivalent to clicking the Cancel button
  • ALT+underlined letter in dialog box item: Move to the corresponding item
Sunday, March 24, 2013
How to Learn online and get certified?

Here are the most well known online learning initiatives by world's most renowned universities

EDX:-   https://www.edx.org/
Coursera:- https://www.coursera.org/
Udacity:-  https://www.udacity.com/

Just go to the above links and register, then start learning for FREE.    Love it!  :D
The following is sample EDX Certificate
Sample EDX Certificate

How to redirect to a certain page after the some specific time.
Code
Syntax:- header("refresh:time; url=redirection page");

Example:- header( "refresh:3;url=index.php" );

If we put the above line of code to the very beginning of our page it will redirect to the index.php page after the time given.
How to popup an Alert on Button Click from code behind in Asp.net 2.0?
You can try this out.
string script = "alert(\"Hello!\");";
    ScriptManager.RegisterStartupScript(this,this.GetType(),
                  "ServerControlScript", script, true);
 or 
 ScriptManager.RegisterStartupScript(this.GetType() , 
"alerts", "javascript:alert('Hello')", ,true);

Shortcuts in Ubuntu

General keyboard shortcuts

Ctrl + A = Select all
Ctrl + C = Copy the highlighted content to clipboard
Ctrl + V = Paste the clipboard content
Ctrl + N = New (Create a new document, not in terminal)
Ctrl + O = Open a document
Ctrl + S = Save the current document
Ctrl + P = Print the current document
Ctrl + W = Close the close document
Ctrl + Q = Quit the current application

Keyboard shortcuts for GNOME desktop

Ctrl + Alt + F1 = Switch to the first virtual terminal
Ctrl + Alt + F2(F3)(F4)(F5)(F6) = Select the different virtual terminals
Ctrl + Alt + F7 = Restore back to the current terminal session with X
Ctrl + Alt + Backspace = Restart GNOME
Alt + Tab = Switch between open programs
Ctrl + Alt + L = Lock the screen.
Alt + F1 = opens the Applications menu
Alt + F2 = opens the Run Application dialog box.
Alt + F3 = opens the Deskbar Applet
Alt + F4 = closes the current window.
Alt + F5 = unmaximizes the current window.
Alt + F7 = move the current window
Alt + F8 = resizes the current window.
Alt + F9 = minimizes the current window.
Alt + F10 =  maximizes the current window.
Alt + Space = opens the window menu.
Ctrl + Alt + + = Switch to next X resolution
Ctrl + Alt + - = Switch to previous X resolution
Ctrl + Alt + Left/Right = move to the next/previous workspace

Keyboard shortcuts for Terminal

Ctrl + A = Move cursor to beginning of line
Ctrl + E = Move cursor to end of line
Ctrl + C = kills the current process.
Ctrl + Z = sends the current process to the background.
Ctrl + D = logs you out.
Ctrl + R = finds the last command matching the entered letters.
Enter a letter, followed by Tab + Tab = lists the available commands beginning with those letters.
Ctrl + U = deletes the current line.
Ctrl + K = deletes the command from the cursor right.
Ctrl + W = deletes the word before the cursor.
Ctrl + L = clears the terminal output
Shift + Ctrl + C = copy the highlighted command to the clipboard.
Shift + Ctrl + V (or Shift + Insert) = pastes the contents of the clipboard.
Alt + F = moves forward one word.
Alt + B = moves backward one word.
Arrow Up/Down = browse command history
Shift + PageUp / PageDown = Scroll terminal output

Keyboard shortcuts for Compiz

Alt + Tab = switch between open windows
Win + Tab = switch between open windows with Shift Switcher or Ring Switchereffect
Win + E = Expo, show all workspace
Ctrl + Alt + Down = Film Effect
Ctrl + Alt + Left mouse button = Rotate Desktop Cube
Alt + Shift + Up = Scale Windows
Ctrl + Alt + D = Show Desktop
Win + Left mouse button = take screenshot on selected area
Win + Mousewheel = Zoom In/Out
Alt + Mousewheel = Transparent Window
Alt + F8 = Resize Window
Alt + F7 = Move Window
Win + P = Add Helper
F9 = show widget layer
Shift + F9 = show water effects
Win + Shift + Left mouse button = Fire Effects
Win + Shift + C = Clear Fire Effects
Win + Left mouse button = Annotate: Draw
Win + 1 = Start annotation
Win + 3 = End annotation
Win + S = selects windows for grouping
Win + T = Group Windows together
Win + U = Ungroup Windows
Win + Left/Right = Flip Windows

Keyboard shortcut for Nautilus

Shift + Ctrl + N = Create New Folder
Ctrl + T = Delete selected file(s) to trash
Alt + ENTER = Show File/Folder Properties
Ctrl + 1 = Toggle View As Icons
Ctrl + 2 = Toggle View As List
Shift + Right = Open Directory (Only in List View)
Shift + Left = Close Directory (Only in List View)
Ctrl + S = Select Pattern
F2 = Rename File
Ctrl + A = Select all files and folders
Ctrl + W = Close Window
Ctrl + Shift + W = Close All Nautilus Windows
Ctrl + R = Reload Nautilus Window
Alt + Up = Open parent directory
Alt + Left = Back
Alt + Right = Forward
Alt + Home = go to Home folder
Ctrl + L = go to location bar
F9 = Show sidepane
Ctrl + H = Show Hidden Files
Ctrl + + = Zoom In
Ctrl + - = Zoom Out
Ctrl + 0 = Normal Size
(For those who want to configure your own keyboard shortcuts, you can do it atSystem->Preferences->Keyboard Shortcuts.)
my unity desktop is invisible after upgrading to 12.10

Open terminal and add the following commands (Open Terminal- Ctrl+Alt+T or Ctrl+T depending your version) for List of shortcuts visit this Post.

sudo apt-get install --reinstall unity,
sudo apt-get install --reinstall ubuntu-desktop
Europian Standard professional Curriculum Vitae Development
download MS word template Here   See Sample CV
Create your CV online  Old CV Editor  or New CV Editor

Enjoy!
Opening Blocked websites using the hiload.org web proxy
Follow the following instructions

1- Type in http://hiload.org/ in your browser's navigation bar and press Go.

2- Once you get the the hiload.org website go down the page and Type in the blocked website and pres GO as follows.


Friday, March 22, 2013
Publishing new article to the Solution Explorer is too easy, once you log-in  to blogger click on the new post button -> set title of the post (Tip:- make it to short) -> write your article and hit the publish button right next to the title box.

Finally select your post and set the label from the label drop down. that's it!

Archive

Recommend Us

Visitors