Articles by Pranay Rana (Articles: 38, Technical Blogs: 27, Tip/Tricks: 34)

Articles: 38, Technical Blogs: 27, Tip/Tricks: 34

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.48

Ajax
General	Jquery Ajax Calling Functions Posted: 4 Feb 2015 Updated: 4 Feb 2015 Views: 292,608 Rating: 4.86/5 Votes: 42 Popularity: 7.84 Licence: The Code Project Open License (CPOL) Bookmarked: 78 Downloaded: 4,319 Please Sign up or sign in to vote. Jquery Ajax Calling functions
ASP.NET
General	LINQ TO SQL GridView (Enhanced Gridview) Posted: 11 Jul 2010 Updated: 4 Aug 2010 Views: 147,640 Rating: 4.88/5 Votes: 51 Popularity: 8.25 Licence: The Code Project Open License (CPOL) Bookmarked: 115 Downloaded: 2,357 Please Sign up or sign in to vote. LINQ TO SQL Enhanced Gridview
	Programming Practice for Server Side State Maintenance Variable Posted: 11 Jan 2011 Updated: 11 Jan 2011 Views: 33,603 Rating: 3.15/5 Votes: 12 Popularity: 3.40 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Programming practice for server side state maintenance variable
	Calling Cross Domain WCF service using Jquery/JavaScript Posted: 10 Jul 2011 Updated: 18 Jul 2011 Views: 155,565 Rating: 4.74/5 Votes: 21 Popularity: 6.17 Licence: The Code Project Open License (CPOL) Bookmarked: 51 Downloaded: 6,253 Please Sign up or sign in to vote. Calling Cross Domain WCF service using Jquery/JavaScript
Howto	Calling WCF Services using jQuery Posted: 1 Dec 2010 Updated: 2 Dec 2010 Views: 458,613 Rating: 4.76/5 Votes: 85 Popularity: 9.06 Licence: The Code Project Open License (CPOL) Bookmarked: 142 Downloaded: 17,058 Please Sign up or sign in to vote. A guide on how to call Windows Communication Foundation services using jQuery
	Exposing Custom event from custom control Posted: 8 Jul 2012 Updated: 8 Jul 2012 Views: 28,350 Rating: 4.80/5 Votes: 4 Popularity: 2.89 Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. Exposing Custom event from custom control
Utilities	Generic Code of Validating Fields with Jquery Posted: 15 Nov 2009 Updated: 15 Nov 2009 Views: 33,840 Rating: 4.09/5 Votes: 8 Popularity: 3.69 Licence: The Code Project Open License (CPOL) Bookmarked: 19 Downloaded: 396 Please Sign up or sign in to vote. Generic code of validating fields with Jquery
	Cascading with jQuery AutoComplete Posted: 3 Apr 2012 Updated: 5 Apr 2012 Views: 59,561 Rating: 4.61/5 Votes: 12 Popularity: 4.97 Licence: The Code Project Open License (CPOL) Bookmarked: 26 Downloaded: 2,631 Please Sign up or sign in to vote. cascading functionality with the help of jQuery AutoComplete
	Calling Server Side function from Client Side Script Posted: 8 Jun 2012 Updated: 8 Jun 2012 Views: 61,260 Rating: 5.00/5 Votes: 6 Popularity: 3.89 Licence: The Code Project Open License (CPOL) Bookmarked: 22 Downloaded: 0 Please Sign up or sign in to vote. Calling Server Side function from Client Side Script
ASP.NET Controls
General	Month and Year Picker UserControl Posted: 4 Dec 2011 Updated: 4 Dec 2011 Views: 49,592 Rating: 4.80/5 Votes: 18 Popularity: 5.78 Licence: The Code Project Open License (CPOL) Bookmarked: 25 Downloaded: 997 Please Sign up or sign in to vote. Month and Year Picker UserControl
Client side scripting
General	Angular Custom Validation Component Posted: 13 Apr 2018 Updated: 1 May 2018 Views: 14,845 Rating: 5.00/5 Votes: 6 Popularity: 3.89 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. This post is about validation in Angular 2 application, which means it's about validation on client side, not about server side.
	Angular Application Structure Posted: 18 Jun 2018 Updated: 5 Jul 2018 Views: 5,052 Rating: 2.59/5 Votes: 4 Popularity: 1.56 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Setting up application structure
