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

Database Development
	Manage SQL Server Database 23 Jan 2011 Updated: 23 Jan 2011 Rating: 4.60/5 Votes: 4 Popularity: 2.77 Licence: CPOL Views: 27,090 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. Manage SQL Server Database within Visual Studio Team System
General Programming
Architecture	Angular Application Structure 18 Jun 2018 Updated: 5 Jul 2018 Rating: 2.59/5 Votes: 4 Popularity: 1.56 Licence: CPOL Views: 7,272 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Setting up application structure
Programming Languages
C#	Align Text in Autogenerated Column of Rad Silverlight Girdview and Silverlight Gridview 18 Jul 2012 Updated: 18 Jul 2012 Rating: 4.80/5 Votes: 2 Popularity: 1.44 Licence: CPOL Views: 22,670 Bookmarked: 3 Downloaded: 301 Please Sign up or sign in to vote. Align Text in Autogenerated Column of Rad Silverlight Girdview and Silverlight Gridview
	Some Useful Features of C# 17 Feb 2011 Updated: 27 Feb 2011 Rating: 4.31/5 Votes: 84 Popularity: 8.11 Licence: CPOL Views: 202,355 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 17 Jun 2012 Updated: 17 Jun 2012 Rating: 1.50/5 Votes: 3 Popularity: 0.72 Licence: CPOL Views: 23,793 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 6 Jul 2012 Updated: 6 Jul 2012 Rating: 4.71/5 Votes: 5 Popularity: 3.30 Licence: CPOL Views: 71,630 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 11 Aug 2015 Updated: 11 Aug 2015 Rating: 4.29/5 Votes: 8 Popularity: 3.87 Licence: CPOL Views: 69,216 Bookmarked: 15 Downloaded: 344 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.
	Return Anonymous type 16 Oct 2012 Updated: 25 Oct 2012 Rating: 4.19/5 Votes: 20 Popularity: 5.35 Licence: CPOL Views: 54,524 Bookmarked: 18 Downloaded: 0 Please Sign up or sign in to vote. Return Anonymous type
	DistinctBy in Linq (Find Distinct object by Property) 27 Jan 2013 Updated: 28 Jan 2013 Rating: 4.71/5 Votes: 13 Popularity: 5.09 Licence: CPOL Views: 228,252 Bookmarked: 28 Downloaded: 1,486 Please Sign up or sign in to vote. DistinctBy in Linq (Find Distinct object by Property)
	Most efficient way to update with LINQ to SQL 1 Apr 2012 Updated: 1 Apr 2012 Rating: 4.25/5 Votes: 5 Popularity: 2.97 Licence: CPOL Views: 46,884 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Most efficient way to update with LINQ to SQL
	Random Number in MultiThreading 18 Feb 2015 Updated: 4 Mar 2015 Rating: 4.76/5 Votes: 8 Popularity: 4.30 Licence: CPOL Views: 35,754 Bookmarked: 11 Downloaded: 196 Please Sign up or sign in to vote. Random number in MultiThreading
	Help Yourself in Debugging (Part-2) using Breakpoint/Tracepoint 18 Nov 2013 Updated: 18 Nov 2013 Rating: 4.90/5 Votes: 6 Popularity: 3.81 Licence: CPOL Views: 15,611 Bookmarked: 18 Downloaded: 0 Please Sign up or sign in to vote. Help Yourself in Debugging (Part-2) using Breakpoint/Tracepoint
	How and Where Decorator Design Pattern 4 Feb 2015 Updated: 5 Feb 2015 Rating: 4.88/5 Votes: 25 Popularity: 6.83 Licence: CPOL Views: 32,922 Bookmarked: 38 Downloaded: 183 Please Sign up or sign in to vote. Decorator Design Pattern
	Flyweight Design Pattern 11 Aug 2015 Updated: 11 Aug 2015 Rating: 4.60/5 Votes: 4 Popularity: 2.77 Licence: CPOL Views: 17,531 Bookmarked: 3 Downloaded: 148 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.
	Solid Principle In Detail 14 Jul 2015 Updated: 14 Jul 2015 Rating: 4.91/5 Votes: 7 Popularity: 4.15 Licence: CPOL Views: 41,468 Bookmarked: 18 Downloaded: 0 Please Sign up or sign in to vote. SOLID principles are related with the design and maintenance of software system.
