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

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

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.48

Ajax

General

Jquery Ajax Calling Functions

Posted: 4 Feb 2015 Updated: 4 Feb 2015 Views: 272,852 Rating: 4.86/5 Votes: 42 Popularity: 7.84

Licence: The Code Project Open License (CPOL) Bookmarked: 78 Downloaded: 4,257

Jquery Ajax Calling functions

ASP.NET

General

LINQ TO SQL GridView (Enhanced Gridview)

Posted: 11 Jul 2010 Updated: 4 Aug 2010 Views: 137,743 Rating: 4.88/5 Votes: 51 Popularity: 8.25

Licence: The Code Project Open License (CPOL) Bookmarked: 115 Downloaded: 2,344

LINQ TO SQL Enhanced Gridview

Programming Practice for Server Side State Maintenance Variable

Posted: 11 Jan 2011 Updated: 11 Jan 2011 Views: 30,441 Rating: 3.15/5 Votes: 12 Popularity: 3.40

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: 147,380 Rating: 4.74/5 Votes: 21 Popularity: 6.17

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

Calling Cross Domain WCF service using Jquery/JavaScript

Howto

Calling WCF Services using jQuery

Posted: 1 Dec 2010 Updated: 2 Dec 2010 Views: 439,671 Rating: 4.76/5 Votes: 85 Popularity: 9.06

Licence: The Code Project Open License (CPOL) Bookmarked: 142 Downloaded: 16,941

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: 25,540 Rating: 4.80/5 Votes: 4 Popularity: 2.89

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: 32,140 Rating: 4.09/5 Votes: 8 Popularity: 3.69

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

Generic code of validating fields with Jquery

Cascading with jQuery AutoComplete

Posted: 3 Apr 2012 Updated: 5 Apr 2012 Views: 55,760 Rating: 4.61/5 Votes: 12 Popularity: 4.97

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

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: 58,430 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: 44,560 Rating: 4.80/5 Votes: 18 Popularity: 5.78

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

Month and Year Picker UserControl

Client side scripting

General

Angular Custom Validation Component

Posted: 13 Apr 2018 Updated: 1 May 2018 Views: 11,661 Rating: 5.00/5 Votes: 6 Popularity: 3.89

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

This post is about validation in Angular 2 application, which means it's about validation on client side, not about server side.

Angular Application Structure

Posted: 18 Jun 2018 Updated: 5 Jul 2018 Views: 3,540 Rating: 2.59/5 Votes: 4 Popularity: 1.51

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

Setting up application structure

Custom Controls

General

ASP.NET Extended Grid Control

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

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

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

HTML / CSS

CSS

DIV TABLE

Posted: 17 Dec 2009 Updated: 17 Dec 2009 Views: 238,310 Rating: 4.54/5 Votes: 34 Popularity: 6.77

Licence: The Code Project Open License (CPOL) Bookmarked: 73 Downloaded: 4,019

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

General

CSS3 Selector

Posted: 30 Dec 2013 Updated: 5 Jan 2014 Views: 28,660 Rating: 4.75/5 Votes: 27 Popularity: 6.79

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: 20,330 Rating: 4.80/5 Votes: 2 Popularity: 1.44

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

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: 29,270 Rating: 4.85/5 Votes: 6 Popularity: 3.77

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

Silverlight Application with Dispatcher and asynchronous WCF Service

Validation

Validation Controls

Enhanced Textbox Control

Posted: 26 Mar 2010 Updated: 3 Apr 2010 Views: 94,691 Rating: 4.88/5 Votes: 52 Popularity: 8.21

Licence: The Code Project Open License (CPOL) Bookmarked: 117 Downloaded: 2,476

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: 181,810 Rating: 4.72/5 Votes: 31 Popularity: 6.76

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

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: 22,551 Rating: 4.60/5 Votes: 4 Popularity: 2.77

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: 178,261 Rating: 4.31/5 Votes: 84 Popularity: 8.11

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: 20,460 Rating: 1.50/5 Votes: 3 Popularity: 0.72

