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>' as XML)

And create one temp table like

DECLARE @temp AS TABLE 

( 

      rownum INT IDENTITY(1, 1), 

      name   VARCHAR(50) 

)

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

        Add the JQUERY script plug in’s shown below

        In Asp.net project create one .js file name it as “ASPSnippets_Pager.min.js “

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 »