How to access Session in javascript


In this article we learn about how we can access ASP.NET server side session variable or data in client side JavaScript.
I have requirement for current user session variable in client side to perform some action based on user and its role.

Here are method or way to interact session variable in client side or in JavaScript.

1. Directly access session variable with mix code( Server side)
as per the below code.
     //First way to access session 
     console.log("UserId:" + '<%=Session["UserId"] %>');
     console.log("UserRole:" + '<%=Session["UserRole"] %>');
2. Fetch session value from HiddenField
To fetch session value from hidden field first we have to set session data in server side and then we can access stored hidden value data in client side javascript.
//Set session value to hidden field for access this value in jquery 
     protected void setSessionToHiddenValue()
         Session.Add("UserId", "Arvind");
         Session.Add("UserRole", "Admin");
         hdnUserId.Value = Convert.ToString(Session["UserId"]);
         hdnUserRole.Value = Convert.ToString(Session["UserRole"]);
     //We can access hidden session data as below 
     console.log("UserId:" + '<%= hdnUserId.Value %>');
     console.log("UserRole:" + '<%= hdnUserRole.Value %>');


In this article we have learn about accessing server side session variable in client side for take action based on current session. 

Asp.Net Utility Functions


This article contains most useful utility function for Asp.Net WebForm as well as Asp.Net MVC project. All this method is collected from Internet sources like stackoverflow so it will be useful to many developer to find all useful method at one place.

See listed below most useful functions

1. Replace all special character in input string with '-' character

This method replace special characters using Regex function
  public static string ReplaceSpecialChar(string input)
        Regex rgx = new Regex("[^a-zA-Z0-9]");
        input = rgx.Replace(input, "-");
        return input;

2. Remove all special characters from string

This method remove all special characters and prepare new string which contains alpha numeric character along with underscore and space.
     public static string RemoveSpecialCharacters(string str)
      StringBuilder sb = new StringBuilder(); 
      for (int i = 0; i < str.Length; i++)
          if ((str[i] >= '0' && str[i]<='9')||(str[i]>='A'&&str[i]<='z'
|| (str[i] == '_' || str[i] == ' ')))
      return sb.ToString();

3. Convert Unix long timestamp to C# DateTime object

Most of system contains unix timestamp for storing date value,which is most REST API response datet as unix timestamp. So,Below method is very useful to convert timestamp to DateTime object.
public static DateTime ConvertUNIXTimeStampTODateTime(long date)
        DateTime dtDateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0,System.DateTimeKind.Utc);
        dtDateTime = dtDateTime.AddSeconds(date).ToLocalTime();
        return dtDateTime;

4. Get short description from long length string value

In real world project many times this situation arise that we need to display on first 50 or 100 charcter from long string. This method trim long string value with ellipse format to display some short description.

public static string GetShortDescription(string Description)
            string strDesc = string.Empty;
                if (Convert.ToString(Description) != string.Empty)
                    if (Description.Trim().Length > 100)
                        strDesc = Description.Trim().Substring(0, 100) + "...";
                        strDesc = Description.Trim();
            catch (Exception)
            return strDesc;

5. Convert C# DateTime to Unix long timestamp

As we require converting unix timestamp to C# DateTime,we also required to convert C# DateTime to Unix timestamp.
     public static long ConvertToUnixTimestamp(this DateTime target)
            var date = new DateTime(1970, 1, 1, 0, 0, 0, target.Kind);
            var unixTimestamp = System.Convert.ToInt64((target - date).TotalSeconds);
            return unixTimestamp;



Fill free to contribute your own some useful functions in github repository which I have publish at Asp.Net-Utility-Functions


In this article we have seen most useful common utility function for Asp.Net, I will also updating this article in coming days, so we can get all common utility functions at one place.

Exception LINQ to Entities does not recognize the method ToString


This is most common exception occurs while we working with entity framework and converting data inside IQueryable result for filtering.