Licence: The Code Project Open License (CPOL) Bookmarked: 14 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: 65,202 Rating: 4.71/5 Votes: 5 Popularity: 3.30

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: 48,594 Rating: 4.29/5 Votes: 8 Popularity: 3.96

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

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: 109,950 Rating: 4.51/5 Votes: 29 Popularity: 6.38

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: 39,880 Rating: 4.19/5 Votes: 20 Popularity: 5.35

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

Return Anonymous type

DistinctBy in Linq (Find Distinct object by Property)

Posted: 27 Jan 2013 Updated: 28 Jan 2013 Views: 192,143 Rating: 4.71/5 Votes: 13 Popularity: 5.09

Licence: The Code Project Open License (CPOL) Bookmarked: 28 Downloaded: 1,428

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: 206,381 Rating: 4.88/5 Votes: 106 Popularity: 9.80

Licence: The Code Project Open License (CPOL) Bookmarked: 188 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: 41,540 Rating: 4.25/5 Votes: 5 Popularity: 2.97

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: 75,121 Rating: 4.79/5 Votes: 23 Popularity: 6.34

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

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: 27,480 Rating: 4.60/5 Votes: 5 Popularity: 3.22

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

Responsive WCF service with ICallbackEventHandler Interface.

Threads, Processes & IPC

Multi-threading

Random Number in MultiThreading

Posted: 18 Feb 2015 Updated: 4 Mar 2015 Views: 24,112 Rating: 4.76/5 Votes: 8 Popularity: 4.30

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

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: 13,750 Rating: 4.90/5 Votes: 6 Popularity: 3.81

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: 24,191 Rating: 4.88/5 Votes: 25 Popularity: 6.83

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

Decorator Design Pattern

Flyweight Design Pattern

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

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

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: 25,321 Rating: 4.91/5 Votes: 7 Popularity: 4.14

Licence: The Code Project Open License (CPOL) Bookmarked: 17 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: 83,744 Rating: 4.86/5 Votes: 65 Popularity: 8.82

Licence: The Code Project Open License (CPOL) Bookmarked: 139 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: 115,605 Rating: 4.72/5 Votes: 29 Popularity: 6.75

Licence: The Code Project Open License (CPOL) Bookmarked: 83 Downloaded: 2,437

Publisher/Subscriber pattern with Event/Delegate and EventAggregator

Average blogs rating: 4.11

Database

SQL

Any Method [Technical Blog]

Posted: 11 Aug 2011 Updated: 11 Aug 2011 Views: 10,211 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: 70,982 Rating: 4.52/5 Votes: 19 Popularity: 5.57

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: 16,900 Rating: 0.00/5 Votes: 0 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: 35,090 Rating: 4.20/5 Votes: 4 Popularity: 2.53

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: 9,600 Rating: 0.00/5 Votes: 0 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: 31,551 Rating: 0.00/5 Votes: 0 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: 75,151 Rating: 4.70/5 Votes: 22 Popularity: 6.21

Licence: The Code Project Open License (CPOL) Bookmarked: 25 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: 89,805 Rating: 3.41/5 Votes: 8 Popularity: 3.08

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: 32,101 Rating: 0.00/5 Votes: 0 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: 69,431 Rating: 3.00/5 Votes: 2 Popularity: 0.90

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: 87,450 Rating: 4.93/5 Votes: 12 Popularity: 5.32

Licence: The Code Project Open License (CPOL) Bookmarked: 12 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: 28,290 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: 31,500 Rating: 4.00/5 Votes: 4 Popularity: 2.41

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: 14,620 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: 14,122 Rating: 4.93/5 Votes: 4 Popularity: 2.97

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: 12,301 Rating: 0.00/5 Votes: 0 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: 212,987 Rating: 4.87/5 Votes: 18 Popularity: 6.11

