Connect Microsoft Azure SQL Data Base to Local SQL Server Management Studio


Here i would like to explain how to connect Microsoft Azure SQL Data Base to Local SQL Server Management Studio, It’s very Easy to manage Azure SQL Data Base.Below are the Steps.

Step 01.

Create Data base on Azure.

  1. Go SQL Data Bases,then Add New

22.  Enter Data Base Details and Create Data Base with Server.



3.After Database created, click on database and get Properties, Copy server name to some where.


Step 02.

Open SQL Server Management Studio and Enter Azure SQL Server Details.


if you got error like below after you press connect.Please add Azure Sql Server firewall rule as below.


Rule Name : sp_set_firewall_rule

Start IP : Client IP

End IP : Client IP


Step 03.

Now you can connect Azure SQL data base using Azure SQL Data base credentials.





Create Simple SharePoint Provider Hosted App with Microsoft Azure

This explains you to how to create SharePoint Provider Hosted App with Microsoft Azure,


  1. Office 365 site (you can create Free trial site from Microsoft).Create Office 365 Account
  2. Microsoft Azure Account ( you can create free trial account from Microsoft).Create Azure Account
  3. Microsoft Visual Studio 2013 or 2015 (I’ll explain with 2013).

Step 01.

Start a new Visual Studio Project, use the “App for SharePoint 2013” template as in the following list.


Step 02.

Select the Provider-hosted option for this example. In a Provider-hosted app, application resources will be deployed in a server outside the SharePoint environment.Enter Your SharePoint office 365 site as Debugging App.


Step 03.

Select the type of web project you want to Host.I select “ Web form Application”,this step is most related to development architecture.(Ex. Tiered Architecture or MVC) .


Step 04 

In the next step, select “Use Client secret (requires a SharePoint farm connected to ACS)”. We will be using the Access Control Service (ACS) available with Microsoft Azure for this example.Simply Access between Hosted Account (Azure).



Step 05.

Click “Finish” and the project is created for you by Visual Studio. You can see two projects created under the solution. The first project consists of just an app icon and AppManifest.xml that manages all the settings like start URL, permission, Query strings, Client ID, Tokens and so on.6

Step 06.

