This article will demonstrate how to perform CRUD (Create, Read, Update, Delete) operations using jTable jQuery plug-in and ASP.NET Web API 2 OData service.
Used Environment: VS 2013 Update 1, Entity Framework 6, ASP.NET Web API 2, jTable 2.4.0
Tag: Web API
jQuery DataTables With ASP.NET Web API 2 OData Service
In this article, we will implement jQuery DataTables with ASP.NET Web API 2 OData Services for creating table listings and effective searching, sorting and pagination.
Used Environment: VS 2013 Update 1, Entity Framework 6, ASP.NET MVC 5, jQuery DataTables 1.9.4, jQuery DataTables OData connector
Map Chart with Pop-Up Details using ASP.NET Web API and jVectorMap
In this tutorial, we will implement to get data from ASP.NET Web API and create map chart with markers using jVectorMap plugin. jQuery UI dialog will be used to display drill-down detail information in a responsive and clean manner. This post is based on jVectorMap Data Visualization tutorial.
C# LINQ: Saving JSON Data to SQL Server Database using JSON.NET and SqlBulkCopy
In this post, we will add JSON data to Sql Server tables using ASP.NET Web API, JSON.NET and SqlBulkCopy. The data is posted using jQuery ajax to web api which accepts JObject type argument, parse data, arrange data in the required table structure and save to database. Here is the structure of JSON and SQL Server tables.
Facebook Style Wall Posts and Comments using Knockout.js and ASP.NET Web API
In this article, we will implement Facebook style wall posting with following features using Knockout.js, jQuery and ASP.NET MVC 4 with Web API.
1. Add new post and display the latest post first
2. Add new comment to post
3. Display date time in fuzzy time stamps (e.g. 5 mins ago..)
4. Auto-grow textarea for long posting and commenting
5. Comment link to toggle comment box
6. Display user avatar for posts and comments
CRUD Operations using jQuery Dialog with WYSIWYG HTML Editor, Knockout and ASP.NET Web API
In this article, We will implement CRUD (Create, Read, update and delete) operations with Knockout.js, ASP.NET Web API, Entity Framework 5.0 Database First Approach. For Add or Edit operation, A modal dialog having WYSIWYG Html editor is used. User can enter information and submit it. It should look like the image below:
Using Microsoft Translator With ASP.NET MVC 4 Web API
This article explains how to use the Microsoft Translator API to translate text that was input by the user. Microsoft Translation Service is an online service which has support for AJAX, HTTP or SOAP and Basic subscriptions, up to 2 million characters a month, are free. Google’s free Translation API are deprecated So Microsoft Translator is a good alternative. In this sample, we will use AJAX API for English to Hindi translation.
Database Change Notifications in ASP.NET using SignalR and SqlDependency
This article shows how to display real time sql server database change notification in ASP.NET using SignalR and SqlDependency object which represents a query notification dependency between an application and an instance of SQL Server. Consider your database is updated or synchronized by windows service in background, you have to display real time updated data. This article explains how to implement it.
HTTP PATCH Requests (Partial Updates) in ASP.NET Web API and EF DB First
To update an entity in ASP.NET Web API, PUT request is used and we have to send all the properties even if only a subset have changed means if only one field is updated on the client side, we have to send the entire model back to the server to make an update. It’s not a cool way. PATCH request allows you to send just the modified properties for partial model updates. It reduces complexity in case of bigger tables. Here is a usage example to implement HTTP Patch request in ASP.NET Web API to update data with EF DB First.
Fast Downloading with Parallel Requests using ASP.NET Web API
In this article, we will implement to download parts of file in parallel to get the complete file faster. It is very useful to download large file and saves a bunch of time. ASP.NET Web API supports byte range requests(available in latest nightly build) with ByteRangeStreamContent class. We will request the ranges of file parts in parallel and merge them back into a single file.
Syncing Offline Database(HTML5 IndexedDB) With Online Database using ASP.NET Web API
In my previous tutorial, we have implemented CRUD operations on HTML5 IndexedDB database to provide offline support. The next step is to synchronize offline and online databases. In this tutorial, we are going to implement synchronization of IndexedDB and SQL Server databases using ASP.NET Web API.
Real-Time Chart using HTML5 Push Notification (SSE) and ASP.NET Web API
In my recent post, we have seen how to create basic chart using jQuery Flot and ASP.NET Web API. In this article, we’ll create a chart to display real-time updates using native HTML5 push notification. The HTML5 Server-Sent event (SSE) model allows you to push real-time data updates from the server to the browser.
Passing Multiple Parameters to ASP.NET Web API With jQuery
ASP.NET MVC 4 Web API has limited support to map POST form variables to simple parameters of a Web API method. Web API does not deal with multiple posted content values, you can only post a single content value to a Web API Action method. This post explains the different ways to pass multiple parameters to Web API method.
Creating a Chart with jQuery Flot and ASP.NET Web API
This article explains how to display interactive charts with Flot jQuery plugin and ASP.NET Web API. Flot is an open source Javascript plotting library produces graphical plots of arbitrary datasets on-the-fly client-side. We’ll get data from database using ASP.NET Web API and use it to display chart.
Add, Edit, Delete In jqGrid With ASP.NET Web API
This post explains how to implement a simple CRUD (Create, Read, Update, and Delete) in jqGrid with ASP.NET MVC 4 Web API. If you are beginner to Web API, read this post to create a web API that supports CRUD operations. We will use GET, POST, PUT and DELETE HTTP methods for Select, Insert, Update and Delete operations respectively.