C# 3.5	Silverlight Application with Dispatcher and asynchronous WCF service 26 Dec 2012 Updated: 8 Jan 2013 Rating: 4.85/5 Votes: 6 Popularity: 3.77 Licence: CPOL Views: 32,641 Bookmarked: 8 Downloaded: 738 Please Sign up or sign in to vote. Silverlight Application with Dispatcher and asynchronous WCF Service
C# 5.0	Publisher/Subscriber pattern with Event/Delegate and EventAggregator 18 Jan 2015 Updated: 12 Feb 2015 Rating: 4.73/5 Votes: 31 Popularity: 6.84 Licence: CPOL Views: 149,200 Bookmarked: 85 Downloaded: 2,765 Please Sign up or sign in to vote. Publisher/Subscriber pattern with Event/Delegate and EventAggregator
Java	Dependency Injection For Beginner - I 1 Feb 2014 Updated: 7 Feb 2014 Rating: 4.87/5 Votes: 67 Popularity: 8.89 Licence: CPOL Views: 98,894 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.
SQL	Learn SQL to LINQ (Visual Representation) 13 Dec 2010 Updated: 26 Dec 2010 Rating: 4.88/5 Votes: 106 Popularity: 9.80 Licence: CPOL Views: 244,971 Bookmarked: 188 Downloaded: 0 Please Sign up or sign in to vote. A discussion of LINQ queries for matching SQL queries, with visual representations.
Web Development
ASP.NET	LINQ TO SQL GridView (Enhanced Gridview) 11 Jul 2010 Updated: 4 Aug 2010 Rating: 4.88/5 Votes: 51 Popularity: 8.25 Licence: CPOL Views: 164,290 Bookmarked: 115 Downloaded: 2,375 Please Sign up or sign in to vote. LINQ TO SQL Enhanced Gridview
	Programming Practice for Server Side State Maintenance Variable 11 Jan 2011 Updated: 11 Jan 2011 Rating: 3.15/5 Votes: 12 Popularity: 3.40 Licence: CPOL Views: 38,864 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 10 Jul 2011 Updated: 18 Jul 2011 Rating: 4.74/5 Votes: 21 Popularity: 6.17 Licence: CPOL Views: 167,277 Bookmarked: 51 Downloaded: 6,283 Please Sign up or sign in to vote. Calling Cross Domain WCF service using Jquery/JavaScript
	Calling WCF Services using jQuery 1 Dec 2010 Updated: 2 Dec 2010 Rating: 4.76/5 Votes: 85 Popularity: 9.06 Licence: CPOL Views: 496,026 Bookmarked: 142 Downloaded: 17,121 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 8 Jul 2012 Updated: 8 Jul 2012 Rating: 4.80/5 Votes: 4 Popularity: 2.89 Licence: CPOL Views: 31,821 Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. Exposing Custom event from custom control
	Generic Code of Validating Fields with Jquery 15 Nov 2009 Updated: 15 Nov 2009 Rating: 4.09/5 Votes: 8 Popularity: 3.69 Licence: CPOL Views: 36,580 Bookmarked: 20 Downloaded: 397 Please Sign up or sign in to vote. Generic code of validating fields with Jquery
	Cascading with jQuery AutoComplete 3 Apr 2012 Updated: 5 Apr 2012 Rating: 4.61/5 Votes: 12 Popularity: 4.97 Licence: CPOL Views: 64,841 Bookmarked: 26 Downloaded: 2,650 Please Sign up or sign in to vote. cascading functionality with the help of jQuery AutoComplete
	Calling Server Side function from Client Side Script 8 Jun 2012 Updated: 8 Jun 2012 Rating: 5.00/5 Votes: 6 Popularity: 3.89 Licence: CPOL Views: 64,782 Bookmarked: 22 Downloaded: 0 Please Sign up or sign in to vote. Calling Server Side function from Client Side Script
	Month and Year Picker UserControl 4 Dec 2011 Updated: 4 Dec 2011 Rating: 4.80/5 Votes: 18 Popularity: 5.78 Licence: CPOL Views: 57,372 Bookmarked: 25 Downloaded: 1,007 Please Sign up or sign in to vote. Month and Year Picker UserControl
	ASP.NET Extended Grid Control 13 Jan 2010 Updated: 30 Jan 2010 Rating: 3.60/5 Votes: 8 Popularity: 3.25 Licence: CPOL Views: 35,891 Bookmarked: 20 Downloaded: 923 Please Sign up or sign in to vote. EnhanceGrid: with custom paging, page size, and search functionality.
	Enhanced Textbox Control 26 Mar 2010 Updated: 3 Apr 2010 Rating: 4.88/5 Votes: 52 Popularity: 8.21 Licence: CPOL Views: 118,232 Bookmarked: 117 Downloaded: 2,606 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.
	Create, Host (Self Hosting, IIS hosting) and Consume WCF Service 24 Jan 2011 Updated: 3 Feb 2011 Rating: 4.72/5 Votes: 31 Popularity: 6.76 Licence: CPOL Views: 198,204 Bookmarked: 93 Downloaded: 5,766 Please Sign up or sign in to vote. Create, Host (Self Hosting, IIS hosting) and Consume WCF Service
	Format Number To Display 7 Jun 2012 Updated: 29 Jun 2012 Rating: 4.51/5 Votes: 29 Popularity: 6.38 Licence: CPOL Views: 127,574 Bookmarked: 60 Downloaded: 0 Please Sign up or sign in to vote. Format Number To Display
	Create a REST service with WCF and consume it using jQuery 15 Apr 2011 Updated: 20 Apr 2011 Rating: 4.79/5 Votes: 23 Popularity: 6.34 Licence: CPOL Views: 86,938 Bookmarked: 66 Downloaded: 3,304 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 6 Aug 2012 Updated: 8 Feb 2013 Rating: 4.60/5 Votes: 5 Popularity: 3.22 Licence: CPOL Views: 30,773 Bookmarked: 33 Downloaded: 762 Please Sign up or sign in to vote. Responsive WCF service with ICallbackEventHandler Interface.