Custom Controls
General	ASP.NET Extended Grid Control Posted: 13 Jan 2010 Updated: 30 Jan 2010 Views: 33,981 Rating: 3.60/5 Votes: 8 Popularity: 3.25 Licence: The Code Project Open License (CPOL) Bookmarked: 20 Downloaded: 917 Please Sign up or sign in to vote. EnhanceGrid: with custom paging, page size, and search functionality.
HTML / CSS
CSS	DIV TABLE Posted: 17 Dec 2009 Updated: 17 Dec 2009 Views: 247,966 Rating: 4.54/5 Votes: 34 Popularity: 6.77 Licence: The Code Project Open License (CPOL) Bookmarked: 73 Downloaded: 4,053 Please Sign up or sign in to vote. This article demonstrates using div elements to effectively build websites without using table elements on a page.
General	CSS3 Selector Posted: 30 Dec 2013 Updated: 5 Jan 2014 Views: 31,070 Rating: 4.75/5 Votes: 27 Popularity: 6.79 Licence: The Code Project Open License (CPOL) Bookmarked: 43 Downloaded: 0 Please Sign up or sign in to vote. CSS3 Selector
Silverlight
General	Align Text in Autogenerated Column of Rad Silverlight Girdview and Silverlight Gridview Posted: 18 Jul 2012 Updated: 18 Jul 2012 Views: 21,370 Rating: 4.80/5 Votes: 2 Popularity: 1.44 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 301 Please Sign up or sign in to vote. Align Text in Autogenerated Column of Rad Silverlight Girdview and Silverlight Gridview
	Silverlight Application with Dispatcher and asynchronous WCF service Posted: 26 Dec 2012 Updated: 8 Jan 2013 Views: 31,091 Rating: 4.85/5 Votes: 6 Popularity: 3.77 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 738 Please Sign up or sign in to vote. Silverlight Application with Dispatcher and asynchronous WCF Service
Validation
Validation Controls	Enhanced Textbox Control Posted: 26 Mar 2010 Updated: 3 Apr 2010 Views: 103,752 Rating: 4.88/5 Votes: 52 Popularity: 8.21 Licence: The Code Project Open License (CPOL) Bookmarked: 117 Downloaded: 2,539 Please Sign up or sign in to vote. An extended control which doesn't require attaching a validation control, but just needs specifying the input type.
Web Services
Beginners	Create, Host (Self Hosting, IIS hosting) and Consume WCF Service Posted: 24 Jan 2011 Updated: 3 Feb 2011 Views: 188,114 Rating: 4.72/5 Votes: 31 Popularity: 6.76 Licence: The Code Project Open License (CPOL) Bookmarked: 93 Downloaded: 5,742 Please Sign up or sign in to vote. Create, Host (Self Hosting, IIS hosting) and Consume WCF Service
Database
General	Manage SQL Server Database Posted: 23 Jan 2011 Updated: 23 Jan 2011 Views: 24,770 Rating: 4.60/5 Votes: 4 Popularity: 2.77 Licence: The Code Project Open License (CPOL) Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. Manage SQL Server Database within Visual Studio Team System
C#
General	Some Useful Features of C# Posted: 17 Feb 2011 Updated: 27 Feb 2011 Views: 183,565 Rating: 4.31/5 Votes: 84 Popularity: 8.11 Licence: The Code Project Open License (CPOL) Bookmarked: 77 Downloaded: 0 Please Sign up or sign in to vote. This article discusses some useful but unknown features of C#.
	C# State machine - Yield Posted: 17 Jun 2012 Updated: 17 Jun 2012 Views: 22,083 Rating: 1.50/5 Votes: 3 Popularity: 0.72 Licence: The Code Project Open License (CPOL) Bookmarked: 14 Downloaded: 0 Please Sign up or sign in to vote. C# State machine - Yield
	Bulk Insertion of Data Using C# DataTable and SQL server OpenXML function Posted: 6 Jul 2012 Updated: 6 Jul 2012 Views: 68,120 Rating: 4.71/5 Votes: 5 Popularity: 3.30 Licence: The Code Project Open License (CPOL) Bookmarked: 18 Downloaded: 0 Please Sign up or sign in to vote. Bulk Insertion of Data Using C# DataTable and SQL server OpenXML function
	ContinueWith Vs await Posted: 11 Aug 2015 Updated: 11 Aug 2015 Views: 59,885 Rating: 4.29/5 Votes: 8 Popularity: 3.87 Licence: The Code Project Open License (CPOL) Bookmarked: 14 Downloaded: 318 Please Sign up or sign in to vote. Below discussion about the ContinueWith function available on Task Class of TPL and await keyword introduced in C# 5.0 to support asynchronous calls.
