In earlier versions of IE, I used to be able to see the zone information such as “Local intranet | Protected Mode: Off” in the middle of status bar and it was very useful while troubleshooting Server Errors. This information is no longer available in the status bar starting with IE 9. It is now under Files > Properties.
It also includes other information such as Protocol, Type, Connection, Address, Size of the page and the timestamps as shown below:
Hope this helps.
Sonny
ExcelDataImport xlsDataImport =
new ExcelDataImport("data.xls", "Sheet1", "aTable");
xlsDataImport.UploadDataToSqlServerDb(connStr);
You could either pass a single sheet/table name pair or an array of sheet names and corresponding table names.If you ever want to pretty-print or beautify your source code files in Notepad++, you might have heard about UniversalIndentGUI (UIGUI) plugin for Notepad++ (Npp). However, when you tried to install this plugin for Npp via the Plugin Manager, you might have gotten the following error:
Installation of UniversalIndentGUI failed
There is an active ticket at UniversalIndentGUI issues list, which has been opened for 16 moths with a single comment made about 7 weeks ago. I could not find any help related to how you could resolve this error. I also could not find much reference to this plugin either from the UniversalIndentGUI page nor from Notepad++ Plugins List. So I have downloaded the latest release of UIGUI to see if I could manually install it as a plugin for Npp, but disappointed to find out that it is not a plugin anymore but a stand-alone Windows application.
It works pretty good as a Windows application and has support for lot of languages as you can see from the above screenshot taken from the UIGUI’s home page. However, I could not search nor could I edit the file as easily as I could in Npp, so it would really be nice if I could get it to work as a plugin.
The last known version of UIGUI plugin for 1.0.2. which is what Npp uses to install when you try to install this plugin via Plugin Manager. This info is in the file PluginManagerPlugins.xml, which is typically located in your profile directory on Windows 7. That is in the following directory:
%USERPROFILE%\AppData\Roaming\Notepad++\plugins\config
If you can’t find it there, then bring up the Plugin Manager dialog and click on the Settings button at the bottom. In the Plugin Manager Settings dialog, you should be able to see the Config path setting being used by your install of Npp.
Open the PluginManagerPlugins.xml and locate the UIGUI section and you should see something similar to the following:
Note: I had to use the XML Tools for Notepad++ to format this file. XML Tools for Notepad++ is another Npp plugin that gives you lot of XML tools including pretty-printing XML files. I was able to install this using the Plugin Manager.
If you try to download the plugin zip file referenced in this config file, you get redirected to http://sourceforge.net/projects/universalindent/files/, which is the home location of UIGUI files. From here, you would want to go to uigui folder and then to UniversalIndentGUI_1.0.2 folder, and from there, you want to download the UniversalIndentGUI_1.0.2_NotepadPPplugin.zip file. Or you might want to just use the following URL to download the plugin zip file:
After downloading the zip and extracting it to a some temp directory on your system, as per the XML snippet, move/copy the files as shown above. $NPPDIR$ is typically “C:\Program Files (x86)\Notepad++” and $PLUGINDIR$" is “C:\Program Files (x86)\Notepad++\plugins”. Restart Npp and you should see UIGUI listed under the Plugins menu. You should now be able to indent/format/pretty-print a wide-variety of source code files right inside Npp.
Happy Coding!
Sonny
What happened to my nifty Windows Command icon inside Notepad++ (Npp), is the question I have asked myself a few times before and I do not really remember how I got it back the last time I looked for it.
If you are wondering about what the heck is Windows Command icon in Npp, then you must not have used it already. It is the icon you get when you installed Npp plugin called NppExec.
NppExec is a very powerful/useful plugin for Npp. It gives you Console Window (cmd.exe) functionality right inside from Notepad++. Note that it is not an emulator of Console Window (CW) nor a command interpreter according to NppExec manual.
That means all the DOS commands such as dir, xcopy, move that you would run in the CW can directly be run right from Npp. For example, you might have used dir or tree command and redirected their output to a text file to include it in your documentation. Well, you no longer need to do that, you could run such commands right from Npp and you could copy the output right from the Console inside Npp and paste it into any text file that you have opened in Npp.
If I remember correctly, it used to be included in the Npp default install, but I no longer see it in my latest version (v5.9.8) of Npp. After looking around, I finally learned that it is a plugin and hence need to be installed if it did not already get installed with the default Npp install.
To install it, you could use the Plugin Manager which is another plugin that gets included with the default install of Npp. Under Plugins menu, go to Plugin Manager and click on “Show Plugin Manager” command to bring up the Plugin Manager dialog.
As shown above, navigate to the NppExec line and select and click on the Install button. Follow the prompts and it will automatically download and install the plugin for you. You might be asked to restart the Npp to complete the installation.
Once the install is complete you would see NppExec listed under the Plugins menu as shown below:
Either select the “Show Console Dialog” from the above menu or click on the little console window icon 
It also has advanced scripting functionality, which I have not explored yet, but looks promising.
Hope you find this useful.
Sonny
