Posts

Generate the formatted URL from title like blog, article etc in SQL Server

Image
======Create Function CREATE FUNCTION [dbo].[GenerateMapKey] (@keyText NVARCHAR(4000)) RETURNS NVARCHAR(4000) AS BEGIN DECLARE @mapKey VARCHAR(4000) SELECT @mapKey = LOWER(@keyText) SELECT @mapKey = REPLACE(@mapKey,' ','-') SELECT @mapKey = REPLACE(@mapKey, CHAR(39),'-') SELECT @mapKey = REPLACE(@mapKey,'’','-') SELECT @mapKey = REPLACE(@mapKey,'‘','-') SELECT @mapKey = REPLACE(@mapKey,'!','-') SELECT @mapKey = REPLACE(@mapKey,'#','-') SELECT @mapKey = REPLACE(@mapKey,'$','-') SELECT @mapKey = REPLACE(@mapKey,'%','-') SELECT @mapKey = REPLACE(@mapKey,'^','-') SELECT @mapKey = REPLACE(@mapKey,'&','-') SELECT @mapKey = REPLACE(@mapKey,'*','-') SELECT @mapKey = REPLACE(@mapKey,'(','-') SELECT @mapKey = REPLACE(@mapKey,')','-') SELECT ...

Remove Duplicate Chars From String in SQL Server

Image
==========Create Procedure CREATE PROCEDURE REMOVE_DUPLICATE(@string VARCHAR (100)) AS DECLARE @result VARCHAR (100) SET @result= '' SELECT @result=@result+ min ( substring (@string ,number,1)) FROM (      SELECT number      FROM master..spt_values      WHERE type= 'p' AND number BETWEEN 1 AND len(@string ) ) as t GROUP BY substring (@string,number,1) ORDER BY min (number) SELECT @result  ============ EXEC REMOVE_DUPLICATE 'aaabbbbbcc111111111111112' ===========Output

Generate Random Number in SQL Server between two numbers

Image
  Create the variables for the random number generation DECLARE @Random INT ; DECLARE @ Upper INT ; DECLARE @ Lower INT   ---- This will create a random number between 1 and 999 SET @ Lower = 1 ---- The lowest random number SET @ Upper = 999 ---- The highest random number SELECT @Random = ROUND(((@ Upper - @ Lower -1) * RAND() + @ Lower ), 0) SELECT @Random ======Output

How to access master page variable/property from the content page using C#

======== MASTER PAGE CODE BEHIND public string MasterPageVariable { get ; set ; } ========ASPX PAGE Source <% @ MasterType VirtualPath ="Maste Page Path" %> ========ASPX PAGE Code Behind protected void Page_Load( object sender, EventArgs e) { Master.MasterPageVariable = "This text is written from Content page." ; }

How to enable/disable dropdownlist through a checkbox selection using Jquery

============Head Tag Of Page================== < script src ="Scripts/jquery-1.4.1.js" type ="text/javascript" ></ script > <script type= "text/javascript" > $(document).ready( function () { $( "#chkbox" ).click( function () { if ( this . checked ) $( '#ddlcountry' ).attr( 'disabled' , 'disabled' ); else $( '#ddlcountry ' ).removeAttr( 'disabled' ); }); }); </ script > ==================Body Tage of Page================= < asp:CheckBox ID ="chkbox " runat ="server" Text ="Enable/Disable" /> < asp:DropDownList ID ="ddlcountry " runat ="server" > < asp:ListItem Text ="Select" Value ="India"/ > < asp:ListItem Text ="Opt...

Enable the file upload in ck-editor using C#

==========Add the following script in head tag================  <script type="text/javascript" language="javascript">     $(function () {         CKEDITOR.replace('<%=CKEditorControl1.ClientID %>', { filebrowserImageUploadUrl: 'Upload.ashx' });     });   </script> =========Create ASHX handler page for uploading================= <%@ WebHandler Language="C#" Class="Upload" %> using System; using System.Web; public class Upload : IHttpHandler {          public void ProcessRequest (HttpContext context) {         databaseprocess db = new databaseprocess();                 string appLink = "Web Site URL";         HttpPostedFile uploads = context.Request.Files["upload"];         string CKEditorFuncNum = context.Request["CKEditorFuncNum"];         string ...

Lightbox is a simple script used to overlay images Using Jquery

Image
Download the Running Example From Following URL http://lokeshdhakar.com/projects/lightbox2/