How To	Format Number To Display Posted: 7 Jun 2012 Updated: 29 Jun 2012 Views: 119,174 Rating: 4.51/5 Votes: 29 Popularity: 6.38 Licence: The Code Project Open License (CPOL) Bookmarked: 58 Downloaded: 0 Please Sign up or sign in to vote. Format Number To Display
	Return Anonymous type Posted: 16 Oct 2012 Updated: 25 Oct 2012 Views: 45,884 Rating: 4.19/5 Votes: 20 Popularity: 5.35 Licence: The Code Project Open License (CPOL) Bookmarked: 18 Downloaded: 0 Please Sign up or sign in to vote. Return Anonymous type
	DistinctBy in Linq (Find Distinct object by Property) Posted: 27 Jan 2013 Updated: 28 Jan 2013 Views: 211,148 Rating: 4.71/5 Votes: 13 Popularity: 5.09 Licence: The Code Project Open License (CPOL) Bookmarked: 28 Downloaded: 1,461 Please Sign up or sign in to vote. DistinctBy in Linq (Find Distinct object by Property)
LINQ
General	Learn SQL to LINQ (Visual Representation) Posted: 13 Dec 2010 Updated: 27 Dec 2010 Views: 215,728 Rating: 4.88/5 Votes: 106 Popularity: 9.80 Licence: The Code Project Open License (CPOL) Bookmarked: 188 Downloaded: 0 Please Sign up or sign in to vote. A discussion of LINQ queries for matching SQL queries, with visual representations.
	Most efficient way to update with LINQ to SQL Posted: 1 Apr 2012 Updated: 1 Apr 2012 Views: 44,064 Rating: 4.25/5 Votes: 5 Popularity: 2.97 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Most efficient way to update with LINQ to SQL
Windows Communication Foundation
General	Create a REST service with WCF and consume it using jQuery Posted: 15 Apr 2011 Updated: 20 Apr 2011 Views: 79,908 Rating: 4.79/5 Votes: 23 Popularity: 6.34 Licence: The Code Project Open License (CPOL) Bookmarked: 66 Downloaded: 3,297 Please Sign up or sign in to vote. How to create a REST service with WCF and consume it using jQuery.
	Responsive WCF service With ICallbackEventHandler Interface Posted: 6 Aug 2012 Updated: 8 Feb 2013 Views: 28,963 Rating: 4.60/5 Votes: 5 Popularity: 3.22 Licence: The Code Project Open License (CPOL) Bookmarked: 33 Downloaded: 754 Please Sign up or sign in to vote. Responsive WCF service with ICallbackEventHandler Interface.
Threads, Processes & IPC
Multi-threading	Random Number in MultiThreading Posted: 18 Feb 2015 Updated: 4 Mar 2015 Views: 29,634 Rating: 4.76/5 Votes: 8 Popularity: 4.30 Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 184 Please Sign up or sign in to vote. Random number in MultiThreading
Tools and IDE
General	Help Yourself in Debugging (Part-2) using Breakpoint/Tracepoint Posted: 18 Nov 2013 Updated: 18 Nov 2013 Views: 14,511 Rating: 4.90/5 Votes: 6 Popularity: 3.81 Licence: The Code Project Open License (CPOL) Bookmarked: 18 Downloaded: 0 Please Sign up or sign in to vote. Help Yourself in Debugging (Part-2) using Breakpoint/Tracepoint
Design and Architecture
Design Patterns	How and Where Decorator Design Pattern Posted: 4 Feb 2015 Updated: 5 Feb 2015 Views: 27,451 Rating: 4.88/5 Votes: 25 Popularity: 6.83 Licence: The Code Project Open License (CPOL) Bookmarked: 38 Downloaded: 178 Please Sign up or sign in to vote. Decorator Design Pattern
	Flyweight Design Pattern Posted: 11 Aug 2015 Updated: 11 Aug 2015 Views: 15,821 Rating: 4.60/5 Votes: 4 Popularity: 2.77 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 138 Please Sign up or sign in to vote. Flyweight pattern is about creating a pool of objects which allow sharing already created objects and causing applications to consume less memory.
General	Solid Principle In Detail Posted: 14 Jul 2015 Updated: 14 Jul 2015 Views: 31,737 Rating: 4.91/5 Votes: 7 Popularity: 4.15 Licence: The Code Project Open License (CPOL) Bookmarked: 17 Downloaded: 0 Please Sign up or sign in to vote. SOLID principles are related with the design and maintenance of software system.
Patterns and Practices	Dependency Injection For Beginner - I Posted: 1 Feb 2014 Updated: 7 Feb 2014 Views: 89,543 Rating: 4.87/5 Votes: 66 Popularity: 8.86 Licence: The Code Project Open License (CPOL) Bookmarked: 139 Downloaded: 0 Please Sign up or sign in to vote. What is dependency injection and why there is need of this software design pattern.
	Publisher/Subscriber pattern with Event/Delegate and EventAggregator Posted: 18 Jan 2015 Updated: 12 Feb 2015 Views: 128,739 Rating: 4.73/5 Votes: 31 Popularity: 6.84 Licence: The Code Project Open License (CPOL) Bookmarked: 84 Downloaded: 2,610 Please Sign up or sign in to vote. Publisher/Subscriber pattern with Event/Delegate and EventAggregator

Average blogs rating: 4.11

Database
SQL	Any Method [Technical Blog] Posted: 11 Aug 2011 Updated: 11 Aug 2011 Views: 10,440 Rating: 4.00/5 Votes: 3 Popularity: 1.91 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Here I am going to discuss about Any method.
C#
General	Difference between Object, Dynamic and Var [Technical Blog] Posted: 29 Jul 2011 Updated: 31 Jul 2011 Views: 75,877 Rating: 4.52/5 Votes: 19 Popularity: 5.57 Licence: The Code Project Open License (CPOL) Bookmarked: 21 Downloaded: 0 Please Sign up or sign in to vote. A list of differences between the three types of the variables Object, Var and Dynamic.
	Default Extension Methods [Technical Blog] Posted: 26 Jul 2011 Updated: 10 Aug 2011 Views: 17,220 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Discussion about default extension method
	Lazy Initialization of Object in C# with Lazy Class [Technical Blog] Posted: 25 Jul 2011 Updated: 10 Aug 2011 Views: 37,953 Rating: 4.20/5 Votes: 4 Popularity: 2.53 Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Lazy initialization of object in C# with Lazy class
	Extend ORM Generated Class [Technical Blog] Posted: 2 Dec 2011 Updated: 2 Dec 2011 Views: 9,950 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. By using a partial class, we can add custom logic to a class created by the ORM tool(s).
	Read XML with Descendants Method (XName) [Technical Blog] Posted: 16 Nov 2012 Updated: 19 Nov 2012 Views: 34,660 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Understanding Descendants and avoiding misconception with this method