CSS	CSS3 Selector 30 Dec 2013 Updated: 5 Jan 2014 Rating: 4.75/5 Votes: 27 Popularity: 6.79 Licence: CPOL Views: 37,391 Bookmarked: 44 Downloaded: 0 Please Sign up or sign in to vote. CSS3 Selector
HTML	Jquery Ajax Calling Functions 4 Feb 2015 Updated: 4 Feb 2015 Rating: 4.86/5 Votes: 42 Popularity: 7.84 Licence: CPOL Views: 305,349 Bookmarked: 78 Downloaded: 4,344 Please Sign up or sign in to vote. Jquery Ajax Calling functions
	Angular Custom Validation Component 13 Apr 2018 Updated: 1 May 2018 Rating: 5.00/5 Votes: 6 Popularity: 3.89 Licence: CPOL Views: 17,715 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.
	DIV TABLE 17 Dec 2009 Updated: 17 Dec 2009 Rating: 4.54/5 Votes: 34 Popularity: 6.77 Licence: CPOL Views: 264,276 Bookmarked: 73 Downloaded: 4,082 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.

Average blogs rating: 4.11

All Topics
	Difference between Object, Dynamic and Var [Technical Blog] 29 Jul 2011 Updated: 30 Jul 2011 Rating: 4.52/5 Votes: 19 Popularity: 5.57 Licence: CPOL Views: 84,117 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.
	Linq Join on Mutiple columns using Anonymous type [Technical Blog] 2 Oct 2011 Updated: 2 Oct 2011 Rating: 4.00/5 Votes: 4 Popularity: 2.41 Licence: CPOL Views: 37,391 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Linq Join on Mutiple columns using Anonymous type
	Handle Exception Carefully [Technical Blog] 25 Jul 2011 Updated: 25 Jul 2011 Rating: 4.00/5 Votes: 2 Popularity: 1.20 Licence: CPOL Views: 12,840 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. How to handle exception carefully
	Help Yourself in Debugging by Using Call Stack and Immediate Window [Technical Blog] 25 Jul 2011 Updated: 25 Jul 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 13,662 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] 3 Aug 2011 Updated: 3 Aug 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 11,450 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.