Mainly full exception message as “LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.”
var result=dc.Tests.Where(i=>i.status==status.ToString()).FirstOrDefault();
This exception mainly occurs, when we query SQL database using entity framework. The problem is that you are calling ToString in a LINQ to Entities query (IQueryable to IEnumrable). That means the parser is trying to convert the ToString call into its equivalent SQL (which isn't possible...hence the exception).
To solve this problem there is different solution.
Solution 1:  All you have to do is move the ToString call to a separate line.
String userStatus=status.ToString();
var result=dc.Tests.Where(i=>i.status== userStatus).FirstOrDefault();

Solution 2: Convert IQueryable result to IEnumrable before convert.

var result=dc.Tests.AsEnumerable().Where(i=>i.status==status.ToString())
Note: This is only feasible for small entity collection as the above method first fetch all database result to in memory using AsEnumerable() method and then filtering result. Not feasible for large Db result.
Solution 3:  Use entity framework extension method SqlFunctions Class or DbFunctions Class
var result=dc.Tests.Where(i=>i.status==status.ToString()).FirstOrDefault();

Here SqlFunctions.StringConvert method converts Linq entities query to SQL query.
Note: Good when the solution with temporary variables is not desirable for whatever reasons.


In this article we learn different way to solve most common exception while working with Entity Framework.

Getting started with data visualization using D3js


As per D3 allows you to bind arbitrary data to a Document Object Model (DOM), and then apply data-driven transformations to the document. For example, you can use D3 to generate an HTML table from an array of numbers. Or, use the same data to create an interactive SVG bar chart with smooth transitions and interaction.


Here we learn basic usage of D3js and then moved to different type of visualization chart.

1. How Selections works

Modifying documents using the W3C DOM API is tedious
For example, to change the text color of paragraph elements:
var paragraphs = document.getElementsByTagName("p");
for (var i = 0; i < paragraphs.length; i++) {
  var paragraph = paragraphs.item(i);"color", "white", null);
D3 uses new W3C Selectors API and supported natively by modern browsers. Elements may be selected using a variety of predicates, including containment, attribute values, class and ID. You can rewrite above code as below in single line:
d3.selectAll("p").style("color", "white");
D3 provides numerous methods for mutating nodes: setting attributes or styles; registering event listeners; adding, removing or sorting nodes; and changing HTML or text content.These operators can get or set attributes, styles, properties, HTML and text content.

I have implemented demo for selector example  in jsfiddle
Here is different way to use selector and append new element

 Select first element which match to selector and selector varies to tag,class,id etc.If no elements in the current document match the specified selector, returns the empty selection.This function traverse the DOM top to bottom order. 
Select specified node.This is useful if you already have a reference to a node, such as within an event listener.This function does not traverse the DOM.
 - d3.selectAll(selector):
Select all elements which match to selector.If no elements in the current document match the specified selector, returns the empty selection.This function traverse the DOM top to bottom order.  
  - d3.selectAll(node):
Select specified elements of array.This is useful if you already have a reference to a node, such as d3.selectAll(this.childNodes) within an event listener.This function does not traverse the DOM.

Selection also works with chaining method, this applied multiple operations to same elements. Let's see example
 e.g. Here first we have select all p tag and then set text color and background color. 

For more information you can refer this

2. Dynamic Properties

D3 provides many built-in reusable functions and function factories, such as graphical primitives for area, line and pie charts.
For example, to randomly color paragraphs:
d3.selectAll("p").style("color", function() {
  return "hsl(" + Math.random() * 360 + ",100%,50%)";
To alternate shades of gray for even and odd nodes: 
d3.selectAll("p").style("color", function(d, i) {
  return i % 2 ? "#fff" : "#eee";
Computed properties often refer to bound data. Data is specified as an array of values, and each value is passed as the first argument (d) to selection functions.
With the default join-by-index, the first element in the data array is passed to the first node in the selection, the second element to the second node, and so on.
For example, if you bind an array of numbers to paragraph elements, you can use these numbers to compute dynamic font sizes:
    .data([4, 8, 15, 16, 23, 42])
    .style("font-size", function(d) { return d + "px"; });
 You can test this code in jsfiddle by changing selector

3.Enter, Update and Exit

Using D3’s enter and exit selections, you can create new nodes for incoming data and remove outgoing nodes that are no longer needed.

When data is bound to a selection, each element in the data array is paired with the corresponding node in the selection. If there are fewer nodes than data, the extra data elements form the enter selection, which you can instantiate by appending to the enter selection.
For example:"body").selectAll("p")
    .data([4, 8, 15, 16, 23, 42])
    .text(function(d) { return "I’m number " + d + "!"; });

Updating nodes are the default selection—the result of the data operator. Thus, if you forget about the enter and exit selections, you will automatically select only the elements for which there exists corresponding data.

A common pattern is to break the initial selection into three parts: the updating nodes to modify, the entering nodes to add, and the exiting nodes to remove.
// Update…
var p ="body").selectAll("p")
    .data([4, 8, 15, 16, 23, 42])
    .text(function(d) { return d; });
// Enter…
    .text(function(d) { return d; });
// Exit…
By handling these three cases separately, you specify precisely which operations run on which nodes. This improves performance and offers greater control over transitions.

For example, with a bar chart you might initialize entering bars using the old scale, and then transition entering bars to the new scale along with the updating and exiting bars.
D3 lets you transform documents based on data; this includes both creating and destroying elements. D3 allows you to change an existing document in response to user interaction, animation over time, or even asynchronous notification from a third-party.
A hybrid approach is even possible, where the document is initially rendered on the server, and updated on the client via D3.

You can learn more from this article.

4.Transformation, not Representation

D3 does not introduce a new visual representation. Unlike Processing, RaphaĆ«l, or Protovis, D3’s vocabulary of graphical marks comes directly from web standards: HTML, SVG, and CSS. For example, you can create SVG elements using D3 and style them with external stylesheets.
You can use composite filter effects, dashed strokes and clipping. If browser vendors introduce new features tomorrow, you’ll be able to use them immediately—no toolkit update required.
And, if you decide in the future to use a toolkit other than D3, you can take your knowledge of standards with you!
Best of all, D3 is easy to debug using the browser’s built-in element inspector: the nodes that you manipulate with D3 are exactly those that the browser understands natively.

5. Transitions

D3’s focus on transformation extends naturally to animated transitions. Transitions gradually interpolate styles and attributes over time. Tweening can be controlled via easing functions such as “elastic”, “cubic-in-out” and “linear”.
 D3’s interpolators support both primitives, such as numbers and numbers embedded within strings (font sizes, path data, etc.), and compound values. You can even extend D3’s interpolator registry to support complex properties and data structures.
For example, to fade the background of the page to black:"body").transition()
    .style("background-color", "black");
Or, to resize circles in a symbol map with a staggered delay:
    .delay(function(d, i) { return i * 10; })
    .attr("r", function(d) { return Math.sqrt(d * scale); });
By modifying only the attributes that actually change, D3 reduces overhead and allows greater graphical complexity at high frame rates. D3 also allows sequencing of complex transitions via events. And, you can still use CSS3 transitions; D3 does not replace the browser’s toolbox, but exposes it in a way that is easier to use. 

Reference link:


In this article we have learned basic concepts of D3 charting and feature. In next series of article we learn real chart example with customization.

Selected as Article Of The Day in MSFT

 Selected As Article Of The Day in Microsoft ASP.NET Community

My Article on JUICE UI library got selected as Article Of The Day for 07-Feb-2016 on Asp.Net Forum.

 Article Of  The Day

Thank you Asp.Net community for recognizing my article as Article Of The Day. 

Dynamic Query in LINQ using Predicate Builder

Introduction This tutorial explains how to create a dynamic query using LINQ, Using Predicate Builder  LINQ to SQL dynamic query an...

Learn More