WCF and RESTFul Service

I was attending few webminars and read materials over the past few weeks on the WCF fundamentals. One of the great feature with WCF is its ability to expose the services in RESTful format.

SQL Server 2008 Training in Texas

The schedule for the SQL server 2008 training @ TCU Texas,

The registration can be made thrugh TCU's site. Click here to register

SQL Class Date:

June 20th from 9 am to 4 pm

June 21st from 1 pm to 5 pm

June 27th from 9 am to 4 pm

June 28th from 1 pm to 5 pm

PLINQO - Plano,TX Training updates

Yesterday i attended a .NET user group training in Plano, TX about the PLINQO demonstration. PLINQO stands for Professional LINQ to Objects.

The presenters did a great job of demonstrating the PLINQO libraries and its benefit over microsoftjavascript:void(0)'s LINQ.

The greates feature i liked about this component is its ability to dynamically sync up with the database object and Batch Querying.

To learn more about PLINQO please visit the website PLINQO

ORACLE Fusion Dev platform

Oracle is hosting an event to demonstrate about their new product ORACLE FUSION Development Platform - ORACLE ADF 11g. This appears to be a full day event with demo, Q&A session. Click here to register and download material

JQuery - Part 3 Dynamic object loading

This post is about loading a control dynamically through Jquery scripts.

The powerful feature of Jquery selectors combined with CSS scripts enables the client side loading of controls with less coding/effort.

I recently incorporated this featur in one of the projects where we had a requirement to dynamically change the image at run time based on the result set from the database query. I would not want to write server side code to determine the image, Instead i started to research about loading the image through Jquery selectors.

The project required to load the image at one of the table column < td >.

I declared a placeholder client side div with a id "loadImage".
"< td >
< div id="loadImage" >
< %# DataBinder.Eval(Container.DataItem, "Flag").ToString().Trim()% >
< /div >
< /td >"

On the document ready event i wrote the Jquery funtion which will locate the position of the DIV and load the image on the particular DIV as below.

$(document).ready(function() {

$('#tbl_temp tr').each(function() {

var valueee = $(this).find('div');
var txt = jQuery.trim(valueee.text());

var imgSrc = "";
if (txt == 'G') {
imgSrc = 'images/green_icon.gif'
}

else if (txt == 'O') {
imgSrc = 'images/gray_icon.gif'
}
else {
}

if (imgSrc.length > 0) {
var img = new Image()
$(img) // once the image has loaded, execute this code

.load(function() {
//debugger;
$(this).hide();

valueee
.empty()
//.text = '';
// remove the loading class (so no background spinner),
// then insert our image
.append(this);
//debugger;
// fade our image in to create a nice effect
$(this).fadeIn();
}) // if there was an error loading the image, react accordingly
.error(function() {
// notify the user that the image could not be loaded
})
// set the src attribute of the new image to our image
.attr('src', imgSrc)
.css({ 'border': 'none' });
}
})
});

REST Services

REST - Respresentation State Transfer is recently been given much importance in the industry. REST is neither a programming language nor a tool. It is an architecture to build the network system.

Microsofts ADO.NET Data Service is build on the REST framework. There are some good webcasts and article about the ADO.NET data service in Microsoft website and its worth watching.

Jquery part 2 – Selectors

Jquery API provides an interface called “Selectors” which is a powerful component to filter the HTML elements based on the element name, id and element type.

The DOM elements can be selected with the Jquery function “$” or “jquery”. For example, the hyperlinks in the HTML pages can be retrieved using the selector $(a).

Following are the few examples of sample selectors that are very useful for DOM manipulation.

a – Retrieves all anchor links with the tag < a >.

#DOMElementID – Retrieves the DOM element with the id “DOMID”.

.DOMElementClass – Retrieves the DOM elements with the class “DOMClass”.

P a.DOMElementClass – Retrieves the DOM element links with the class “DOMClass” embedded within the tag < p >.

Ul > Li > a – Retrieves links which are children of list element

which are in turn children of < ul >.

A[href^=http://] – Retrieves links with an href value beginning with http://.

Div[type=text] – retrieves html text box.

P:odd – retrieves every odd paragraph elements.

Li:last-child – retrieves last child < li > of each < ul > element.

:radio:checked – retrieves radio buttons in the DOM that are checked.

:checkbox:checked – retrieves checkboxes in the Dom that are checked.

Input:not(:checkbox) – retrieves input elements from the DOM except checkboxes.