LINQ
General	IQueryable vs. IEnumerable in terms of LINQ to SQL queries [Technical Blog] Posted: 26 Jul 2011 Updated: 26 Jul 2011 Views: 76,900 Rating: 4.70/5 Votes: 22 Popularity: 6.21 Licence: The Code Project Open License (CPOL) Bookmarked: 25 Downloaded: 0 Please Sign up or sign in to vote. Difference between IQueryable and IEnumerable in terms of LINQ to SQL queries.
	Into and Let in LINQ (Let vs. Into) [Technical Blog] Posted: 26 Jul 2011 Updated: 26 Jul 2011 Views: 98,617 Rating: 3.41/5 Votes: 8 Popularity: 3.08 Licence: The Code Project Open License (CPOL) Bookmarked: 13 Downloaded: 0 Please Sign up or sign in to vote. In this post, I am going to show two keywords in C# 3.0 which are very helpful when playing with a set of object collections using LINQ.
	LINQ Joins with SelectMany [Technical Blog] Posted: 26 Jul 2011 Updated: 26 Jul 2011 Views: 34,381 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. SelectMany is a way to flatten several results into a single sequence.
	Dynamic Query with Linq [Technical Blog] Posted: 26 Jul 2011 Updated: 26 Jul 2011 Views: 73,171 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. Building dynamic query with LINQ
	Ordering Data in LINQ Queries by More Than One Column [Technical Blog] Posted: 26 Jul 2011 Updated: 9 Aug 2011 Views: 93,676 Rating: 4.93/5 Votes: 12 Popularity: 5.32 Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. How to do ordering when you require to order data by using multiple columns
	SqlMethod LIKE [Technical Blog] Posted: 11 Aug 2011 Updated: 15 Aug 2011 Views: 29,790 Rating: 4.00/5 Votes: 2 Popularity: 1.20 Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. In this post, I am going to discuss about the special method available in .NET Framework which allows to perform the like operation as we do in the T-SQL when searching data with string.
	Linq Join on Mutiple columns using Anonymous type [Technical Blog] Posted: 2 Oct 2011 Updated: 2 Oct 2011 Views: 34,171 Rating: 4.00/5 Votes: 4 Popularity: 2.41 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Linq Join on Mutiple columns using Anonymous type
	DataLoadOptions and How to Use It in a Compiled LINQ Query [Technical Blog] Posted: 30 Nov 2011 Updated: 30 Nov 2011 Views: 15,470 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. DataLoadOption in LINQ allows immediate loading and filtering of related data
	Log your LINQ query [Technical Blog] Posted: 1 Dec 2011 Updated: 1 Dec 2011 Views: 15,221 Rating: 4.93/5 Votes: 4 Popularity: 2.97 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Log your LINQ query
	Increase Linq Query Performance by Compiling It [Technical Blog] Posted: 2 Dec 2011 Updated: 2 Dec 2011 Views: 12,610 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. How to increase Linq query performance by compiling it
	LINQ query to compare only date part of DateTime [Technical Blog] Posted: 27 Nov 2012 Updated: 29 Nov 2012 Views: 243,340 Rating: 4.88/5 Votes: 19 Popularity: 6.23 Licence: The Code Project Open License (CPOL) Bookmarked: 17 Downloaded: 0 Please Sign up or sign in to vote. LINQ query to compare only date part of DateTime.
Collections
General	ForEach Method for the Collections [Technical Blog] Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 14,270 Rating: 4.56/5 Votes: 2 Popularity: 1.37 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. ForEach method for the collections
Date and Time
Algorithms	Get Time of Code Execution Using StopWatch [Technical Blog] Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 17,770 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. How to get the time of code execution using stopwatch
Exception Handling
General	Handle Exception Carefully [Technical Blog] Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 12,290 Rating: 4.00/5 Votes: 2 Popularity: 1.20 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. How to handle exception carefully
	Getting Exact Location of Exception in C# Code [Technical Blog] Posted: 28 Jan 2014 Updated: 2 Feb 2014 Views: 38,582 Rating: 4.60/5 Votes: 9 Popularity: 4.39 Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 0 Please Sign up or sign in to vote. How to get exact location of exception in C# code
String handling
General	String Split Utility [Technical Blog] Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 16,690 Rating: 1.40/5 Votes: 3 Popularity: 0.67 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Note: Split function has more no of overload method but the below two I found useful. You may found other overloads helpful in your code.In this post I am going to discuss about two important thing about Split function of String class.
Testing and QA
General	Help Yourself in Debugging (Part 3) StackTrace and Caller Information Attribute [Technical Blog] Posted: 13 Feb 2014 Updated: 13 Feb 2014 Views: 9,500 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Help yourself in debugging (Part 3) StackTrace and Caller Information attribute
Uncategorised Technical Blogs
General	Explicit and Implicit Casting of object and Role of 'is' and 'as' keyword in Explicit casting [Technical Blog] Posted: 30 Dec 2010 Updated: 30 Dec 2010 Views: 16,530 Rating: 3.78/5 Votes: 6 Popularity: 2.94 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Explicit and Implicit Casting of object and Role of 'is' and 'as' keyword in Explicit casting
	Help Yourself in Debugging by Using Call Stack and Immediate Window [Technical Blog] Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 12,922 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Help yourself in debugging by using call stack and immediate window
	Generate thousand of request [Technical Blog] Posted: 3 Aug 2011 Updated: 3 Aug 2011 Views: 11,210 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Lastly I was working on the project where I have to designed web page which is exposing some set of the functions and which is get consume by some external application like java and flex.
	Misconception of Dynamic Type Passed to Function and Type Returned [Technical Blog] Posted: 28 Jan 2014 Updated: 28 Jan 2014 Views: 4,000 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Here is a misconception of dynamic type passed to function and type returned

Average tips rating: 3.98

ASP.NET
General	How to Freeze GridView Header While Scrolling ? [Tip/Trick] Posted: 14 Mar 2010 Updated: 14 Mar 2010 Views: 32,151 Rating: 4.50/5 Votes: 8 Popularity: 4.06 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. This thing is working for both horizontal and verticle scrolling. Here id of the div is hard coded but you can use jquery to attach css class to div element. div#gridPanel { width:900px; overflow:scroll; position:relative;}div#gridPanel th{ top:...
	Bug in Gridview Editing [Tip/Trick] Posted: 12 Aug 2012 Updated: 12 Aug 2012 Views: 10,660 Rating: 1.22/5 Votes: 2 Popularity: 0.37 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Bug in Gridview Editing
ASP.NET Controls
Grid Controls	Attach JavaScript with Auto-Generated Buttons of the GridView Control [Tip/Trick] Posted: 13 Aug 2012 Updated: 7 Feb 2013 Views: 15,830 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Attach JavaScript with auto-generated buttons of the GridView control.
HTML / CSS
General	Handling long text using TEXT-OVERFLOW : ECLLIPSIS [Tip/Trick] Posted: 25 Nov 2010 Updated: 28 Nov 2010 Views: 36,281 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Handling long text using TEXT-OVERFLOW : ECLLIPSIS
Database
General	SQL Group by With Joins [Tip/Trick] Posted: 8 Feb 2010 Updated: 15 Feb 2010 Views: 164,686 Rating: 3.92/5 Votes: 16 Popularity: 4.61 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. How to use Group By clause when joining to table Let's consider one scenario where I have two table employees (contains employee detail) and sales (contains infomation about sales done by employee).Structure of...
	Find Sp from database which is related to(using) table XXX [Tip/Trick] Posted: 25 Feb 2010 Updated: 27 Feb 2010 Views: 13,020 Rating: 3.40/5 Votes: 4 Popularity: 2.05 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Problem : - During project development I got the requirement that I have to modified the column name of the table which is used in the no of procedure i.e i have to found all procedure related to that table and modify it For the above problem following are the solution that i used First ...
	Number of different ways to get total number of rows from tables [Tip/Trick] Posted: 14 Feb 2010 Updated: 21 Jun 2010 Views: 68,020 Rating: 4.57/5 Votes: 20 Popularity: 5.74 Licence: The Code Project Open License (CPOL) Bookmarked: 25 Downloaded: 0 Please Sign up or sign in to vote. Getting a SQL Server RowCount Without doing a Table Scan
	Record Count of Tables in SQL Server [Tip/Trick] Posted: 26 Aug 2010 Updated: 26 Aug 2010 Views: 5,331 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Number of different ways to get total number of rows from tables
	CASE/WHEN return type [Tip/Trick] Posted: 18 Nov 2010 Updated: 7 Dec 2010 Views: 14,430 Rating: 4.33/5 Votes: 3 Popularity: 2.07 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. CASE/WHEN return type