Database Development
SQL Server	Read XML with Descendants Method (XName) [Technical Blog] 16 Nov 2012 Updated: 19 Nov 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 39,751 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Understanding Descendants and avoiding misconception with this method
General Programming
Exceptions	Getting Exact Location of Exception in C# Code [Technical Blog] 28 Jan 2014 Updated: 2 Feb 2014 Rating: 4.60/5 Votes: 9 Popularity: 4.39 Licence: CPOL Views: 43,992 Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. How to get exact location of exception in C# code
LINQ
	Dynamic Query with Linq [Technical Blog] 26 Jul 2011 Updated: 26 Jul 2011 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: CPOL Views: 77,271 Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. Building dynamic query with LINQ
Multimedia
GDI	String Split Utility [Technical Blog] 25 Jul 2011 Updated: 25 Jul 2011 Rating: 1.40/5 Votes: 3 Popularity: 0.67 Licence: CPOL Views: 17,230 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.
Programming Languages
C#	Default Extension Methods [Technical Blog] 26 Jul 2011 Updated: 10 Aug 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 17,570 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] 25 Jul 2011 Updated: 10 Aug 2011 Rating: 4.20/5 Votes: 4 Popularity: 2.53 Licence: CPOL Views: 39,983 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] 2 Dec 2011 Updated: 2 Dec 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 10,430 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).
	IQueryable vs. IEnumerable in terms of LINQ to SQL queries [Technical Blog] 26 Jul 2011 Updated: 26 Jul 2011 Rating: 4.70/5 Votes: 22 Popularity: 6.21 Licence: CPOL Views: 79,570 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] 26 Jul 2011 Updated: 26 Jul 2011 Rating: 3.41/5 Votes: 8 Popularity: 3.08 Licence: CPOL Views: 104,597 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] 26 Jul 2011 Updated: 26 Jul 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 36,991 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. SelectMany is a way to flatten several results into a single sequence.
	Ordering Data in LINQ Queries by More Than One Column [Technical Blog] 26 Jul 2011 Updated: 9 Aug 2011 Rating: 4.93/5 Votes: 12 Popularity: 5.32 Licence: CPOL Views: 108,516 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
	DataLoadOptions and How to Use It in a Compiled LINQ Query [Technical Blog] 30 Nov 2011 Updated: 30 Nov 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 16,900 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] 1 Dec 2011 Updated: 1 Dec 2011 Rating: 4.93/5 Votes: 4 Popularity: 2.97 Licence: CPOL Views: 17,021 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Log your LINQ query
	ForEach Method for the Collections [Technical Blog] 25 Jul 2011 Updated: 25 Jul 2011 Rating: 4.56/5 Votes: 2 Popularity: 1.37 Licence: CPOL Views: 14,980 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. ForEach method for the collections
	Help Yourself in Debugging (Part 3) StackTrace and Caller Information Attribute [Technical Blog] 13 Feb 2014 Updated: 13 Feb 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 10,490 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Help yourself in debugging (Part 3) StackTrace and Caller Information attribute
	Explicit and Implicit Casting of object and Role of 'is' and 'as' keyword in Explicit casting [Technical Blog] 30 Dec 2010 Updated: 30 Dec 2010 Rating: 3.78/5 Votes: 6 Popularity: 2.94 Licence: CPOL Views: 17,360 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
	Misconception of Dynamic Type Passed to Function and Type Returned [Technical Blog] 28 Jan 2014 Updated: 28 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 4,700 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
SQL	Any Method [Technical Blog] 11 Aug 2011 Updated: 11 Aug 2011 Rating: 4.00/5 Votes: 3 Popularity: 1.91 Licence: CPOL Views: 10,770 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Here I am going to discuss about Any method.
	Increase Linq Query Performance by Compiling It [Technical Blog] 2 Dec 2011 Updated: 2 Dec 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 13,060 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. How to increase Linq query performance by compiling it