Licence: The Code Project Open License (CPOL) Bookmarked: 17 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: 13,900 Rating: 4.56/5 Votes: 2 Popularity: 1.37

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: 16,820 Rating: 0.00/5 Votes: 0 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: 11,980 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: 35,580 Rating: 4.60/5 Votes: 9 Popularity: 4.39

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

How to get exact location of exception in C# code

String handling

General

String Split Utility [Technical Blog]

Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 16,180 Rating: 1.40/5 Votes: 3 Popularity: 0.67

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: 8,840 Rating: 0.00/5 Votes: 0 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: 15,870 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: 12,490 Rating: 0.00/5 Votes: 0 Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 3 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: 11,021 Rating: 0.00/5 Votes: 0 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 Dynamic Type Passed to Function and Type Returned [Technical Blog]

Posted: 28 Jan 2014 Updated: 28 Jan 2014 Views: 3,750 Rating: 0.00/5 Votes: 0 Popularity: 0.00

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

Here is a misconception of dynamic type passed to function and type returned

Average tips rating: 3.98

ASP.NET

General

How to Freeze GridView Header While Scrolling ? [Tip/Trick]

Posted: 14 Mar 2010 Updated: 14 Mar 2010 Views: 30,051 Rating: 4.50/5 Votes: 8 Popularity: 4.06

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: 9,860 Rating: 1.22/5 Votes: 2 Popularity: 0.37

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: 15,050 Rating: 0.00/5 Votes: 0 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: 34,502 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: 144,872 Rating: 3.92/5 Votes: 16 Popularity: 4.61

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: 11,990 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: 65,612 Rating: 4.57/5 Votes: 20 Popularity: 5.74

Licence: The Code Project Open License (CPOL) Bookmarked: 25 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: 4,750 Rating: 0.00/5 Votes: 0 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: 13,301 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: 22,390 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: 15,520 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: 54,170 Rating: 2.72/5 Votes: 9 Popularity: 2.60

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

Make your code Speak by using C# Region

TryParse Methods [Tip/Trick]

Posted: 16 Oct 2012 Updated: 16 Oct 2012 Views: 15,691 Rating: 0.00/5 Votes: 0 Popularity: 0.00

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

TryParse Methods

Count() and Count property [Tip/Trick]

Posted: 16 Oct 2012 Updated: 16 Oct 2012 Views: 11,160 Rating: 4.75/5 Votes: 3 Popularity: 2.27

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

Count() and Count property

DateTime is immutable [Tip/Trick]

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

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

DateTime is immutable

Extending Enum to return attached string [Tip/Trick]

Posted: 25 Oct 2012 Updated: 25 Oct 2012 Views: 9,900 Rating: 2.50/5 Votes: 2 Popularity: 0.75

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

Licence: The Code Project Open License (CPOL) Bookmarked: 5 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: 25,520 Rating: 4.67/5 Votes: 2 Popularity: 1.40

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

Concat() vs Union()

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

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

Licence: The Code Project Open License (CPOL) Bookmarked: 6 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: 7,972 Rating: 0.00/5 Votes: 0 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: 25,771 Rating: 4.00/5 Votes: 5 Popularity: 2.80

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

Expression Tree

Convert DateTime string to DateTime variable [Tip/Trick]

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

Licence: The Code Project Open License (CPOL) Bookmarked: 6 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: 23,481 Rating: 3.75/5 Votes: 5 Popularity: 2.62

Licence: The Code Project Open License (CPOL) Bookmarked: 8 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: 40,360 Rating: 3.25/5 Votes: 8 Popularity: 2.94

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: 33,770 Rating: 4.45/5 Votes: 10 Popularity: 4.25

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: 15,090 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: 61,402 Rating: 4.62/5 Votes: 12 Popularity: 4.98

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: 21,441 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: 50,580 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: 21,890 Rating: 5.00/5 Votes: 5 Popularity: 3.49

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: 20,410 Rating: 3.00/5 Votes: 2 Popularity: 0.90

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: 27,660 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: 14,560 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: 8,520 Rating: 0.00/5 Votes: 0 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.

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: