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

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

Articles
Technical Blogs
Tips and Tricks
Reference Articles

Average article rating: 4.52

Ajax

General

Jquery Ajax Calling Functions

Posted: 4 Feb 2015 Updated: 4 Feb 2015 Views: 216,680 Rating: 4.86/5 Votes: 41 Popularity: 7.82

Licence: The Code Project Open License (CPOL) Bookmarked: 77 Downloaded: 3,957

Jquery Ajax Calling functions

ASP.NET

General

LINQ TO SQL GridView (Enhanced Gridview)

Posted: 11 Jul 2010 Updated: 4 Aug 2010 Views: 116,150 Rating: 4.88/5 Votes: 51 Popularity: 8.32

Licence: The Code Project Open License (CPOL) Bookmarked: 114 Downloaded: 2,273

LINQ TO SQL Enhanced Gridview

Programming Practice for Server Side State Maintenance Variable

Posted: 11 Jan 2011 Updated: 11 Jan 2011 Views: 26,080 Rating: 3.08/5 Votes: 12 Popularity: 3.32

Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0

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: 128,020 Rating: 4.74/5 Votes: 21 Popularity: 6.27

Licence: The Code Project Open License (CPOL) Bookmarked: 51 Downloaded: 6,039

Calling Cross Domain WCF service using Jquery/JavaScript

Howto

Calling WCF Services using jQuery

Posted: 1 Dec 2010 Updated: 2 Dec 2010 Views: 373,070 Rating: 4.76/5 Votes: 83 Popularity: 9.23

Licence: The Code Project Open License (CPOL) Bookmarked: 139 Downloaded: 16,181

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: 20,030 Rating: 4.80/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 0

Exposing Custom event from custom control

Utilities

Generic Code of Validating Fields with Jquery

Posted: 15 Nov 2009 Updated: 15 Nov 2009 Views: 24,290 Rating: 4.09/5 Votes: 8 Popularity: 3.61

Licence: The Code Project Open License (CPOL) Bookmarked: 19 Downloaded: 369

Generic code of validating fields with Jquery

Cascading with jQuery AutoComplete

Posted: 3 Apr 2012 Updated: 5 Apr 2012 Views: 42,560 Rating: 4.58/5 Votes: 12 Popularity: 4.94

Licence: The Code Project Open License (CPOL) Bookmarked: 26 Downloaded: 2,489

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: 50,550 Rating: 5.00/5 Votes: 6 Popularity: 3.89

Licence: The Code Project Open License (CPOL) Bookmarked: 22 Downloaded: 0

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: 33,200 Rating: 4.80/5 Votes: 18 Popularity: 5.95

Licence: The Code Project Open License (CPOL) Bookmarked: 25 Downloaded: 925

Month and Year Picker UserControl

Custom Controls

General

ASP.NET Extended Grid Control

Posted: 13 Jan 2010 Updated: 30 Jan 2010 Views: 24,540 Rating: 3.60/5 Votes: 8 Popularity: 3.25

Licence: The Code Project Open License (CPOL) Bookmarked: 20 Downloaded: 849

EnhanceGrid: with custom paging, page size, and search functionality.

HTML / CSS

CSS

DIV TABLE

Posted: 17 Dec 2009 Updated: 17 Dec 2009 Views: 208,370 Rating: 4.54/5 Votes: 34 Popularity: 7.06

Licence: The Code Project Open License (CPOL) Bookmarked: 75 Downloaded: 3,900

This article demonstrates using div elements to effectively to build websites without using table elements on a page

General

CSS3 Selector

Posted: 30 Dec 2013 Updated: 5 Jan 2014 Views: 21,970 Rating: 4.75/5 Votes: 27 Popularity: 6.78

Licence: The Code Project Open License (CPOL) Bookmarked: 43 Downloaded: 0

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: 14,150 Rating: 4.80/5 Votes: 2 Popularity: 1.35

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 282

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: 21,330 Rating: 4.85/5 Votes: 6 Popularity: 3.58

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 678

Silverlight Application with Dispatcher and asynchronous WCF Service

Validation

Validation Controls

Enhanced Textbox Control

Posted: 26 Mar 2010 Updated: 3 Apr 2010 Views: 77,800 Rating: 4.88/5 Votes: 52 Popularity: 8.34

Licence: The Code Project Open License (CPOL) Bookmarked: 118 Downloaded: 2,276

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: 161,420 Rating: 4.72/5 Votes: 31 Popularity: 7.04

Licence: The Code Project Open License (CPOL) Bookmarked: 92 Downloaded: 5,558

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: 17,980 Rating: 4.60/5 Votes: 4 Popularity: 2.74

Licence: The Code Project Open License (CPOL) Bookmarked: 9 Downloaded: 0

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: 165,830 Rating: 4.30/5 Votes: 84 Popularity: 8.24

