Creating and updating EXCEL file in Windows Azure Web Role using Open XML SDK

Problem Statement You need to create and upload EXCEL file in Windows Azure Web Role. Since there is no MS Office present on AZURE VM so you cannot use Office InterOP Dll. So you are left with option of Open XML SDK to create and update Excel file. Solution Approach Create and update Excel file…… Continue reading Creating and updating EXCEL file in Windows Azure Web Role using Open XML SDK

Charts in Windows Phone 7

Today morning I got a call from SQL Server Guru  Pinal Dave and conversation was as below.       So, I started working on this. I decided to go ahead with hard coded data as below,   And function returning data is,       To add chart control on XAML, I added namespace…… Continue reading Charts in Windows Phone 7

Fetching Web Roles details using Windows Azure Management API

If you are writing some tool to manage Windows Azure portal then fetching information about Roles may be frequent requirement for you. In this post, we will discuss the way to Fetch below information about a Web Role or Worker Role using Windows Azure Management API. RoleName InstanceName InstanceStatus Any client making call to Azure…… Continue reading Fetching Web Roles details using Windows Azure Management API

Nested ListBox binding in Silverlight and Windows Phone 7

While creating an application I came across a requirement when I had to put a listbox inside a list box and then I had bind that nested listbox dynamically. For example say, entity class called Roles as below, And you are using Role class in another entity class called Subscription as property We need to…… Continue reading Nested ListBox binding in Silverlight and Windows Phone 7

Downloading file as byte array from AZURE BLOB storage in WCF Service

In this post I will show you how you can download a file from AZURE BLOB storage as byte array. Contract To download file client will have to provide ContainerName and filename to be downloaded. Service Implementation Very first you need to add reference of, Microsoft.WindowsAzure Microsoft.WindowsAzure.StorageClient Second you need to create connection string to…… Continue reading Downloading file as byte array from AZURE BLOB storage in WCF Service

Creating X.509 certificate from Windows Azure BLOB

Sometime you may have to create X.509 certificate on the fly. Imagine you are writing a WCF Service to be hosted in App Fabric or creating a WCF Service Web Role to be hosted in Microsoft Data center. In these scenarios you don’t have access to local file system and in the service you are…… Continue reading Creating X.509 certificate from Windows Azure BLOB

Fetching Hosting Services Name using Windows Azure Management API

Windows Azure Management API enables you to manage Azure subscription through codes. In this post, I will show, how you could list hosted services inside your subscription through code ? Windows Azure Management API is REST based API and allows you to perform almost all management level tasks with Azure subscription. Any client making call…… Continue reading Fetching Hosting Services Name using Windows Azure Management API

Uploading management certificate in Windows Azure subscription

To work with Service Management API client has to authenticate itself to the Azure portal. You need to upload X.509 certificate to the portal. There are many ways and several tools available to crate X.509 certificates. Easiest way I find is using IIS. Read here to create certificate for Azure subscription Before you go ahead…… Continue reading Uploading management certificate in Windows Azure subscription

Setting the Start page in Windows Phone 7 application

Very often I see people struggling in setting start page for Windows Phone 7 application. By default MainPage.xaml serve as start page. If you have many xaml in phone application you are creating like below, Now you have three xaml in Windows Phone application project. If you want to set Page2.xaml as start page then…… Continue reading Setting the Start page in Windows Phone 7 application