Split the string using the XML data type in the SQL server

Introduction In this article we going to discuss about how to split the string and convert in to the XML format and from that insert in to on temp table Create one sample input variable DECLARE @sampleText varchar(500)='lokesh1,lokesh2,lokesh3,lokesh4,lokesh5,lokesh6,lokesh7,lokesh8,lokesh9,lokesh10' And create one sample variable with XML data type like   In this XML data type I assumed <lok></lok> as  the tag notation Declare @XML XML set @XML=CAST('<lok>'+REPLACE(@sampleText,',','</lok><lok>')+'</lok>'...

Read More »

Binding the Asp.Net grid view using the JQUERY with ajax call to the Web Method

 Introduction          In this article we are going to know how to bind the server side DataSet data to the grid view          First create a sample dynamic dataset          From that convert that data set data to the XML format in the static web method         Then write the client side code to call that method using the ajax json call in the JQUERY      ...

Read More »

Using the timer “SetInterval” for asp.net c# by javascript

Introduction In this article we are going to discuss about how to set the time interval for the method using the jquery for continues calling with the time interval For down load the jquery file from this location https://simplemodal.googlecode.com/files/jquery.simplemodal-1.4.1.js <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TimeIntervelJavasctipt.aspx.cs"     Inherits="SampleTestingCodes.TimeIntervelJavasctipt" ClientIDMode="Static" %...

Read More »

Download the file from the server side using asp.net

Introduction In this article we are going to learn the topic of how to download the files from the asp.net application. In Real time example of user need to download the images . rar files ,log text files etc., Coding Write the below method for downloading the files...

Read More »