Monthly Archives: January 2014

AngularJS in Visual Studio

AngularJS is open source Java Script framework, it will help you develop single page application with html pages. AngularJS lets you extend HTML vocabulary for your application and the resulting environment is extraordinarily expressive, readable, and quick to develop .  Its goal is to augment browser-based applications with model–view–controller (MVC) capability specially “angular-route” JS give you a feel of MVC route facility.

You can install required JS file using  Manage NuGet Packages  or download via given Link

Steps and Hello world application is given here

  • Open Visual Studio and create New Website.

AngularJS 1

  • Select ASP.Net Empty Website.

AngularJS 2

  • Right Click on Website Solution and select Manage NuGet Packages option, It will show given popup.
  • Search for AngularJS it will show you related package, Please click on install to add with your website

AngularJS 3

  • Install AngularJS Package

AngularJS 6

  • Install AngularJS core, route or animate according to your requirement.

AngularJS 7

  • Now you can see all JS files downloaded in your solution in Scripts folder

Screenshot (27)

  • Please insert a HTML file in your website form Add new items

Screenshot (28)

  • Add HTML page

Screenshot (29)

  • Edit HTML code for Hello World App

Here we will add a TEXT BOX when user will type his name in the text box it will simultaneously update with

Hello …..  on the website , you can get this feature by add one script file and two line in your HTML file.

<!DOCTYPE html>
<html ng-app>
<script src=”Scripts/angular.js”></script>
<input type=”text” ng-model=”name” />
<h2>Hello {{name}} !!!</h2>

Screenshot (30)

  • Run page on browser and check the change.

AngularJS 1



Power Map for Excel

Power Map is a 3D Data visualization tool , add-in for Excel for mapping, exploring, and interacting with geographical and temporal data. its provide facility to  plot your data geographic and temporal data visually, analyze that data in 3D, and create cinematic tours to share with others.

    Possibilities with Power Map:

    • Map Data: You may plot more than a 10 Lakhs rows of data in 3D visually on Bing maps and visualize the data with 3D columns, bubble/pie charts  or different kind of chart.
    • Discover Insights: You may discover new insights by seeing your data in geographic space and seeing time-stamped data change over time.
    • Share Stories: You may capture screenshot and build cinematic, guided interactive or video.

Note : You must be connected to the internet to use Power Map and Online data connectivity required and performance experience depends on hardware/software configuration

  • Download installer file form given link   Click here


Select the installer file to download and click on next button


  • Double click on downloaded installer file


  • Click on agree option  and press on next button 


  • You may change the installation folder from here


  • Click on close to finish the installation


  • Now you can see the Map option under insert menu in your Excel 


You have to install Power Query add-in for Excel to complete this process ( Installation Guide & Download Link )

  • Select  “form CSV”  in Power Query  menu to import data

Screenshot (6) 

  • Select downloaded CSV file ( you may use other option to import data according to the given choice )

Screenshot (7) 

  • Imported Data in Query Editor (here you can remove unwanted columns and add new custom columns) 

Screenshot (8)

  • Add custom column to join District and State name which may help us to locate it on Map

Screenshot (9)

  • for Example here ( formula:   =[Name] & “, ” & “Uttar Pradesh” )

Screenshot (10)

  • In result all rows will get the value according to the requirement

Screenshot (11)

  • To use data for map click on Load data to model

Screenshot (12)

  • Now Data Loaded to the Model

Screenshot (14) 

  • Select on Launch Power Map in Insert option

Screenshot (15) 

  • As you will select on Name column location will plot on Bing Map then click on Next option

Screenshot (16)


Screenshot (17)

  • As you will select measure fields, it will show you columns on 3D Map ( you can change view according to the requirement )

Screenshot (18)