{"id":4363,"date":"2015-06-22T06:29:40","date_gmt":"2015-06-22T06:29:40","guid":{"rendered":"http:\/\/a1webdesignteam.com\/blog\/?p=4363"},"modified":"2015-06-22T06:29:40","modified_gmt":"2015-06-22T06:29:40","slug":"ajax-using-asp-net-2-0-and-c","status":"publish","type":"post","link":"https:\/\/a1webdesignteam.com\/blog\/ajax-using-asp-net-2-0-and-c\/","title":{"rendered":"AJAX using ASP.NET 2.0 and C#"},"content":{"rendered":"<div class=\"single-post\">\n<p>AJAX, short for Asynchronous JavaScript And XML, isn\u2019t a technology but rather a grouping of technologies. AJAX uses a communication technology (typically SOAP and XML) to send and receive an asynchronous request\/response to the server, and then leverages presentation technologies (JavaScript, DOM, HTML, and CSS) to process the response. Applications using AJAX are legitimate today, because most browsers support the necessary technology.<\/p>\n<p>AJAX, short for Asynchronous JavaScript And XML, isn\u2019t a technology but rather a grouping of technologies. AJAX uses a communication technology (typically SOAP and XML) to send and receive an asynchronous request\/response to the server, and then leverages presentation technologies (JavaScript, DOM, HTML, and CSS) to process the response. Applications using AJAX are legitimate today, because most browsers support the necessary technology.<\/p>\n<p>First, you need to import the Ajax namespace from Ajax.DLL.The Ajax namespace contains Ajax.dll encapsule Asynchronous Javascript and XML in Bin folder. This is an combination of Javascript and XML. The data is transfered in the form of XML.<\/p>\n<div id=\"crayon-5587a97ae94bb746669174\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate crayon-wrapped\" data-settings=\" minimize scroll-always wrap\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-plain-button\" title=\"Toggle Plain Code\"><\/div>\n<div class=\"crayon-button crayon-wrap-button crayon-pressed\" title=\"Toggle Line Wrap\"><\/div>\n<div class=\"crayon-button crayon-copy-button\" title=\"Copy\"><\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\"><\/div>\n<p><span class=\"crayon-language\">C#<\/span><\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" data-settings=\"mouseover\">using Ajax;<br \/>\nusing System.Data.SqlClient;<br \/>\n<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94bb746669174-0\">0<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94bb746669174-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94bb746669174-2\">2<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94bb746669174-3\">3<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5587a97ae94bb746669174-0\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94bb746669174-1\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">Ajax<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94bb746669174-2\" class=\"crayon-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Data<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">SqlClient<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94bb746669174-3\" class=\"crayon-line crayon-striped-line\"><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>If you\u2019re looking for a really good web host, try Server Intellect \u2013 we found the setup procedure and control panel, very easy to adapt to and their IT team is awesome!<br \/>\nIn tutorial, the only configuration step beyond that is to add the following code in the web.config file, inside the element.<\/p>\n<div id=\"crayon-5587a97ae94c6873873614\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate crayon-wrapped\" data-settings=\" minimize scroll-always wrap\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-plain-button\" title=\"Toggle Plain Code\"><\/div>\n<div class=\"crayon-button crayon-wrap-button crayon-pressed\" title=\"Toggle Line Wrap\"><\/div>\n<div class=\"crayon-button crayon-copy-button\" title=\"Copy\"><\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\"><\/div>\n<p><span class=\"crayon-language\">Scheme<\/span><\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" data-settings=\"mouseover\">&lt;httpHandlers&gt;<br \/>\n&lt;add verb=&#8221;POST,GET&#8221; path=&#8221;ajax\/*.ashx&#8221; type=&#8221;Ajax.PageHandlerFactory, Ajax&#8221;\/&gt;<br \/>\n&lt;\/httpHandlers&gt;<br \/>\n<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94c6873873614-0\">0<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94c6873873614-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94c6873873614-2\">2<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94c6873873614-3\">3<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94c6873873614-4\">4<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5587a97ae94c6873873614-0\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94c6873873614-1\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-o\">&lt;<\/span><span class=\"crayon-i\">httpHandlers<\/span><span class=\"crayon-o\">&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94c6873873614-2\" class=\"crayon-line\"><span class=\"crayon-o\">&lt;<\/span><span class=\"crayon-i\">add<\/span> <span class=\"crayon-i\">verb<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8220;POST,GET&#8221;<\/span> <span class=\"crayon-i\">path<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8220;ajax\/*.ashx&#8221;<\/span> <span class=\"crayon-i\">type<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8220;Ajax.PageHandlerFactory, Ajax&#8221;<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-o\">&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94c6873873614-3\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-o\">&lt;<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-i\">httpHandlers<\/span><span class=\"crayon-o\">&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94c6873873614-4\" class=\"crayon-line\"><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>In order to make server-side functions available through JavaScript, two things must be done. First, the function or functions in question must be marked with the Ajax.AjaxMethodAttribute. Second, the class containing these functions must be registered through a call to Ajax.Utility.RegisterTypeForAjax during the page load event. Then we use GetData() even of btnGetData and display() event of DropDownList to do the work. The button btnGetData is a html button. It display employee data without page post-back. When chose a particular record in the Dropdownlist, the employee name and employee ID will be displayed in the label.<\/p>\n<p>The code below can go in the tags of the ASPX page:<\/p>\n<div id=\"crayon-5587a97ae94cc035914099\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate crayon-wrapped\" data-settings=\" minimize scroll-always wrap\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-plain-button\" title=\"Toggle Plain Code\"><\/div>\n<div class=\"crayon-button crayon-wrap-button crayon-pressed\" title=\"Toggle Line Wrap\"><\/div>\n<div class=\"crayon-button crayon-copy-button\" title=\"Copy\"><\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\"><\/div>\n<p><span class=\"crayon-language\">JavaScript<\/span><\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" data-settings=\"mouseover\">&lt;script language=&#8221;javascript&#8221; type=&#8221;text\/javascript&#8221;&gt;<br \/>\nfunction GetData()<br \/>\n{<br \/>\nvar response;<br \/>\nAjax_CSharp.GetData(GetData_CallBack);<br \/>\n}<\/p>\n<p>function GetData_CallBack(response)<br \/>\n{<br \/>\nvar response=response.value;<\/p>\n<p>if(response==&#8221;Empty&#8221;)<br \/>\n{<br \/>\nalert(&#8220;No Record Found !!!&#8221;);<br \/>\n}<br \/>\nelse if(response==&#8217;Error&#8217;)<br \/>\n{<br \/>\nalert(&#8220;An Error occured in accessing the DataBase !!!&#8221;);<br \/>\n}<br \/>\nelse<br \/>\n{<br \/>\nvar arr=response.split(&#8220;~&#8221;);<br \/>\nvar empID=arr[0].split(&#8220;,&#8221;);<br \/>\nvar empName=arr[1].split(&#8220;,&#8221;);<\/p>\n<p>document.getElementById(&#8216;dlistEmployee&#8217;).length=0;<br \/>\nfor(var i=0;i&lt;empID.length;i++)<br \/>\n{<br \/>\nvar o = document.createElement(&#8220;option&#8221;);<br \/>\no.value = empID[i];<br \/>\no.text = empName[i];<br \/>\ndocument.getElementById(&#8216;dlistEmployee&#8217;).add(o);<br \/>\n}<br \/>\n}<br \/>\n}<\/p>\n<p>function display()<br \/>\n{<br \/>\nvar selIndex=document.getElementById(&#8220;dlistEmployee&#8221;).selectedIndex;<br \/>\nvar empName=document.getElementById(&#8220;dlistEmployee&#8221;).options(selIndex).text;<br \/>\nvar empID=document.getElementById(&#8220;dlistEmployee&#8221;).options(selIndex).value;<\/p>\n<p>document.getElementById(&#8220;lblResult&#8221;).innerHTML=&#8221;You have selected &#8221; + empName + &#8221; ( ID : &#8221; + empID + &#8221; )&#8221;;<br \/>\n}<br \/>\n&lt;\/script&gt;<br \/>\n<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-0\">0<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-2\">2<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-3\">3<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-4\">4<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-5\">5<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-6\">6<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-7\">7<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-8\">8<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-9\">9<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-10\">10<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-11\">11<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-12\">12<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-13\">13<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-14\">14<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-15\">15<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-16\">16<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-17\">17<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-18\">18<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-19\">19<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-20\">20<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-21\">21<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-22\">22<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-23\">23<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-24\">24<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-25\">25<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-26\">26<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-27\">27<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-28\">28<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-29\">29<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-30\">30<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-31\">31<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-32\">32<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-33\">33<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-34\">34<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-35\">35<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-36\">36<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-37\">37<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-38\">38<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-39\">39<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-40\">40<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-41\">41<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-42\">42<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-43\">43<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-44\">44<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94cc035914099-45\">45<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94cc035914099-46\">46<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5587a97ae94cc035914099-0\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-1\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-ta\">&lt;script <\/span><span class=\"crayon-e \">language<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8220;javascript&#8221;<\/span> <span class=\"crayon-e \">type<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8220;text\/javascript&#8221;<\/span><span class=\"crayon-o\">&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-2\" class=\"crayon-line\"><span class=\"crayon-t\">function<\/span> <span class=\"crayon-e\">GetData<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-3\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-4\" class=\"crayon-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">response<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-5\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">Ajax_CSharp<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">GetData<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">GetData_CallBack<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-6\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-7\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-8\" class=\"crayon-line\"><span class=\"crayon-t\">function<\/span> <span class=\"crayon-e\">GetData_CallBack<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">response<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-9\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-10\" class=\"crayon-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">response<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">response<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">value<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-11\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-12\" class=\"crayon-line\"><span class=\"crayon-st\">if<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">response<\/span><span class=\"crayon-o\">==<\/span><span class=\"crayon-s\">&#8220;Empty&#8221;<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-13\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-14\" class=\"crayon-line\"><span class=\"crayon-r\">alert<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;No Record Found !!!&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-15\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-16\" class=\"crayon-line\"><span class=\"crayon-st\">else<\/span> <span class=\"crayon-st\">if<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">response<\/span><span class=\"crayon-o\">==<\/span><span class=\"crayon-s\">&#8216;Error&#8217;<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-17\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-18\" class=\"crayon-line\"><span class=\"crayon-r\">alert<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;An Error occured in accessing the DataBase !!!&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-19\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-20\" class=\"crayon-line\"><span class=\"crayon-st\">else<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-21\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-22\" class=\"crayon-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">arr<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">response<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">split<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;~&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-23\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">empID<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">arr<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">split<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;,&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-24\" class=\"crayon-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">arr<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">split<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;,&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-25\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-26\" class=\"crayon-line\"><span class=\"crayon-v\">document<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getElementById<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;dlistEmployee&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">length<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-27\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">for<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">i<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-v\">i<\/span><span class=\"crayon-o\">&lt;<\/span><span class=\"crayon-v\">empID<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">length<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-v\">i<\/span><span class=\"crayon-o\">++<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-28\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-29\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">o<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-v\">document<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">createElement<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;option&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-30\" class=\"crayon-line\"><span class=\"crayon-v\">o<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">value<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-v\">empID<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">i<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-31\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">o<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">text<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">i<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-32\" class=\"crayon-line\"><span class=\"crayon-v\">document<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getElementById<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;dlistEmployee&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">add<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">o<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-33\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-34\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-35\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-36\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-37\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-t\">function<\/span> <span class=\"crayon-e\">display<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-38\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-39\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">selIndex<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">document<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getElementById<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;dlistEmployee&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">selectedIndex<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-40\" class=\"crayon-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">document<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getElementById<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;dlistEmployee&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">options<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">selIndex<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">text<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-41\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-t\">var<\/span> <span class=\"crayon-v\">empID<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">document<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getElementById<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;dlistEmployee&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">options<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">selIndex<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">value<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-42\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-43\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">document<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">getElementById<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;lblResult&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e \">innerHTML<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8220;You have selected &#8220;<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-v\">empName<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-s\">&#8221; ( ID : &#8220;<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-s\">&#8221; )&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-44\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-45\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-ta\">&lt;\/script&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94cc035914099-46\" class=\"crayon-line\"><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>We used over 10 web hosting companies before we found Server Intellect. Their dedicated servers and add-ons were setup swiftly, in less than 24 hours. We were able to confirm our order over the phone. They respond to our inquiries within an hour. Server Intellect\u2019s customer support and assistance are the best we\u2019ve ever experienced.<\/p>\n<p>Register Ajax in PageLoad and get data from the employee table of Database.<\/p>\n<div id=\"crayon-5587a97ae94d2780829700\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate crayon-wrapped\" data-settings=\" minimize scroll-always wrap\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-plain-button\" title=\"Toggle Plain Code\"><\/div>\n<div class=\"crayon-button crayon-wrap-button crayon-pressed\" title=\"Toggle Line Wrap\"><\/div>\n<div class=\"crayon-button crayon-copy-button\" title=\"Copy\"><\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\"><\/div>\n<p><span class=\"crayon-language\">C#<\/span><\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" data-settings=\"mouseover\">protected void Page_Load(object sender, EventArgs e)<br \/>\n{<br \/>\nAjax.Utility.RegisterTypeForAjax(typeof(Ajax_CSharp));<br \/>\n}<\/p>\n<p>[Ajax.AjaxMethod(HttpSessionStateRequirement.ReadWrite)]<br \/>\npublic string GetData()<br \/>\n{<br \/>\ntry<br \/>\n{<br \/>\nSqlConnection con = new SqlConnection(ConfigurationManager.AppSettings[&#8220;conn&#8221;]);<br \/>\nSqlCommand cmd = new SqlCommand(&#8220;SELECT * FROM employee&#8221;, con);<br \/>\ncmd.Connection.Open();<\/p>\n<p>SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br \/>\nDataSet ds = new DataSet(&#8220;DataSet&#8221;);<br \/>\nadapter.Fill(ds, &#8220;Table&#8221;);<\/p>\n<p>if ((ds.Tables[0].Rows.Count &lt;= 0))<br \/>\n{<br \/>\nreturn &#8220;Empty&#8221;;<br \/>\n}<br \/>\nelse<br \/>\n{<br \/>\nstring empID = &#8220;&#8221;;<br \/>\nstring empName = &#8220;&#8221;;<br \/>\nfor (int i = 0; i &lt;= ds.Tables[0].Rows.Count &#8211; 1; i++)<br \/>\n{<br \/>\nempID += ds.Tables[0].Rows[i][0].ToString() + &#8220;,&#8221;;<br \/>\nempName += ds.Tables[0].Rows[i][1].ToString() + &#8220;,&#8221;;<br \/>\n}<br \/>\nempID = empID.Substring(0, empID.Length &#8211; 1);<br \/>\nempName = empName.Substring(0, empName.Length &#8211; 1);<\/p>\n<p>return empID + &#8220;~&#8221; + empName;<br \/>\n}<br \/>\n}<br \/>\ncatch<br \/>\n{<br \/>\nreturn &#8220;Error&#8221;;<br \/>\n}<br \/>\n}<br \/>\n<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-0\">0<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-2\">2<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-3\">3<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-4\">4<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-5\">5<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-6\">6<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-7\">7<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-8\">8<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-9\">9<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-10\">10<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-11\">11<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-12\">12<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-13\">13<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-14\">14<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-15\">15<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-16\">16<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-17\">17<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-18\">18<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-19\">19<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-20\">20<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-21\">21<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-22\">22<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-23\">23<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-24\">24<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-25\">25<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-26\">26<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-27\">27<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-28\">28<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-29\">29<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-30\">30<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-31\">31<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-32\">32<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-33\">33<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-34\">34<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-35\">35<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-36\">36<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-37\">37<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-38\">38<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-39\">39<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-40\">40<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-41\">41<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94d2780829700-42\">42<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94d2780829700-43\">43<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5587a97ae94d2780829700-0\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-1\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-m\">protected<\/span> <span class=\"crayon-t\">void<\/span> <span class=\"crayon-e\">Page_Load<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-t\">object<\/span> <span class=\"crayon-v\">sender<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-i\">EventArgs<\/span> <span class=\"crayon-v\">e<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-2\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-3\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">Ajax<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Utility<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">RegisterTypeForAjax<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-r\">typeof<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">Ajax_CSharp<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-4\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-5\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-6\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">Ajax<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">AjaxMethod<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">HttpSessionStateRequirement<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">ReadWrite<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-7\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-m\">public<\/span> <span class=\"crayon-t\">string<\/span> <span class=\"crayon-e\">GetData<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-8\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-9\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">try<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-10\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-11\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">SqlConnection <\/span><span class=\"crayon-v\">con<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">SqlConnection<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">ConfigurationManager<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">AppSettings<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8220;conn&#8221;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-12\" class=\"crayon-line\"><span class=\"crayon-e\">SqlCommand <\/span><span class=\"crayon-v\">cmd<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">SqlCommand<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;SELECT * FROM employee&#8221;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">con<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-13\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">cmd<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Connection<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">Open<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-14\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-15\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">SqlDataAdapter <\/span><span class=\"crayon-v\">adapter<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">SqlDataAdapter<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">cmd<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-16\" class=\"crayon-line\"><span class=\"crayon-e\">DataSet <\/span><span class=\"crayon-v\">ds<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">DataSet<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;DataSet&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-17\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">adapter<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">Fill<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-s\">&#8220;Table&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-18\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-19\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">if<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Tables<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Rows<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Count<\/span> <span class=\"crayon-o\">&lt;=<\/span> <span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-20\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-21\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">return<\/span> <span class=\"crayon-s\">&#8220;Empty&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-22\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-23\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">else<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-24\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-25\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-t\">string<\/span> <span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-s\">&#8220;&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-26\" class=\"crayon-line\"><span class=\"crayon-t\">string<\/span> <span class=\"crayon-v\">empName<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-s\">&#8220;&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-27\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">for<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-t\">int<\/span> <span class=\"crayon-v\">i<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span> <span class=\"crayon-v\">i<\/span> <span class=\"crayon-o\">&lt;=<\/span> <span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Tables<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Rows<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Count<\/span> <span class=\"crayon-o\">&#8211;<\/span> <span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">;<\/span> <span class=\"crayon-v\">i<\/span><span class=\"crayon-o\">++<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-28\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-29\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">+=<\/span> <span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Tables<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Rows<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">i<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">ToString<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-s\">&#8220;,&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-30\" class=\"crayon-line\"><span class=\"crayon-v\">empName<\/span> <span class=\"crayon-o\">+=<\/span> <span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Tables<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Rows<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">i<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">ToString<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-s\">&#8220;,&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-31\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-32\" class=\"crayon-line\"><span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-v\">empID<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">Substring<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">empID<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Length<\/span> <span class=\"crayon-o\">&#8211;<\/span> <span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-33\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">empName<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">Substring<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Length<\/span> <span class=\"crayon-o\">&#8211;<\/span> <span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-34\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-35\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">return<\/span> <span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-s\">&#8220;~&#8221;<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-36\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-37\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-38\" class=\"crayon-line\"><span class=\"crayon-st\">catch<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-39\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-40\" class=\"crayon-line\"><span class=\"crayon-st\">return<\/span> <span class=\"crayon-s\">&#8220;Error&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-41\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-42\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94d2780829700-43\" class=\"crayon-line crayon-striped-line\"><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>The front end AjaxDataSearchCSharp.aspx page looks something like this:<\/p>\n<div id=\"crayon-5587a97ae94da809919250\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate crayon-wrapped\" data-settings=\" minimize scroll-always wrap\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-plain-button\" title=\"Toggle Plain Code\"><\/div>\n<div class=\"crayon-button crayon-wrap-button crayon-pressed\" title=\"Toggle Line Wrap\"><\/div>\n<div class=\"crayon-button crayon-copy-button\" title=\"Copy\"><\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\"><\/div>\n<p><span class=\"crayon-language\">XHTML<\/span><\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" data-settings=\"mouseover\">&lt;div align=&#8221;center&#8221;&gt;<br \/>\n&lt;input id=&#8221;btnGetData&#8221; onclick=&#8221;GetData();&#8221; type=&#8221;button&#8221; value=&#8221;To Get Employee Data From DB&#8221; style=&#8221;width: 203px&#8221; \/&gt;<br \/>\n&amp;nbsp;&amp;nbsp;<br \/>\n&lt;asp:DropDownList ID=&#8221;dlistEmployee&#8221; runat=&#8221;server&#8221; onchange=&#8221;display();&#8221;&gt;<br \/>\n&lt;\/asp:DropDownList&gt;&lt;asp:Label ID=&#8221;lblResult&#8221; runat=&#8221;server&#8221; Text=&#8221;No Record Selected&#8221;&gt;&lt;\/asp:Label&gt;<br \/>\n&lt;\/div&gt;<br \/>\n<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94da809919250-0\">0<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94da809919250-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94da809919250-2\">2<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94da809919250-3\">3<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94da809919250-4\">4<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94da809919250-5\">5<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94da809919250-6\">6<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94da809919250-7\">7<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5587a97ae94da809919250-0\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94da809919250-1\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-r \">&lt;div <\/span><span class=\"crayon-e \">align<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;center&#8221;<\/span><span class=\"crayon-r \">&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94da809919250-2\" class=\"crayon-line\"><span class=\"crayon-r \">&lt;input <\/span><span class=\"crayon-e \">id<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;btnGetData&#8221;<\/span> <span class=\"crayon-e \">onclick<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;GetData();&#8221;<\/span> <span class=\"crayon-e \">type<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;button&#8221;<\/span> <span class=\"crayon-e \">value<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;To Get Employee Data From DB&#8221;<\/span> <span class=\"crayon-e \">style<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;width: 203px&#8221;<\/span><span class=\"crayon-r \"> \/&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94da809919250-3\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-i \">&amp;nbsp;&amp;nbsp;<\/span><\/div>\n<div id=\"crayon-5587a97ae94da809919250-4\" class=\"crayon-line\"><span class=\"crayon-r \">&lt;asp:DropDownList <\/span><span class=\"crayon-e \">ID<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;dlistEmployee&#8221;<\/span> <span class=\"crayon-e \">runat<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;server&#8221;<\/span> <span class=\"crayon-e \">onchange<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;display();&#8221;<\/span><span class=\"crayon-r \">&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94da809919250-5\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-r \">&lt;\/asp:DropDownList&gt;<\/span><span class=\"crayon-r \">&lt;asp:Label <\/span><span class=\"crayon-e \">ID<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;lblResult&#8221;<\/span> <span class=\"crayon-e \">runat<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;server&#8221;<\/span> <span class=\"crayon-e \">Text<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s \">&#8220;No Record Selected&#8221;<\/span><span class=\"crayon-r \">&gt;<\/span><span class=\"crayon-r \">&lt;\/asp:Label&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94da809919250-6\" class=\"crayon-line\"><span class=\"crayon-r \">&lt;\/div&gt;<\/span><\/div>\n<div id=\"crayon-5587a97ae94da809919250-7\" class=\"crayon-line crayon-striped-line\"><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>The flow for the code behind page is as follows.<\/p>\n<div id=\"crayon-5587a97ae94e3025424913\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate crayon-wrapped\" data-settings=\" minimize scroll-always wrap\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-plain-button\" title=\"Toggle Plain Code\"><\/div>\n<div class=\"crayon-button crayon-wrap-button crayon-pressed\" title=\"Toggle Line Wrap\"><\/div>\n<div class=\"crayon-button crayon-copy-button\" title=\"Copy\"><\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\"><\/div>\n<p><span class=\"crayon-language\">C#<\/span><\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\"><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" data-settings=\"mouseover\">using System;<br \/>\nusing System.Data;<br \/>\nusing System.Data.SqlClient;<br \/>\nusing System.Configuration;<br \/>\nusing System.Collections;<br \/>\nusing System.Web;<br \/>\nusing System.Web.Security;<br \/>\nusing System.Web.UI;<br \/>\nusing System.Web.UI.WebControls;<br \/>\nusing System.Web.UI.WebControls.WebParts;<br \/>\nusing System.Web.UI.HtmlControls;<br \/>\nusing Ajax;<\/p>\n<p>public partial class Ajax_CSharp : System.Web.UI.Page<br \/>\n{<br \/>\nprotected void Page_Load(object sender, EventArgs e)<br \/>\n{<br \/>\nAjax.Utility.RegisterTypeForAjax(typeof(Ajax_CSharp));<br \/>\n}<\/p>\n<p>[Ajax.AjaxMethod(HttpSessionStateRequirement.ReadWrite)]<br \/>\npublic string GetData()<br \/>\n{<br \/>\ntry<br \/>\n{<br \/>\nSqlConnection con = new SqlConnection(ConfigurationManager.AppSettings[&#8220;conn&#8221;]);<br \/>\nSqlCommand cmd = new SqlCommand(&#8220;SELECT * FROM employee&#8221;, con);<br \/>\ncmd.Connection.Open();<\/p>\n<p>SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br \/>\nDataSet ds = new DataSet(&#8220;DataSet&#8221;);<br \/>\nadapter.Fill(ds, &#8220;Table&#8221;);<\/p>\n<p>if ((ds.Tables[0].Rows.Count &lt;= 0))<br \/>\n{<br \/>\nreturn &#8220;Empty&#8221;;<br \/>\n}<br \/>\nelse<br \/>\n{<br \/>\nstring empID = &#8220;&#8221;;<br \/>\nstring empName = &#8220;&#8221;;<br \/>\nfor (int i = 0; i &lt;= ds.Tables[0].Rows.Count &#8211; 1; i++)<br \/>\n{<br \/>\nempID += ds.Tables[0].Rows[i][0].ToString() + &#8220;,&#8221;;<br \/>\nempName += ds.Tables[0].Rows[i][1].ToString() + &#8220;,&#8221;;<br \/>\n}<br \/>\nempID = empID.Substring(0, empID.Length &#8211; 1);<br \/>\nempName = empName.Substring(0, empName.Length &#8211; 1);<\/p>\n<p>return empID + &#8220;~&#8221; + empName;<br \/>\n}<br \/>\n}<br \/>\ncatch<br \/>\n{<br \/>\nreturn &#8220;Error&#8221;;<br \/>\n}<br \/>\n}<br \/>\n}<br \/>\n<\/textarea><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-0\">0<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-2\">2<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-3\">3<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-4\">4<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-5\">5<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-6\">6<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-7\">7<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-8\">8<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-9\">9<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-10\">10<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-11\">11<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-12\">12<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-13\">13<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-14\">14<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-15\">15<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-16\">16<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-17\">17<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-18\">18<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-19\">19<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-20\">20<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-21\">21<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-22\">22<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-23\">23<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-24\">24<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-25\">25<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-26\">26<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-27\">27<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-28\">28<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-29\">29<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-30\">30<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-31\">31<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-32\">32<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-33\">33<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-34\">34<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-35\">35<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-36\">36<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-37\">37<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-38\">38<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-39\">39<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-40\">40<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-41\">41<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-42\">42<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-43\">43<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-44\">44<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-45\">45<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-46\">46<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-47\">47<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-48\">48<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-49\">49<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-50\">50<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-51\">51<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-52\">52<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-53\">53<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-54\">54<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-55\">55<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-56\">56<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-57\">57<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5587a97ae94e3025424913-58\">58<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-5587a97ae94e3025424913-59\">59<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5587a97ae94e3025424913-0\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-1\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-2\" class=\"crayon-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Data<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-3\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Data<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">SqlClient<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-4\" class=\"crayon-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Configuration<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-5\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Collections<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-6\" class=\"crayon-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Web<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-7\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Web<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Security<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-8\" class=\"crayon-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Web<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">UI<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-9\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Web<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">UI<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">WebControls<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-10\" class=\"crayon-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Web<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">UI<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">WebControls<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">WebParts<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-11\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Web<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">UI<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">HtmlControls<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-12\" class=\"crayon-line\"><span class=\"crayon-st\">using<\/span> <span class=\"crayon-v\">Ajax<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-13\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-14\" class=\"crayon-line\"><span class=\"crayon-m\">public<\/span> <span class=\"crayon-e\">partial <\/span><span class=\"crayon-t\">class<\/span> <span class=\"crayon-v\">Ajax_CSharp<\/span> <span class=\"crayon-o\">:<\/span> <span class=\"crayon-v\">System<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Web<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">UI<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-i\">Page<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-15\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-16\" class=\"crayon-line\"><span class=\"crayon-m\">protected<\/span> <span class=\"crayon-t\">void<\/span> <span class=\"crayon-e\">Page_Load<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-t\">object<\/span> <span class=\"crayon-v\">sender<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-i\">EventArgs<\/span> <span class=\"crayon-v\">e<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-17\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-18\" class=\"crayon-line\"><span class=\"crayon-v\">Ajax<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Utility<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">RegisterTypeForAjax<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-r\">typeof<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">Ajax_CSharp<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-19\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-20\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-21\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">Ajax<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">AjaxMethod<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">HttpSessionStateRequirement<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">ReadWrite<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-22\" class=\"crayon-line\"><span class=\"crayon-m\">public<\/span> <span class=\"crayon-t\">string<\/span> <span class=\"crayon-e\">GetData<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-23\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-24\" class=\"crayon-line\"><span class=\"crayon-st\">try<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-25\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-26\" class=\"crayon-line\"><span class=\"crayon-e\">SqlConnection <\/span><span class=\"crayon-v\">con<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">SqlConnection<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">ConfigurationManager<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">AppSettings<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8220;conn&#8221;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-27\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">SqlCommand <\/span><span class=\"crayon-v\">cmd<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">SqlCommand<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;SELECT * FROM employee&#8221;<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">con<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-28\" class=\"crayon-line\"><span class=\"crayon-v\">cmd<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Connection<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">Open<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-29\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-30\" class=\"crayon-line\"><span class=\"crayon-e\">SqlDataAdapter <\/span><span class=\"crayon-v\">adapter<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">SqlDataAdapter<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">cmd<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-31\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">DataSet <\/span><span class=\"crayon-v\">ds<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-r\">new<\/span> <span class=\"crayon-e\">DataSet<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8220;DataSet&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-32\" class=\"crayon-line\"><span class=\"crayon-v\">adapter<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">Fill<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-s\">&#8220;Table&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-33\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-34\" class=\"crayon-line\"><span class=\"crayon-st\">if<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Tables<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Rows<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Count<\/span> <span class=\"crayon-o\">&lt;=<\/span> <span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-35\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-36\" class=\"crayon-line\"><span class=\"crayon-st\">return<\/span> <span class=\"crayon-s\">&#8220;Empty&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-37\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-38\" class=\"crayon-line\"><span class=\"crayon-st\">else<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-39\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-40\" class=\"crayon-line\"><span class=\"crayon-t\">string<\/span> <span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-s\">&#8220;&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-41\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-t\">string<\/span> <span class=\"crayon-v\">empName<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-s\">&#8220;&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-42\" class=\"crayon-line\"><span class=\"crayon-st\">for<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-t\">int<\/span> <span class=\"crayon-v\">i<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span> <span class=\"crayon-v\">i<\/span> <span class=\"crayon-o\">&lt;=<\/span> <span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Tables<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Rows<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Count<\/span> <span class=\"crayon-o\">&#8211;<\/span> <span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">;<\/span> <span class=\"crayon-v\">i<\/span><span class=\"crayon-o\">++<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-43\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-44\" class=\"crayon-line\"><span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">+=<\/span> <span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Tables<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Rows<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">i<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">ToString<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-s\">&#8220;,&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-45\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">empName<\/span> <span class=\"crayon-o\">+=<\/span> <span class=\"crayon-v\">ds<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Tables<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Rows<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">i<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">ToString<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">)<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-s\">&#8220;,&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-46\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-47\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-v\">empID<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">Substring<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">empID<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Length<\/span> <span class=\"crayon-o\">&#8211;<\/span> <span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-48\" class=\"crayon-line\"><span class=\"crayon-v\">empName<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">Substring<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">Length<\/span> <span class=\"crayon-o\">&#8211;<\/span> <span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-49\" class=\"crayon-line crayon-striped-line\"><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-50\" class=\"crayon-line\"><span class=\"crayon-st\">return<\/span> <span class=\"crayon-v\">empID<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-s\">&#8220;~&#8221;<\/span> <span class=\"crayon-o\">+<\/span> <span class=\"crayon-v\">empName<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-51\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-52\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-53\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">catch<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-54\" class=\"crayon-line\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-55\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-st\">return<\/span> <span class=\"crayon-s\">&#8220;Error&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-56\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-57\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-58\" class=\"crayon-line\"><span class=\"crayon-sy\">}<\/span><\/div>\n<div id=\"crayon-5587a97ae94e3025424913-59\" class=\"crayon-line crayon-striped-line\"><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><a class=\"download-button\" href=\"http:\/\/aspnettutorials.com\/downloads\/ajax\/AjaxDataSearchCSharp2005.zip\">Download Source Files<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>AJAX, short for Asynchronous JavaScript And XML, isn\u2019t a technology but rather a grouping of technologies. AJAX uses a communication technology (typically SOAP and XML) to send and receive an asynchronous request\/response to the server, and then leverages presentation technologies (JavaScript, DOM, HTML, and CSS) to process the response. Applications using AJAX are legitimate today, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4364,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[8,32],"tags":[51],"_links":{"self":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/4363"}],"collection":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/comments?post=4363"}],"version-history":[{"count":0,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/4363\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media\/4364"}],"wp:attachment":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media?parent=4363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/categories?post=4363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/tags?post=4363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}