Licence: The Code Project Open License (CPOL) Bookmarked: 77 Downloaded: 0

This article discusses some useful but unknown features of C#.

C# State machine - Yield

Posted: 17 Jun 2012 Updated: 17 Jun 2012 Views: 18,030 Rating: 1.50/5 Votes: 3 Popularity: 1.19

Licence: The Code Project Open License (CPOL) Bookmarked: 15 Downloaded: 0

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: 55,360 Rating: 4.71/5 Votes: 5 Popularity: 3.26

Licence: The Code Project Open License (CPOL) Bookmarked: 18 Downloaded: 0

Bulk Insertion of Data Using C# DataTable and SQL server OpenXML function

ContinueWith Vs await

Posted: 11 Aug 2015 Updated: 11 Aug 2015 Views: 20,660 Rating: 4.50/5 Votes: 6 Popularity: 3.62

Licence: The Code Project Open License (CPOL) Bookmarked: 13 Downloaded: 160

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: 82,250 Rating: 4.49/5 Votes: 28 Popularity: 6.71

Licence: The Code Project Open License (CPOL) Bookmarked: 58 Downloaded: 0

Format Number To Display

Return Anonymous type

Posted: 16 Oct 2012 Updated: 25 Oct 2012 Views: 28,660 Rating: 4.19/5 Votes: 20 Popularity: 5.59

Licence: The Code Project Open License (CPOL) Bookmarked: 18 Downloaded: 0

Return Anonymous type

DistinctBy in Linq (Find Distinct object by Property)

Posted: 27 Jan 2013 Updated: 28 Jan 2013 Views: 138,270 Rating: 4.71/5 Votes: 13 Popularity: 5.23

Licence: The Code Project Open License (CPOL) Bookmarked: 27 Downloaded: 1,258

DistinctBy in Linq (Find Distinct object by Property)

LINQ

General

Learn SQL to LINQ (Visual Representation)

Posted: 13 Dec 2010 Updated: 26 Dec 2010 Views: 182,180 Rating: 4.88/5 Votes: 106 Popularity: 9.88

Licence: The Code Project Open License (CPOL) Bookmarked: 186 Downloaded: 0

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: 35,210 Rating: 4.25/5 Votes: 5 Popularity: 2.45

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

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: 64,130 Rating: 4.79/5 Votes: 23 Popularity: 6.51

Licence: The Code Project Open License (CPOL) Bookmarked: 65 Downloaded: 3,216

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: 20,610 Rating: 4.60/5 Votes: 5 Popularity: 3.49

Licence: The Code Project Open License (CPOL) Bookmarked: 32 Downloaded: 693

Responsive WCF service with ICallbackEventHandler Interface.

Threads, Processes & IPC

Multi-threading

Random Number in MultiThreading

Posted: 18 Feb 2015 Updated: 4 Mar 2015 Views: 12,920 Rating: 4.76/5 Votes: 8 Popularity: 4.27

Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 130

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: 11,610 Rating: 4.90/5 Votes: 6 Popularity: 3.79

Licence: The Code Project Open License (CPOL) Bookmarked: 18 Downloaded: 0

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: 15,960 Rating: 4.89/5 Votes: 24 Popularity: 6.79

Licence: The Code Project Open License (CPOL) Bookmarked: 36 Downloaded: 150

Decorator Design Pattern

Flyweight Design Pattern

Posted: 11 Aug 2015 Updated: 11 Aug 2015 Views: 9,110 Rating: 4.60/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 110

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: 11,880 Rating: 4.89/5 Votes: 5 Popularity: 3.41

Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 0

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: 61,320 Rating: 4.86/5 Votes: 64 Popularity: 8.78

Licence: The Code Project Open License (CPOL) Bookmarked: 137 Downloaded: 0

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: 68,350 Rating: 4.72/5 Votes: 28 Popularity: 6.81

Licence: The Code Project Open License (CPOL) Bookmarked: 79 Downloaded: 1,539

Publisher/Subscriber pattern with Event/Delegate and EventAggregator

Average blogs rating: 4.08

Database

SQL

Any Method [Technical Blog]

Posted: 11 Aug 2011 Updated: 11 Aug 2011 Views: 9,270 Rating: 4.00/5 Votes: 3 Popularity: 1.91

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

Here I am going to discuss about Any method.

C#

General

Difference between Object, Dynamic and Var [Technical Blog]

Posted: 29 Jul 2011 Updated: 30 Jul 2011 Views: 57,980 Rating: 4.52/5 Votes: 19 Popularity: 5.75

Licence: The Code Project Open License (CPOL) Bookmarked: 21 Downloaded: 0

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: 15,640 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 29,420 Rating: 4.20/5 Votes: 4 Popularity: 2.61

Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0

