Click here to Skip to main content
14,737,867 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

Ajax
General
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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#.
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
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
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
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
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
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
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.
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
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.
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
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
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
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
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
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
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.
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
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
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.
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
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
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).
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
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.
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.
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.
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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
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:...
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
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
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
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...
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 ...
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
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
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
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", ...
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...
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
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
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
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
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
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
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()
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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 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: