Kandy Steps

Remove First and last comma from string in SQl   declare @Str nvarchar ( max )= ',kandy,'   if (right( rtrim ( @Str ), 1 ) = ',' ) begin          set @Str = substring ( rtrim ( @Str ), 1 , len ( rtrim ( @Str ))- 1 )   end if (left( ltrim ( @Str ), 1 ) = ',' ) begin        set @Str = Substring ( @Str , 2 , ( len ( @Str ))) end select @Str

Replace Enter key from string  in Sql declare @C nvarchar ( max ) set @C = 'kandy deol' select @C as WithEnterKey select REPLACE ( REPLACE ( @C , CHAR ( 13 ), '' ), CHAR ( 10 ), '' ) as WithOutEnterKey

Create and save QR code in asp.net with C# Download Dll from given link https://drive.google.com/drive/folders/0B2VobjpburSGdFBaZzBZSEJic0E?usp=sharing .Aspx Page < form id ="form1" runat ="server">         < asp : TextBox ID ="txtInput" runat ="server"></ asp : TextBox >         < asp : Button ID ="btnGenerate" runat ="server" Text ="Generate" OnClick ="btnGenerate_Click" />         < hr />         < asp : PlaceHolder ID ="plQRCode" runat ="server" />     </ form > .Cs Page using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using QRCoder; using System.IO; using System.Drawing; public partial class CS : System.Web.UI. Page { ...

Create and Save Bar Code in asp.net with C# Please download " IDAutomationHC39M " font online. .Aspx Page : < form id ="form1" runat ="server">         < asp : TextBox ID =" txtInput " runat ="server"></ asp : TextBox >         < asp : Button ID ="btnGenerate" runat ="server" Text ="Generate" OnClick ="btnGenerate_Click" />         < hr />         < asp : PlaceHolder ID ="plBarCode" runat ="server" />     </ form > .Cs Page : using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Drawing; using System.Drawing.Imaging; using System.IO; using OnBarcode.Barcode; //using Zen.Barcode; public partial class BarCode : Sy...

Auto Complete  Textbox with ItemId in asp.net C# Download References Js and .css form this link:- https://drive.google.com/folderview?id=0B2VobjpburSGMmxJVXZUNlF5OWM&usp=sharing .Aspx Page < html xmlns ="http://www.w3.org/1999/xhtml"> < head runat ="server">     < title ></ title >     <% --<script type="text/javascript" src="js/jquery.1.11.1.js"></script>-- %>     < script src ="Auto/jquery-1.10.0.min.js"></ script >     < link href ="Auto/jquery-ui.css" rel ="stylesheet" />     < script src ="Auto/jquery-ui.min.js"></ script >     < script >         var TotalCount = 1;         $( function () {             $( "[id$=txtSearch]" ).autocomplete...