Lazy initialization of object in C# with Lazy class

Extend ORM Generated Class [Technical Blog]

Posted: 2 Dec 2011 Updated: 2 Dec 2011 Views: 8,510 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 23,430 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

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: 71,120 Rating: 4.70/5 Votes: 22 Popularity: 6.26

Licence: The Code Project Open License (CPOL) Bookmarked: 26 Downloaded: 0

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: 68,500 Rating: 3.31/5 Votes: 7 Popularity: 2.76

Licence: The Code Project Open License (CPOL) Bookmarked: 13 Downloaded: 0

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: 25,670 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 58,160 Rating: 3.00/5 Votes: 2 Popularity: 1.20

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

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: 67,860 Rating: 4.90/5 Votes: 11 Popularity: 5.10

Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 0

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: 24,080 Rating: 4.00/5 Votes: 2 Popularity: 1.20

Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0

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: 22,160 Rating: 3.67/5 Votes: 3 Popularity: 2.39

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

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: 11,650 Rating: 5.00/5 Votes: 1 Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

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: 11,680 Rating: 4.93/5 Votes: 4 Popularity: 2.96

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

Log your LINQ query

Increase Linq Query Performance by Compiling It [Technical Blog]

Posted: 2 Dec 2011 Updated: 2 Dec 2011 Views: 10,770 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

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: 144,760 Rating: 4.85/5 Votes: 15 Popularity: 5.78

Licence: The Code Project Open License (CPOL) Bookmarked: 14 Downloaded: 0

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: 12,320 Rating: 4.56/5 Votes: 2 Popularity: 0.30

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 14,880 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 10,660 Rating: 4.00/5 Votes: 2 Popularity: 1.20

Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0

How to handle exception carefully

Getting Exact Location of Exception in C# Code [Technical Blog]

Posted: 28 Jan 2014 Updated: 2 Feb 2014 Views: 20,730 Rating: 4.60/5 Votes: 9 Popularity: 4.44

Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 0

Post is about locating exact location of the Exception in the code. There is always problem for the developer to locate exact location from where Exception raised, because of that it difficult for the developer what actually went wrong.

String handling

General

String Split Utility [Technical Blog]

Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 14,590 Rating: 1.40/5 Votes: 3 Popularity: 1.43

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

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: 6,790 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

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: 13,340 Rating: 3.78/5 Votes: 6 Popularity: 2.94

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

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: 10,800 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 10,410 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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 Dyanmic type passed to function and type returned [Technical Blog]

Posted: 28 Jan 2014 Updated: 28 Jan 2014 Views: 2,700 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

Small post is about miconception related to dynamic type variable supported by the C# langauge.

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: 22,490 Rating: 4.50/5 Votes: 8 Popularity: 4.00

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

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: 6,950 Rating: 1.22/5 Votes: 2 Popularity: 0.30

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

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: 12,380 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

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: 29,400 Rating: 5.00/5 Votes: 3 Popularity: 2.39

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

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: 108,500 Rating: 3.92/5 Votes: 16 Popularity: 4.45

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

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: 8,880 Rating: 3.40/5 Votes: 4 Popularity: 2.05

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

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: 55,910 Rating: 4.60/5 Votes: 20 Popularity: 5.96

Licence: The Code Project Open License (CPOL) Bookmarked: 24 Downloaded: 0

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: 3,350 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 10,400 Rating: 4.33/5 Votes: 3 Popularity: 2.07

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 17,710 Rating: 5.00/5 Votes: 7 Popularity: 4.23

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

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: 12,270 Rating: 4.00/5 Votes: 3 Popularity: 1.91

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

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: 16 Aug 2012 Updated: 16 Aug 2012 Views: 39,550 Rating: 2.72/5 Votes: 9 Popularity: 2.45

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

Make your code Speak by using C# Region

TryParse Methods [Tip/Trick]

Posted: 16 Oct 2012 Updated: 16 Oct 2012 Views: 11,310 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

TryParse Methods

Count() and Count property [Tip/Trick]

Posted: 16 Oct 2012 Updated: 16 Oct 2012 Views: 7,990 Rating: 4.75/5 Votes: 3 Popularity: 2.39

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

Count() and Count property

DateTime is immutable [Tip/Trick]

Posted: 24 Oct 2012 Updated: 24 Oct 2012 Views: 7,980 Rating: 5.00/5 Votes: 1 Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

DateTime is immutable

Extending Enum to return attached string [Tip/Trick]

Posted: 25 Oct 2012 Updated: 25 Oct 2012 Views: 7,400 Rating: 2.50/5 Votes: 2 Popularity: 0.90

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

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: 4,690 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

Enhance String type to get Converted In Given Type

Concat() vs Union() [Tip/Trick]

