Click here to Skip to main content
15,861,172 members

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

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

RSS Feed

Average article rating: 4.48

Database Development
23 Jan 2011   Updated: 23 Jan 2011   Rating: 4.60/5    Votes: 4   Popularity: 2.77
Licence: CPOL    Views: 27,610     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
Manage SQL Server Database within Visual Studio Team System
General Programming
Architecture
18 Jun 2018   Updated: 5 Jul 2018   Rating: 2.59/5    Votes: 4   Popularity: 1.56
Licence: CPOL    Views: 7,812     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
Setting up application structure
Programming Languages
C#
18 Jul 2012   Updated: 18 Jul 2012   Rating: 4.80/5    Votes: 2   Popularity: 1.44
Licence: CPOL    Views: 22,960     Bookmarked: 3   Downloaded: 301
Please Sign up or sign in to vote.
Align Text in Autogenerated Column of Rad Silverlight Girdview and Silverlight Gridview
17 Feb 2011   Updated: 27 Feb 2011   Rating: 4.31/5    Votes: 84   Popularity: 8.11
Licence: CPOL    Views: 210,567     Bookmarked: 77   Downloaded: 0
Please Sign up or sign in to vote.
This article discusses some useful but unknown features of C#.
17 Jun 2012   Updated: 17 Jun 2012   Rating: 1.50/5    Votes: 3   Popularity: 0.72
Licence: CPOL    Views: 24,223     Bookmarked: 14   Downloaded: 0
Please Sign up or sign in to vote.
C# State machine - Yield
6 Jul 2012   Updated: 6 Jul 2012   Rating: 4.71/5    Votes: 5   Popularity: 3.30
Licence: CPOL    Views: 72,420     Bookmarked: 18   Downloaded: 0
Please Sign up or sign in to vote.
Bulk Insertion of Data Using C# DataTable and SQL server OpenXML function
11 Aug 2015   Updated: 11 Aug 2015   Rating: 4.29/5    Votes: 8   Popularity: 3.87
Licence: CPOL    Views: 70,390     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.
16 Oct 2012   Updated: 25 Oct 2012   Rating: 4.19/5    Votes: 20   Popularity: 5.35
Licence: CPOL    Views: 56,158     Bookmarked: 18   Downloaded: 0
Please Sign up or sign in to vote.
Return Anonymous type
27 Jan 2013   Updated: 28 Jan 2013   Rating: 4.71/5    Votes: 13   Popularity: 5.09
Licence: CPOL    Views: 230,612     Bookmarked: 28   Downloaded: 1,486
Please Sign up or sign in to vote.
DistinctBy in Linq (Find Distinct object by Property)
1 Apr 2012   Updated: 1 Apr 2012   Rating: 4.25/5    Votes: 5   Popularity: 2.97
Licence: CPOL    Views: 47,344     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Most efficient way to update with LINQ to SQL
18 Feb 2015   Updated: 4 Mar 2015   Rating: 4.76/5    Votes: 8   Popularity: 4.30
Licence: CPOL    Views: 36,546     Bookmarked: 11   Downloaded: 197
Please Sign up or sign in to vote.
Random number in MultiThreading
18 Nov 2013   Updated: 18 Nov 2013   Rating: 4.90/5    Votes: 6   Popularity: 3.81
Licence: CPOL    Views: 15,781     Bookmarked: 18   Downloaded: 0
Please Sign up or sign in to vote.
Help Yourself in Debugging (Part-2) using Breakpoint/Tracepoint
4 Feb 2015   Updated: 5 Feb 2015   Rating: 4.88/5    Votes: 25   Popularity: 6.83
Licence: CPOL    Views: 34,253     Bookmarked: 38   Downloaded: 183
Please Sign up or sign in to vote.
Decorator Design Pattern
11 Aug 2015   Updated: 11 Aug 2015   Rating: 4.60/5    Votes: 4   Popularity: 2.77
Licence: CPOL    Views: 18,213     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.
14 Jul 2015   Updated: 14 Jul 2015   Rating: 4.91/5    Votes: 7   Popularity: 4.15
Licence: CPOL    Views: 43,058     Bookmarked: 19   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
26 Dec 2012   Updated: 8 Jan 2013   Rating: 4.85/5    Votes: 6   Popularity: 3.77
Licence: CPOL    Views: 32,942     Bookmarked: 8   Downloaded: 738
Please Sign up or sign in to vote.
Silverlight Application with Dispatcher and asynchronous WCF Service
C# 5.0
18 Jan 2015   Updated: 12 Feb 2015   Rating: 4.73/5    Votes: 31   Popularity: 6.84
Licence: CPOL    Views: 153,284     Bookmarked: 85   Downloaded: 2,775
Please Sign up or sign in to vote.
Publisher/Subscriber pattern with Event/Delegate and EventAggregator
Java
1 Feb 2014   Updated: 7 Feb 2014   Rating: 4.87/5    Votes: 67   Popularity: 8.89
Licence: CPOL    Views: 101,446     Bookmarked: 140   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
13 Dec 2010   Updated: 26 Dec 2010   Rating: 4.88/5    Votes: 106   Popularity: 9.80
Licence: CPOL    Views: 254,557     Bookmarked: 187   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
11 Jul 2010   Updated: 4 Aug 2010   Rating: 4.88/5    Votes: 51   Popularity: 8.25
Licence: CPOL    Views: 169,329     Bookmarked: 115   Downloaded: 2,377
Please Sign up or sign in to vote.
LINQ TO SQL Enhanced Gridview
11 Jan 2011   Updated: 11 Jan 2011   Rating: 3.15/5    Votes: 12   Popularity: 3.40
Licence: CPOL    Views: 40,215     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Programming practice for server side state maintenance variable
10 Jul 2011   Updated: 18 Jul 2011   Rating: 4.74/5    Votes: 21   Popularity: 6.17
Licence: CPOL    Views: 170,317     Bookmarked: 51   Downloaded: 6,283
Please Sign up or sign in to vote.
Calling Cross Domain WCF service using Jquery/JavaScript
1 Dec 2010   Updated: 2 Dec 2010   Rating: 4.76/5    Votes: 85   Popularity: 9.06
Licence: CPOL    Views: 506,184     Bookmarked: 142   Downloaded: 17,123
Please Sign up or sign in to vote.
A guide on how to call Windows Communication Foundation services using jQuery
8 Jul 2012   Updated: 8 Jul 2012   Rating: 4.80/5    Votes: 4   Popularity: 2.89
Licence: CPOL    Views: 32,552     Bookmarked: 12   Downloaded: 0
Please Sign up or sign in to vote.
Exposing Custom event from custom control
15 Nov 2009   Updated: 15 Nov 2009   Rating: 4.09/5    Votes: 8   Popularity: 3.69
Licence: CPOL    Views: 37,200     Bookmarked: 20   Downloaded: 398
Please Sign up or sign in to vote.
Generic code of validating fields with Jquery
3 Apr 2012   Updated: 5 Apr 2012   Rating: 4.61/5    Votes: 12   Popularity: 4.97
Licence: CPOL    Views: 65,982     Bookmarked: 26   Downloaded: 2,650
Please Sign up or sign in to vote.
cascading functionality with the help of jQuery AutoComplete
8 Jun 2012   Updated: 8 Jun 2012   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: CPOL    Views: 65,472     Bookmarked: 22   Downloaded: 0
Please Sign up or sign in to vote.
Calling Server Side function from Client Side Script
4 Dec 2011   Updated: 4 Dec 2011   Rating: 4.80/5    Votes: 18   Popularity: 5.78
Licence: CPOL    Views: 59,297     Bookmarked: 25   Downloaded: 1,007
Please Sign up or sign in to vote.
Month and Year Picker UserControl
13 Jan 2010   Updated: 30 Jan 2010   Rating: 3.60/5    Votes: 8   Popularity: 3.25
Licence: CPOL    Views: 36,181     Bookmarked: 20   Downloaded: 928
Please Sign up or sign in to vote.
EnhanceGrid: with custom paging, page size, and search functionality.
26 Mar 2010   Updated: 3 Apr 2010   Rating: 4.88/5    Votes: 52   Popularity: 8.21
Licence: CPOL    Views: 121,844     Bookmarked: 117   Downloaded: 2,617
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.
24 Jan 2011   Updated: 3 Feb 2011   Rating: 4.72/5    Votes: 31   Popularity: 6.76
Licence: CPOL    Views: 200,468     Bookmarked: 93   Downloaded: 5,771
Please Sign up or sign in to vote.
Create, Host (Self Hosting, IIS hosting) and Consume WCF Service
7 Jun 2012   Updated: 29 Jun 2012   Rating: 4.51/5    Votes: 29   Popularity: 6.38
Licence: CPOL    Views: 129,174     Bookmarked: 60   Downloaded: 0
Please Sign up or sign in to vote.
Format Number To Display
15 Apr 2011   Updated: 20 Apr 2011   Rating: 4.79/5    Votes: 23   Popularity: 6.34
Licence: CPOL    Views: 88,539     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.
6 Aug 2012   Updated: 8 Feb 2013   Rating: 4.60/5    Votes: 5   Popularity: 3.22
Licence: CPOL    Views: 31,434     Bookmarked: 33   Downloaded: 762
Please Sign up or sign in to vote.
Responsive WCF service with ICallbackEventHandler Interface.
CSS
30 Dec 2013   Updated: 5 Jan 2014   Rating: 4.75/5    Votes: 27   Popularity: 6.79
Licence: CPOL    Views: 38,581     Bookmarked: 44   Downloaded: 0
Please Sign up or sign in to vote.
CSS3 Selector
HTML
4 Feb 2015   Updated: 4 Feb 2015   Rating: 4.86/5    Votes: 42   Popularity: 7.84
Licence: CPOL    Views: 306,669     Bookmarked: 78   Downloaded: 4,347
Please Sign up or sign in to vote.
Jquery Ajax Calling functions
13 Apr 2018   Updated: 1 May 2018   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: CPOL    Views: 18,226     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.
17 Dec 2009   Updated: 17 Dec 2009   Rating: 4.54/5    Votes: 34   Popularity: 6.77
Licence: CPOL    Views: 267,847     Bookmarked: 73   Downloaded: 4,084
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
29 Jul 2011   Updated: 30 Jul 2011   Rating: 4.52/5    Votes: 19   Popularity: 5.57
Licence: CPOL    Views: 85,617     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.
2 Oct 2011   Updated: 2 Oct 2011   Rating: 4.00/5    Votes: 4   Popularity: 2.41
Licence: CPOL    Views: 37,731     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Linq Join on Mutiple columns using Anonymous type
25 Jul 2011   Updated: 25 Jul 2011   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: CPOL    Views: 12,980     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
How to handle exception carefully
25 Jul 2011   Updated: 25 Jul 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 13,822     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Help yourself in debugging by using call stack and immediate window
3 Aug 2011   Updated: 3 Aug 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 11,510     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
16 Nov 2012   Updated: 19 Nov 2012   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 40,602     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
Understanding Descendants and avoiding misconception with this method
General Programming
Exceptions
28 Jan 2014   Updated: 2 Feb 2014   Rating: 4.60/5    Votes: 9   Popularity: 4.39
Licence: CPOL    Views: 45,174     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
How to get exact location of exception in C# code
LINQ
26 Jul 2011   Updated: 26 Jul 2011   Rating: 3.00/5    Votes: 2   Popularity: 0.90
Licence: CPOL    Views: 78,091     Bookmarked: 10   Downloaded: 0
Please Sign up or sign in to vote.
Building dynamic query with LINQ
Multimedia
GDI
25 Jul 2011   Updated: 25 Jul 2011   Rating: 1.40/5    Votes: 3   Popularity: 0.67
Licence: CPOL    Views: 17,380     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#
26 Jul 2011   Updated: 10 Aug 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 17,680     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Discussion about default extension method
25 Jul 2011   Updated: 10 Aug 2011   Rating: 4.20/5    Votes: 4   Popularity: 2.53
Licence: CPOL    Views: 40,433     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
Lazy initialization of object in C# with Lazy class
2 Dec 2011   Updated: 2 Dec 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 10,530     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).
26 Jul 2011   Updated: 26 Jul 2011   Rating: 4.70/5    Votes: 22   Popularity: 6.21
Licence: CPOL    Views: 80,292     Bookmarked: 25   Downloaded: 0
Please Sign up or sign in to vote.
Difference between IQueryable and IEnumerable in terms of LINQ to SQL queries.
26 Jul 2011   Updated: 26 Jul 2011   Rating: 3.41/5    Votes: 8   Popularity: 3.08
Licence: CPOL    Views: 105,497     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.
26 Jul 2011   Updated: 26 Jul 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 37,432     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
SelectMany is a way to flatten several results into a single sequence.
26 Jul 2011   Updated: 9 Aug 2011   Rating: 4.93/5    Votes: 12   Popularity: 5.32
Licence: CPOL    Views: 113,064     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
30 Nov 2011   Updated: 30 Nov 2011   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 17,110     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
DataLoadOption in LINQ allows immediate loading and filtering of related data
1 Dec 2011   Updated: 1 Dec 2011   Rating: 4.93/5    Votes: 4   Popularity: 2.97
Licence: CPOL    Views: 17,301     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Log your LINQ query
25 Jul 2011   Updated: 25 Jul 2011   Rating: 4.56/5    Votes: 2   Popularity: 1.37
Licence: CPOL    Views: 15,230     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
ForEach method for the collections
13 Feb 2014   Updated: 13 Feb 2014   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 10,751     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Help yourself in debugging (Part 3) StackTrace and Caller Information attribute
30 Dec 2010   Updated: 30 Dec 2010   Rating: 3.78/5    Votes: 6   Popularity: 2.94
Licence: CPOL    Views: 17,650     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
28 Jan 2014   Updated: 28 Jan 2014   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 4,840     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
11 Aug 2011   Updated: 11 Aug 2011   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: CPOL    Views: 10,830     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Here I am going to discuss about Any method.
2 Dec 2011   Updated: 2 Dec 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 13,240     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to increase Linq query performance by compiling it
T-SQL
11 Aug 2011   Updated: 15 Aug 2011   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: CPOL    Views: 32,121     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
27 Nov 2012   Updated: 29 Nov 2012   Rating: 4.89/5    Votes: 21   Popularity: 6.46
Licence: CPOL    Views: 278,855     Bookmarked: 18   Downloaded: 0
Please Sign up or sign in to vote.
LINQ query to compare only date part of DateTime.
25 Jul 2011   Updated: 25 Jul 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 19,900     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
25 Feb 2010   Updated: 27 Feb 2010   Rating: 3.40/5    Votes: 4   Popularity: 2.05
Licence: CPOL    Views: 14,110     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 ...
26 Aug 2010   Updated: 26 Aug 2010   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 5,901     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Number of different ways to get total number of rows from tables
12 Dec 2012   Updated: 12 Dec 2012   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 36,960     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Convert DateTime string to DateTime variable
SQL Server
18 Nov 2010   Updated: 7 Dec 2010   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: CPOL    Views: 16,230     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
CASE/WHEN return type
Programming Languages
ASP
12 Aug 2012   Updated: 12 Aug 2012   Rating: 1.22/5    Votes: 2   Popularity: 0.37
Licence: CPOL    Views: 12,421     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Bug in Gridview Editing
C
6 Nov 2012   Updated: 6 Nov 2012   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 9,150     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Design TypeDataSet from Storedprocedure using temptable
C#
16 Aug 2012   Updated: 16 Aug 2012   Rating: 2.72/5    Votes: 9   Popularity: 2.60
Licence: CPOL    Views: 73,034     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Make your code Speak by using C# Region
16 Oct 2012   Updated: 16 Oct 2012   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 19,501     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
TryParse Methods
16 Oct 2012   Updated: 16 Oct 2012   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: CPOL    Views: 17,901     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Count() and Count property
24 Oct 2012   Updated: 24 Oct 2012   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 15,682     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
DateTime is immutable
25 Oct 2012   Updated: 25 Oct 2012   Rating: 2.50/5    Votes: 2   Popularity: 0.75
Licence: CPOL    Views: 12,540     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Extending Enum to return attached string
28 Oct 2012   Updated: 28 Oct 2012   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 8,290     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Enhance String type to get Converted In Given Type
30 Oct 2012   Updated: 30 Oct 2012   Rating: 4.67/5    Votes: 2   Popularity: 1.40
Licence: CPOL    Views: 27,780     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
Concat() vs Union()
4 Nov 2012   Updated: 4 Nov 2012   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: CPOL    Views: 55,265     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Get Last n Records using Linq to SQL
8 Nov 2012   Updated: 8 Nov 2012   Rating: 4.00/5    Votes: 5   Popularity: 2.80
Licence: CPOL    Views: 32,930     Bookmarked: 13   Downloaded: 0
Please Sign up or sign in to vote.
Expression Tree
7 Nov 2012   Updated: 6 Feb 2013   Rating: 3.75/5    Votes: 5   Popularity: 2.62
Licence: CPOL    Views: 27,811     Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
C# Generics with primary datatypes.
1 Dec 2010   Updated: 19 Dec 2010   Rating: 3.25/5    Votes: 8   Popularity: 2.94
Licence: CPOL    Views: 44,132     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Method overloading in WCF
10 Nov 2010   Updated: 11 Nov 2010   Rating: 4.45/5    Votes: 10   Popularity: 4.25
Licence: CPOL    Views: 39,230     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Implicitly typed local variables
11 Nov 2010   Updated: 11 Nov 2010   Rating: 3.75/5    Votes: 4   Popularity: 2.26
Licence: CPOL    Views: 19,260     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Extension Methods
6 Dec 2010   Updated: 6 Dec 2010   Rating: 4.62/5    Votes: 12   Popularity: 4.98
Licence: CPOL    Views: 68,420     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
Anonymous types
6 Dec 2010   Updated: 19 Dec 2010   Rating: 4.33/5    Votes: 3   Popularity: 2.07
Licence: CPOL    Views: 24,840     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Object and Collection Initialization
23 Dec 2010   Updated: 4 Jan 2011   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: CPOL    Views: 55,452     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
(Linq and Nullable Values) OR (SQL ISNULL with LINQ)
18 Jan 2011   Updated: 19 Jan 2011   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 32,371     Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
Linq Joins with SelectMany
19 Oct 2011   Updated: 20 Oct 2011   Rating: 3.00/5    Votes: 2   Popularity: 0.90
Licence: CPOL    Views: 22,650     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Increase LINQ query perfromance by compiling it
19 Oct 2011   Updated: 24 Oct 2011   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 29,630     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Log your LINQ query
19 Oct 2011   Updated: 24 Oct 2011   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 15,660     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Extended ORM generated class
10 Nov 2011   Updated: 13 Nov 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 9,680     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
DataLoadOptions and How to use in Compiled Linq query
C# 4.0
16 Feb 2010   Updated: 16 Feb 2010   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 25,542     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", ...
17 Feb 2010   Updated: 17 Feb 2010   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: CPOL    Views: 18,321     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
14 Mar 2010   Updated: 14 Mar 2010   Rating: 4.50/5    Votes: 8   Popularity: 4.06
Licence: CPOL    Views: 35,941     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:...
13 Aug 2012   Updated: 7 Feb 2013   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 16,660     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Attach JavaScript with auto-generated buttons of the GridView control.
8 Feb 2010   Updated: 15 Feb 2010   Rating: 3.92/5    Votes: 16   Popularity: 4.61
Licence: CPOL    Views: 187,017     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...
14 Feb 2010   Updated: 21 Jun 2010   Rating: 4.57/5    Votes: 20   Popularity: 5.74
Licence: CPOL    Views: 72,280     Bookmarked: 25   Downloaded: 0
Please Sign up or sign in to vote.
Getting a SQL Server RowCount Without doing a Table Scan
CSS3
25 Nov 2010   Updated: 28 Nov 2010   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 40,391     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.
Software Developer (Senior)
India 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: