Split and convert Comma Separated String or any Delimited String to Table in SQL Server

Hi friends,in this article I will explain about How to Split and convert Comma Separated String or any Delimited String to Table in SQL Server

In this article I will explain with examples, how to split and convert a comma separated / delimited string to a table using Split function in SQL Server 2005, 2008 and 2012 versions. The string containing words or letters or numbers separated (delimited) by comma or underscore or  plus(+) ,etc,. will be split into Table values.

I will also explain how to use the Split function to split a string in a SQL Query or Stored Procedures in SQL Server 2005, 2008 and 2012 versions.

Bind Dropdownlist using JQuery AJAX in ASP.NET OR Calling ASP.NET WebMethod using jQuery AJAX C#/VB.NET

Hi friends,in this article I will explain about how to Bind Dropdownlist using JQuery AJAX in ASP.NET OR Calling ASP.NET WebMethod using jQuery AJAX C#/VB.NET
I already explained in the previous articles about Ajax AsyncFileUpload control example in asp.net to upload files to server using C#/VB.NET, How to Build Modal Popup using ASP.Net AJAX ModalPopupExtender Control in ASP.NET and How to use Ajax FilteredTextBoxExtender for validating in ASP.NET

Ajax ColorPickerExtender example in ASP.NET or how to use ColorPicker extender in ASP.NET

HI Friends,in this article I will explain about Ajax ColorPickerExtender example in ASP.NET or how to use ColorPicker extender in ASP.NET

First you will have to download the latest binary of the AJAX Control Toolkit from CodePlex site. To download click here.

Once that is done you will need to Add Reference of the Ajax Control Toolkit DLL as shown in figure below figure

How to disable/Prevent/Don’t allow the User from Entering HTML tags in Textbox/TextArea

Hi Friends,in this article I will explain about How to disable/Prevent/Don’t allow the User from Entering HTML tags in Textbox/TextArea.

When you enter html tags as shown below figure and click on submit button 

Custom paging for GridView using DataList in ASP.NET using C#/VB.NET to increase SQL perfomance

Hi friends,in this article I will explain about How to do Custom paging for GridView using DataList in ASP.NET using C#/VB.NET to increase SQL perfomance

When there are bulk records to show in the GridView, developers often use paging to distribute the complete records with multiple pages to show the records in the GridView. This means that, when you change the page index, the GridView is bound everytime  from the database to show the next records.

How to Send (Pass) Data (Values) from one page to another using jQuery with QueryString

Hi friends,in this article I will explain about How to Send (Pass) Data (Values) from one page to another using jQuery with QueryString

The page PassDataJQueryQueryString.aspx (Source Page), this is the page from where we want to pass (send) data. This page consists of an TextBox for Name ,TextBox for Qualification and DropDownList for Technology whose values we need to pass (send) to the other page(DestinationPage.aspx).