The next step is to register a new app using client Id and Client Secret.

  • Go to the “/_layouts/15/appregnew.aspx” page of your SharePoint site (in my case, it is to generate the client Id and client secret id,
  • Click on the generate buttons of Client Id and Client Secret to generate both.


Step 07.

We need to fill in “App Domain” and “Redirect URL”. In fact, this is the website where the app is hosted. I am using Microsoft Azure to host my app. Let us go to the Windows Azure Management Portal and create a web site to host your app.


Step 08.

This the Web Site I have creted on Azure and credted Azure Site Details.



Step 09.

Enter Azure Site details on SharePoint App Registration form and press create button, then you will see App Identifier created message.


Copy the Client Id and Client Secret to a safe place.


Step 10.

The next step is to publish both projects separately. First, publish the app project as in the following


Enter Client Id and Client secret in below form and click finish.


Step 11.

Click Package your App,then you have to enter Azure Web site url and Client Id. After that Packed App file folder will open as below sreens.


Enter Url of Azure Web Site.


App file folder Location



Step 12.

Upload App File to SharePoint Site. You Should upload App file to Developer Site not a Team Site. Go How to Create Developer Site

  • Click New App To Deploy.


  • Then it’ll pop up App upload Panel


  • Click on Upload link and Upload you packaged App solution.


  • After successfully uploaded it’ll pop-up below screen,then press deploy button.


  • Now You can see your App on Site contents.


Step 13.

Click on App it’ll become server error , because we haven’t deployed the remote web to Microsoft Azure. The next step is to deploy the web app to Azure.


Step 14.

Publish the application to Microsoft Azure. Open web.config and update the client ID and Client secret as in the following


Step 15.

Then Publish the Web Solution to Azure, You can download Publish Profile settings from Azure Web site Setting.


Step 16.

After Successfully published you can retrieve Azure Web Site.

 Step 17.

Finally you click on app on SharePoint you can see app works as below.


Another thing get basic idea about App configuration from “AppManifest.xml”,Ex. App Startup page.





What is .Net Frame work ? (A simple description)

The .NET Framework is a  platform created by Microsoft for Software developing.It has lot of versions,new released version is 4.6 (April-2016).

Microsoft Definition: A programming infrastructure created by Microsoft for building, deploying, and running applications and services that use .NET technologies, such as desktop applications and Web services.

.net Architecture


  • It is Platform for software Developers.
  • It supports many programming languages ( Ex. , ,
  • It supports cross platform developments (Ex.IOS,Android).
  • It has Integrated Development Environment (IDE) (Ex.Microsoft Visual Studio).
  • .NET Framework also includes the .NET Common Language Run-time (CLR), which is responsible for maintaining the execution of all applications developed using the .NET library.

Common Language Run-time (CLR) is the most important part of the .net framework,simply it converts your source code (c#, to  native language (Machine Language).so then source code supports with operating system.

Components of the CLR.

Component-of CLR

1. Class Loader : Is an abstract class. Its purpose is to tell  CLR in what manner a class is to be loaded at runtime.

2. MSIL : Microsoft Intermediate Language is considered to be the lowest form of human readable language. It is CPU independent and includes instructions of how to load, store, initialize objects. JIT converts this MSIL into native code which is dependent on the CPU.

3. Code Manager : Is responsible for managing code at run-time.

4. Garbage Collector : The .NET garbage collector enables high-speed allocation and release of memory for the objects in managed code. Its main aim is proper memory management and optimizing the memory.

5. Security Engine : It ensures all the security restrictions.

6. Type Checker : It enforces the constraints of types. It enforces strictness in type checking.

7. Thread Support : It allows multi-threading.

8. Debug engine : It allows proper debugging of an application.

9. Base class library : It provides all the types that an application need at runtime.

10. Exception manager : Handles all the exception for an application during runtime.

11. COM Marshaller : It provides an option for interoperability for an application.

Steps of Source code compiling 

Step 1- Application code is written using a .NET – compatible language C#.


Step 2 – Code is compiled into MSIL, which is stored in an assembly (see Figure 1 – 2).



Step 3 – When this code is executed (either in its own right if it is an executable or when it is used from other code), it must first be compiled into native code using a JIT compiler.

Step 4 – The native code is executed in the context of the managed CLR, along with any other running applications or processes.


Hope you Learned some thing , this is very simple description,refer MSDN to more in detail about .net framework,


Send SMS using usb dongle or modem in, and SharePoint


Here I would like to explain how to send SMS using USB dongle and modem, In here i have built some custom component to send sms very easily.Just you need call a method.


01. Download component.

  Download SMS Component

02. Add “UdaraDev.SMSUtility.dll” to Solution reference. 

03. Its very simple, Just insert below code

  • Method definition :

SMSComponent.SendSMS(“Dongle Attached Physical port name”,”Phone Number you want to send SMS”,”Text Message”).


SMSComponent.SendSMS(“COM16”, “0711022122”, “HI”);



Send SMS in and SharePoint using USB Dongle or Modem

Hi , Here i would like to explain how to send SMS using Dongle in and SharePoint,

Below code set works for both and SharePoint.


SerialPort serialport = new SerialPort(); // Create Serial port object to set physical Port in machine which dongle installed.

//Set Serial Port Properties
int mSpeed = 1;
 serialport.PortName ="COM16"; //Set Usb modem attached Port - as a example i'm using COM16 port
 serialport.BaudRate = 96000;
 serialport.Parity = Parity.None;
 serialport.DataBits = 8;
 serialport.StopBits = StopBits.One;
 serialport.Handshake = Handshake.XOnXOff;
 serialport.DtrEnable = true;
 serialport.RtsEnable = true;
 serialport.NewLine = Environment.NewLine;
//Sending SMS

serialport.WriteLine("AT+CMGF=1" + Environment.NewLine);
 serialport.WriteLine("AT+CSCS=GSM" + Environment.NewLine);
 serialport.WriteLine("AT+CMGS=" + (char)34 + "+94711022122"(char)34+Environment.NewLine);    //Set Recievers Phone Number
 serialport.WriteLine(TextMessage + (char)26);


Thanks, Hope you learned something…….