Wednesday, 18 February 2015

Selecting multiple rows as single row in sql server

SELECT STUFF((SELECT DISTINCT ','+CONVERT(VARCHAR(10), MO_CC_ID) from NEWMAKE_OFFER WHERE MO_FU_ID=546 for XML path('')),1,1,'')

Friday, 12 September 2014

Getting Query string value in aspx page

 <%# string.Format("{0}", Request.QueryString["value"])%>

Disable right click option using jquery

$(function(){
        $(this).bind("contextmenu", function(e){
        e.preventDefault();
          alert("right click is disabled"); //not recommended to give alert message
    });

});

Thursday, 5 June 2014

Very use ful for image map coordinates

for example, you can get full view of each mandal details using the coordinates

http://www.mapsofindia.com/maps/andhrapradesh/districts/prakasam-district-map.jpg

http://www.maschek.hu/imagemap/imgmap

Sunday, 6 April 2014

call function or do something after ' x ' times in jquery


    //--- call function after 10 seconds.
    setTimeout("here specify what you want to do", 10000);

Wednesday, 2 April 2014

Reading session value from jquery using WebHandler

using System;
using System.Web;
using System.Web.SessionState;
using System.Web.Script.Serialization;

public class ReadSession : IHttpHandler,IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "application/json";
        context.Response.Write(new JavaScriptSerializer().Serialize(new
        {
            Key = context.Request["key"],
            Value = (context.Session[context.Request["key"]]!=null && context.Session[context.Request["key"]]!="" ? context.Session[context.Request["key"]]:"")
        }));
    }

    public bool IsReusable
    {
        get { return true; }
    }
}


/*-------( In jquery just call like this )--------*/


 $.getJSON('/ReadSession.ashx', { key: key }, function (result) {
        alert(result.Value);
    });

Extracting Nupkg files using command line

Rename it to zip first then extract files as below 1.     Rename-Item -Path A_Package.nupkg -NewName A_Package.zip 2.     Make sure to repla...