Posted: 30 Oct 2012 Updated: 30 Oct 2012 Views: 17,430 Rating: 4.67/5 Votes: 2 Popularity: 1.20

Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0

Concat() vs Union()

Get Last n Records using Linq to SQL [Tip/Trick]

Posted: 4 Nov 2012 Updated: 4 Nov 2012 Views: 27,610 Rating: 4.33/5 Votes: 2 Popularity: 0.90

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

Get Last n Records using Linq to SQL

Design TypeDataSet from Storedprocedure using temptable [Tip/Trick]

Posted: 6 Nov 2012 Updated: 6 Nov 2012 Views: 6,420 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

Design TypeDataSet from Storedprocedure using temptable

Expression Tree [Tip/Trick]

Posted: 8 Nov 2012 Updated: 8 Nov 2012 Views: 19,570 Rating: 4.00/5 Votes: 4 Popularity: 2.41

Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 0

Expression Tree

Convert DateTime string to DateTime variable [Tip/Trick]

Posted: 12 Dec 2012 Updated: 12 Dec 2012 Views: 27,410 Rating: 3.00/5 Votes: 1 Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

Convert DateTime string to DateTime variable

Generics

C# Generics with primary datatypes [Tip/Trick]

Posted: 7 Nov 2012 Updated: 6 Feb 2013 Views: 19,240 Rating: 3.75/5 Votes: 5 Popularity: 1.75

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

C# Generics with primary datatypes.

Windows Communication Foundation

General

Method overloading in WCF [Tip/Trick]

Posted: 1 Dec 2010 Updated: 19 Dec 2010 Views: 35,020 Rating: 3.25/5 Votes: 8 Popularity: 2.80

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

Method overloading in WCF

Programming Tips

General

Implicitly typed local variables [Tip/Trick]

Posted: 10 Nov 2010 Updated: 11 Nov 2010 Views: 27,660 Rating: 4.25/5 Votes: 10 Popularity: 4.18

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

Implicitly typed local variables

Extension Methods [Tip/Trick]

Posted: 11 Nov 2010 Updated: 11 Nov 2010 Views: 10,130 Rating: 3.75/5 Votes: 4 Popularity: 2.26

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

Extension Methods

Anonymous types [Tip/Trick]

Posted: 6 Dec 2010 Updated: 6 Dec 2010 Views: 50,070 Rating: 4.62/5 Votes: 12 Popularity: 4.95

Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 0

Anonymous types

Object and Collection Initialization [Tip/Trick]

Posted: 6 Dec 2010 Updated: 19 Dec 2010 Views: 17,480 Rating: 4.33/5 Votes: 3 Popularity: 2.07

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

Object and Collection Initialization

(Linq and Nullable Values) OR (SQL ISNULL with LINQ) [Tip/Trick]

Posted: 23 Dec 2010 Updated: 4 Jan 2011 Views: 42,120 Rating: 4.50/5 Votes: 2 Popularity: 1.35

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

(Linq and Nullable Values) OR (SQL ISNULL with LINQ)

Linq Joins with SelectMany [Tip/Trick]

Posted: 18 Jan 2011 Updated: 19 Jan 2011 Views: 16,270 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

Linq Joins with SelectMany

Increase LINQ query perfromance by compiling it [Tip/Trick]

Posted: 19 Oct 2011 Updated: 20 Oct 2011 Views: 17,510 Rating: 3.00/5 Votes: 2 Popularity: 1.20

Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0

Increase LINQ query perfromance by compiling it

How to log your LINQ query [Tip/Trick]

Posted: 19 Oct 2011 Updated: 24 Oct 2011 Views: 24,540 Rating: 4.00/5 Votes: 1 Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

Log your LINQ query

Extended ORM generated class [Tip/Trick]

Posted: 19 Oct 2011 Updated: 24 Oct 2011 Views: 12,710 Rating: 4.00/5 Votes: 1 Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

Extended ORM generated class

DataLoadOptions and How to use in Compiled Linq query [Tip/Trick]

Posted: 10 Nov 2011 Updated: 13 Nov 2011 Views: 6,800 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0

DataLoadOptions and How to use in Compiled Linq query

No reference articles have been posted.

Pranay Rana

	Software Developer (Senior) GMind Solusion
	India

Microsoft C# MVP (12-13)

Hey, I am Pranay Rana, working as a ITA in 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:

26 Apr 2010: Best ASP.NET article of March 2010

23 Aug 2010: Best ASP.NET article of July 2010

2nd In ASP.NET article of December 2010

3rd In C# article of December 2010

4th In Overall article of December 2010

4th In Best overall article of February 2011

5th In Best C# article of February 2011

4th In Best ASP.NET article of April 2011

Advertise | Privacy |
Web04 | 2.8.170813.1 | Last Updated 21 Aug 2017

Layout: fixed | fluid