How to create Stored Procedure in SQL Server

Store procedure is composed of Structured Query Language (SQL) which is found in a Relational Database Management System. Stored Procedure is used to store SQL queries that are mainly used to modify data from a Database. This is an alternative way in connecting our application to a database. In this tutorial Instead of embedding SQL … Read more How to create Stored Procedure in SQL Server

Get SQL Server Database Connection String

Note: I’m using Visual Studio 2013 SQL Database Connection  – To view Database Connection String using Visual Studio. Open your Visual Studio IDE and navigate to View-> SQL Server Object Explorer. Then navigate to SQL Server Explorer from the left pane of your development Environment. Connect to your server using the button with plus sign … Read more Get SQL Server Database Connection String

ASP.NET MVC File Architecture

Solution Explorer

ASP.NET Web application is created with the MVC template and is auto-generated by the Integrated Development Environment of Visual studio. The default folder structure of this framework has specified places where you can place your code classes. View, Model, and Controller The model should be in the Model Folder. The Controller must be in the controller folder. The … Read more ASP.NET MVC File Architecture

Create your first ASP.NET MVC Web Application

Web Application

In this article, I will show you an example of how to create ASP.NET MVC Application. For those who are struggling with how to start a simple ASP.NET Project, let me guide you throughout the process. Before we start we need an Integrated Development Environment (IDE) to run our project. You can download Visual Studio … Read more Create your first ASP.NET MVC Web Application

Create Simple Asp.Net MVC Application

What is MVC? Model View Controller (MVC) is a framework, a Programming architecture where you designed your code in 3 different modules. Model, it is where all your logical properties or data are declared. View, it is where you designed or creates your Client user interface and lastly Controller, it is where you process data … Read more Create Simple Asp.Net MVC Application

Convert Image file to Base64 Encoded string in C#

Image Encoding

Transmitting images through the network or through API’s and Web service in programming is a little bit tricky. And the best way to do it is to convert images into a string or to be significant convert it into ASCII code which is commonly understood by most of the computer system. On this page we are going … Read more Convert Image file to Base64 Encoded string in C#

Build a Simple REST API in PHP

Restful Web Services

API in Programming Overview:           Application program interface (API) is a set of instructions, protocols, or implementation that is created to be accessible in a client-side application. It is also used for securely transmitting data when it comes to the database application. It Controls data flow and limits client-side applications to have full control of the main … Read more Build a Simple REST API in PHP