Coding Paradox

Blog On .Net, CSharp, Windows Phone Programming

Archive for the ‘ASP.Net’ tag

Using ASP.Net WebAPI with Web Forms

with one comment

Asp.Net WebAPI is a framework for building RESTful HTTP services which can be used across a wide range of clients including web, phone and desktop applications. With WebAPI we can use XML and JSON to send and retrieve data from the service. The use of Json or XML makes it quite flexible to be used across a variety of devices.

Although WebAPI ships and installs with ASP.Net MVC 4, it can be used in normal Web Forms application as well.

In this example, we will use WebAPI with a traditional Web Forms application for adding and displaying a list of User Information. We will be using Visual Studio 2012 and .Net 4.5.

Creating the Project

Open Visual Studio 2012, Go To New -> Project. Select Visual C# -> Web from the left hand navigation and select project type as ASP.Net Web Forms Application. Enter the project name as WebAPIDemo

A new project will be created with a default template and our solution will show the following structure

Adding Model Class

We will then add a Model Class to our project. The Model class will represent the data in our application. We will add a model class called Users in our project

Read the rest of this entry »

Written by Mako

May 1st, 2013 at 3:33 pm

Calling ASP.Net WebAPI using HttpClient

without comments

In this post, we are going to learn how to call an ASP.Net WebAPI using HttpClient libraries. The HttpClient Library is quite useful and can be used while calling your WebAPI from Windows applications, Console Applications or even Windows 8 applications.

We will use the same WebAPI which we created in my previous post “Using ASP.Net WebAPI with WebForms” but this time we will consume it from a WPF application.

Create A WPF Application Project

Open Visual Studio 2012, Go To New -> Project. Select Visual C# -> Windows from the left hand navigation and select project type as WPF Application. Enter the project name as WebAPIClient.

Installing WebAPI Client Libraries

We will then add the HttpClient libraries in our project using the NuGet Package Manager which makes it very easy to install the libraries in our project

In the Tools menu, select Library Package Manager -> Manage NuGet Packages For Solution

In the Manage NuGet Packages dialog box which opens, select online and search for “Http Client” and select the Microsoft Http Client Libraries which appear as shown below

Select Install and it will ask you to select the project in which you want to install it. Click on Ok and close the dialog once the installation is done.

Similarly also install the package “JSON.Net” from Nuget Package Manager.

Read the rest of this entry »

Written by Mako

February 24th, 2013 at 8:12 pm

Posted in ASP.Net,C#,WebAPI

Tagged with , ,

Store Images in SQL Server

with one comment

In the following Post, we will look at how to save images in SQL server.  We will then read the image from the Sql Server and will render it on our page using a Http Handler.

First we will create a Database in Sql Server called ImageDB . Below are the table and stored procedure scripts which we are going to use in the application

The Image Table contains an ImageData column of type varbinary which will be used to store the images. Sql Server also contains an Image Data type but as per MSDN site, it is going to be removed from future versions so it is better to go with varbinary.

We will create a new ASP.Net Web Application in Visual Studio. The default.aspx page of our application will have the following markup

Type the Path of the image that you want to store in the Database in the textbox. Clicking on Save Button will save the image in the database and will retrieve the image from and display in in the page using Image Handler.

Here is the Code for the click event

In the save button click, we are using the ‘ReadAllBytes’ method of the File class to read the image file and store it as a byte array. We are then calling the Insert Image stored procedure to store the image in the Sql Server database.  We are returning the ID of the image from the stored procedure and passing it to the ‘ShowSelectedImage’  function which will display the image.

We are going to create an HttpHandler which will get the image from the Database. Right Click on the solution and select Add -> New Item -> Generic Handler and name it ‘ImageHandler.ashx’ .

We are using ImageHandler so that we can dynamically generate images instead of reading the image from the Database, saving it on a file and then displaying it.

An HttpHandler derives from the IHttpHandler interface and implements “ProcessRequest()” function and “IsReusable” property. Here is what the code for out ImageHandler.ashx will look like

The “ProcessRequest()” method get called for each request and we are passing the ID of the image to the handler as a query string. The “GetImageFromDB” will call the stored procedure and return the contents from the Database.

We will write the Byte contents of the image to the Response Stream using the Response.BinaryWrite method.

To use an HttpHandler, we will have to register it in out Web.Config file.

In the Type we are mentioning the classname and the assembly name combination.

Here is the Code for “ShowSelectedImage” which calls the HttpHandler.

We are setting the ImageURL property of the Image to point to handler and we are passing the id of the image as query string.

Any image that you upload will be stored in the SqlServer Database and will be retrieved and displayed dynamically.

For running the solution, make changes the “ConnectionString” property as per your system configuration. You can also find the Database script in the attached zip solution as ‘Script.sql’.

Download Solution

Written by Mako

February 4th, 2012 at 7:37 am

Posted in ASP.Net,C#,Sql Server

Tagged with , ,