T-SQL	SqlMethod LIKE [Technical Blog] 11 Aug 2011 Updated: 15 Aug 2011 Rating: 4.00/5 Votes: 2 Popularity: 1.20 Licence: CPOL Views: 31,810 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.
XML	LINQ query to compare only date part of DateTime [Technical Blog] 27 Nov 2012 Updated: 29 Nov 2012 Rating: 4.89/5 Votes: 21 Popularity: 6.46 Licence: CPOL Views: 273,633 Bookmarked: 18 Downloaded: 0 Please Sign up or sign in to vote. LINQ query to compare only date part of DateTime.
	Get Time of Code Execution Using StopWatch [Technical Blog] 25 Jul 2011 Updated: 25 Jul 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 19,560 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. How to get the time of code execution using stopwatch

Average tips rating: 3.98

Database Development
	Find Sp from database which is related to(using) table XXX [Tip/Trick] 25 Feb 2010 Updated: 27 Feb 2010 Rating: 3.40/5 Votes: 4 Popularity: 2.05 Licence: CPOL Views: 13,940 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 ...
	Record Count of Tables in SQL Server [Tip/Trick] 26 Aug 2010 Updated: 26 Aug 2010 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,761 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Number of different ways to get total number of rows from tables
	Convert DateTime string to DateTime variable [Tip/Trick] 12 Dec 2012 Updated: 12 Dec 2012 Rating: 3.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 36,540 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Convert DateTime string to DateTime variable
SQL Server	CASE/WHEN return type [Tip/Trick] 18 Nov 2010 Updated: 7 Dec 2010 Rating: 4.33/5 Votes: 3 Popularity: 2.07 Licence: CPOL Views: 15,860 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. CASE/WHEN return type
Programming Languages
ASP	Bug in Gridview Editing [Tip/Trick] 12 Aug 2012 Updated: 12 Aug 2012 Rating: 1.22/5 Votes: 2 Popularity: 0.37 Licence: CPOL Views: 12,080 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Bug in Gridview Editing
C	Design TypeDataSet from Storedprocedure using temptable [Tip/Trick] 6 Nov 2012 Updated: 6 Nov 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 9,000 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Design TypeDataSet from Storedprocedure using temptable
C#	Make your code Speak by using C# Region [Tip/Trick] 16 Aug 2012 Updated: 16 Aug 2012 Rating: 2.72/5 Votes: 9 Popularity: 2.60 Licence: CPOL Views: 71,533 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Make your code Speak by using C# Region
	TryParse Methods [Tip/Trick] 16 Oct 2012 Updated: 16 Oct 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 19,321 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. TryParse Methods
	Count() and Count property [Tip/Trick] 16 Oct 2012 Updated: 16 Oct 2012 Rating: 4.75/5 Votes: 3 Popularity: 2.27 Licence: CPOL Views: 17,001 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Count() and Count property
	DateTime is immutable [Tip/Trick] 24 Oct 2012 Updated: 24 Oct 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 15,142 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. DateTime is immutable
	Extending Enum to return attached string [Tip/Trick] 25 Oct 2012 Updated: 25 Oct 2012 Rating: 2.50/5 Votes: 2 Popularity: 0.75 Licence: CPOL Views: 12,180 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] 28 Oct 2012 Updated: 28 Oct 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 8,060 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] 30 Oct 2012 Updated: 30 Oct 2012 Rating: 4.67/5 Votes: 2 Popularity: 1.40 Licence: CPOL Views: 27,610 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] 4 Nov 2012 Updated: 4 Nov 2012 Rating: 4.33/5 Votes: 2 Popularity: 1.30 Licence: CPOL Views: 53,984 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Get Last n Records using Linq to SQL
	Expression Tree [Tip/Trick] 8 Nov 2012 Updated: 8 Nov 2012 Rating: 4.00/5 Votes: 5 Popularity: 2.80 Licence: CPOL Views: 32,260 Bookmarked: 13 Downloaded: 0 Please Sign up or sign in to vote. Expression Tree
	C# Generics with primary datatypes [Tip/Trick] 7 Nov 2012 Updated: 6 Feb 2013 Rating: 3.75/5 Votes: 5 Popularity: 2.62 Licence: CPOL Views: 27,141 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. C# Generics with primary datatypes.
	Method overloading in WCF [Tip/Trick] 1 Dec 2010 Updated: 19 Dec 2010 Rating: 3.25/5 Votes: 8 Popularity: 2.94 Licence: CPOL Views: 43,731 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Method overloading in WCF
	Implicitly typed local variables [Tip/Trick] 10 Nov 2010 Updated: 11 Nov 2010 Rating: 4.45/5 Votes: 10 Popularity: 4.25 Licence: CPOL Views: 38,590 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Implicitly typed local variables
	Extension Methods [Tip/Trick] 11 Nov 2010 Updated: 11 Nov 2010 Rating: 3.75/5 Votes: 4 Popularity: 2.26 Licence: CPOL Views: 18,730 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Extension Methods
	Anonymous types [Tip/Trick] 6 Dec 2010 Updated: 6 Dec 2010 Rating: 4.62/5 Votes: 12 Popularity: 4.98 Licence: CPOL Views: 67,720 Bookmarked: 11 Downloaded: 0 Please Sign up or sign in to vote. Anonymous types
	Object and Collection Initialization [Tip/Trick] 6 Dec 2010 Updated: 19 Dec 2010 Rating: 4.33/5 Votes: 3 Popularity: 2.07 Licence: CPOL Views: 24,380 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] 23 Dec 2010 Updated: 4 Jan 2011 Rating: 4.50/5 Votes: 2 Popularity: 1.35 Licence: CPOL Views: 54,952 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] 18 Jan 2011 Updated: 19 Jan 2011 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: CPOL Views: 31,281 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] 19 Oct 2011 Updated: 20 Oct 2011 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: CPOL Views: 22,370 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] 19 Oct 2011 Updated: 24 Oct 2011 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 29,430 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Log your LINQ query
	Extended ORM generated class [Tip/Trick] 19 Oct 2011 Updated: 24 Oct 2011 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 15,540 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] 10 Nov 2011 Updated: 13 Nov 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 9,590 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. DataLoadOptions and How to use in Compiled Linq query
C# 4.0	Time in HH:MM:SS format form the second [Tip/Trick] 16 Feb 2010 Updated: 16 Feb 2010 Rating: 5.00/5 Votes: 7 Popularity: 4.23 Licence: CPOL Views: 25,282 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] 17 Feb 2010 Updated: 17 Feb 2010 Rating: 4.00/5 Votes: 3 Popularity: 1.91 Licence: CPOL Views: 18,001 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...
Web Development
ASP.NET	How to Freeze GridView Header While Scrolling ? [Tip/Trick] 14 Mar 2010 Updated: 14 Mar 2010 Rating: 4.50/5 Votes: 8 Popularity: 4.06 Licence: CPOL Views: 35,291 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:...
	Attach JavaScript with Auto-Generated Buttons of the GridView Control [Tip/Trick] 13 Aug 2012 Updated: 7 Feb 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 16,500 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Attach JavaScript with auto-generated buttons of the GridView control.
	SQL Group by With Joins [Tip/Trick] 8 Feb 2010 Updated: 15 Feb 2010 Rating: 3.92/5 Votes: 16 Popularity: 4.61 Licence: CPOL Views: 185,336 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...
	Number of different ways to get total number of rows from tables [Tip/Trick] 14 Feb 2010 Updated: 21 Jun 2010 Rating: 4.57/5 Votes: 20 Popularity: 5.74 Licence: CPOL Views: 71,440 Bookmarked: 25 Downloaded: 0 Please Sign up or sign in to vote. Getting a SQL Server RowCount Without doing a Table Scan
CSS3	Handling long text using TEXT-OVERFLOW : ECLLIPSIS [Tip/Trick] 25 Nov 2010 Updated: 28 Nov 2010 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 39,221 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Handling long text using TEXT-OVERFLOW : ECLLIPSIS

Average reference rating:

No reference articles have been posted.

Average project rating:

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

Database Development

General Programming

Programming Languages

Web Development

Average blogs rating: 4.11

All Topics

Database Development

General Programming

LINQ

Multimedia

Programming Languages

Average tips rating: 3.98

Database Development

Programming Languages

Web Development

Average reference rating:

Average project rating:

Microsoft C# MVP (12-13)

You can visit my blog