C#
General	Time in HH:MM:SS format form the second [Tip/Trick] Posted: 16 Feb 2010 Updated: 16 Feb 2010 Views: 23,661 Rating: 5.00/5 Votes: 7 Popularity: 4.23 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Following is code by which you get time in (HH:SS:MM) formate by passing second as argument public string getFormattedTimeFromSecond(double second) { TimeSpan t = TimeSpan.FromSeconds(second); string formatedTime = string.Format("{0:D2}H:{1:D2}M:{2:D2}S", ...
	Linq Deferred Execution [Tip/Trick] Posted: 17 Feb 2010 Updated: 17 Feb 2010 Views: 16,541 Rating: 4.00/5 Votes: 3 Popularity: 1.91 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. To understand how execution take place consider below code: //Query not going to execute at this pointvar query = from customer in db.Customers where customer.City == "Paris" select customer; Most of the people think that the query gets...
	Make your code Speak by using C# Region [Tip/Trick] Posted: 17 Aug 2012 Updated: 17 Aug 2012 Views: 61,233 Rating: 2.72/5 Votes: 9 Popularity: 2.60 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Make your code Speak by using C# Region
	TryParse Methods [Tip/Trick] Posted: 16 Oct 2012 Updated: 16 Oct 2012 Views: 17,441 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. TryParse Methods
	Count() and Count property [Tip/Trick] Posted: 16 Oct 2012 Updated: 16 Oct 2012 Views: 12,851 Rating: 4.75/5 Votes: 3 Popularity: 2.27 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Count() and Count property
	DateTime is immutable [Tip/Trick] Posted: 24 Oct 2012 Updated: 24 Oct 2012 Views: 12,692 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. DateTime is immutable
	Extending Enum to return attached string [Tip/Trick] Posted: 25 Oct 2012 Updated: 25 Oct 2012 Views: 10,820 Rating: 2.50/5 Votes: 2 Popularity: 0.75 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Extending Enum to return attached string
	Enhance String type to get Converted In Given Type [Tip/Trick] Posted: 28 Oct 2012 Updated: 28 Oct 2012 Views: 7,350 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Enhance String type to get Converted In Given Type
	Concat() vs Union() [Tip/Trick] Posted: 30 Oct 2012 Updated: 30 Oct 2012 Views: 26,710 Rating: 4.67/5 Votes: 2 Popularity: 1.40 Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Concat() vs Union()
	Get Last n Records using Linq to SQL [Tip/Trick] Posted: 4 Nov 2012 Updated: 4 Nov 2012 Views: 46,984 Rating: 4.33/5 Votes: 2 Popularity: 1.30 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Get Last n Records using Linq to SQL
	Design TypeDataSet from Storedprocedure using temptable [Tip/Trick] Posted: 7 Nov 2012 Updated: 7 Nov 2012 Views: 8,560 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Design TypeDataSet from Storedprocedure using temptable
	Expression Tree [Tip/Trick] Posted: 9 Nov 2012 Updated: 9 Nov 2012 Views: 28,090 Rating: 4.00/5 Votes: 5 Popularity: 2.80 Licence: The Code Project Open License (CPOL) Bookmarked: 13 Downloaded: 0 Please Sign up or sign in to vote. Expression Tree
	Convert DateTime string to DateTime variable [Tip/Trick] Posted: 12 Dec 2012 Updated: 12 Dec 2012 Views: 34,260 Rating: 3.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Convert DateTime string to DateTime variable
Generics	C# Generics with primary datatypes [Tip/Trick] Posted: 7 Nov 2012 Updated: 6 Feb 2013 Views: 25,171 Rating: 3.75/5 Votes: 5 Popularity: 2.62 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. C# Generics with primary datatypes.
Windows Communication Foundation
General	Method overloading in WCF [Tip/Trick] Posted: 1 Dec 2010 Updated: 19 Dec 2010 Views: 41,861 Rating: 3.25/5 Votes: 8 Popularity: 2.94 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Method overloading in WCF
Programming Tips
General	Implicitly typed local variables [Tip/Trick] Posted: 10 Nov 2010 Updated: 11 Nov 2010 Views: 35,680 Rating: 4.45/5 Votes: 10 Popularity: 4.25 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Implicitly typed local variables
	Extension Methods [Tip/Trick] Posted: 11 Nov 2010 Updated: 11 Nov 2010 Views: 16,460 Rating: 3.75/5 Votes: 4 Popularity: 2.26 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Extension Methods
	Anonymous types [Tip/Trick] Posted: 6 Dec 2010 Updated: 6 Dec 2010 Views: 63,870 Rating: 4.62/5 Votes: 12 Popularity: 4.98 Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 0 Please Sign up or sign in to vote. Anonymous types
	Object and Collection Initialization [Tip/Trick] Posted: 6 Dec 2010 Updated: 19 Dec 2010 Views: 22,670 Rating: 4.33/5 Votes: 3 Popularity: 2.07 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Object and Collection Initialization
	(Linq and Nullable Values) OR (SQL ISNULL with LINQ) [Tip/Trick] Posted: 23 Dec 2010 Updated: 4 Jan 2011 Views: 52,532 Rating: 4.50/5 Votes: 2 Popularity: 1.35 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. (Linq and Nullable Values) OR (SQL ISNULL with LINQ)
	Linq Joins with SelectMany [Tip/Trick] Posted: 18 Jan 2011 Updated: 19 Jan 2011 Views: 24,651 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Linq Joins with SelectMany
	Increase LINQ query perfromance by compiling it [Tip/Trick] Posted: 19 Oct 2011 Updated: 20 Oct 2011 Views: 21,160 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Increase LINQ query perfromance by compiling it
	How to log your LINQ query [Tip/Trick] Posted: 19 Oct 2011 Updated: 24 Oct 2011 Views: 28,410 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Log your LINQ query
	Extended ORM generated class [Tip/Trick] Posted: 19 Oct 2011 Updated: 24 Oct 2011 Views: 15,120 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Extended ORM generated class
	DataLoadOptions and How to use in Compiled Linq query [Tip/Trick] Posted: 10 Nov 2011 Updated: 13 Nov 2011 Views: 9,120 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. DataLoadOptions and How to use in Compiled Linq query

No reference articles have been posted.

No projects have been posted.

Pranay Rana

	Software Developer (Senior)
	India

Microsoft C# MVP (12-13)

Hey, I am Pranay Rana, working as a Team Leadin MNC. Web development in Asp.Net with C# and MS sql server are the experience tools that I have had for the past 5.5 years now.

For me def. of programming is : Programming is something that you do once and that get used by multiple for many years

You can visit my blog

StackOverFlow - http://stackoverflow.com/users/314488/pranay
My CV :- http://careers.stackoverflow.com/pranayamr

Awards:

Articles by Pranay Rana (Articles: 38, Technical Blogs: 27, Tip/Tricks: 34)

Articles: 38, Technical Blogs: 27, Tip/Tricks: 34

Average article rating: 4.48

Ajax

ASP.NET

ASP.NET Controls

Client side scripting

Custom Controls

HTML / CSS

Silverlight

Validation

Web Services

Database

C#

LINQ

Windows Communication Foundation

Threads, Processes & IPC

Tools and IDE

Design and Architecture

Average blogs rating: 4.11

Database

C#

LINQ

Collections

Date and Time

Exception Handling

String handling

Testing and QA

Uncategorised Technical Blogs

Average tips rating: 3.98

ASP.NET

ASP.NET Controls

HTML / CSS

Database

C#

Windows Communication Foundation

Programming Tips

Microsoft C# MVP (12-13)

You can visit my blog