Best Database Article of February 2014

This competition has ended

Overview
Entries
Participants
Winners
Prizes
Rules

Contribute to CodeProject and you'll automatically be in the running for a monthly prize!

Each month at CodeProject we gather together the best of the articles submitted the previous month and ask our readers to choose the best of the best. Entry is automatic - just submit you articke and we'll do the rest.

Check out the submission guidelines for information on posting articles.

Current Entries

Articles that match the contest criteria are automatically entered.

Extract Image Files from Database Image Data

20 Feb 2014PallavSingh

Converting data column (contains OLE db image binary Format) to image file (.jpg)

SQL

.NET

Office

ADO.NET

How-To Convert a String Collection to a Multi-Enum Item Using TryParse

14 Feb 2014BenScharbach

How-To Convert a String Collection to a Multi-Enum item using TryParse

Dequeue workitems using MERGE

25 Feb 2014Darek Danielewski

This article demonstrates how to safely dequeue items from a shared table

ADO.NET – What is Meant by SQL Injection Attack?

10 Feb 2014Arun Ramachandran India

ADO.NET - What is meant by SQL injection attack?

SQL

WCF

Tracking BSTR Memory Allocations to Find Memory Leaks

13 Feb 2014Eyal Rosner

If you are looking for memory leaks related to BSTR pointers, this tip might be very relevant for you.

To Generate XML File from Datatable using LINQ

23 Feb 2014puja11191

This tip shows how can we generate and save XML files

C#4.0

LINQ

ADO.NET

Determine the datatype for excel import

25 Feb 2014govardhan4u

Determine the datatype of a column in a Excel file in SSIS

SQL-Server

Dev

Linq-to-SQL Enums Support

11 Feb 2014harleydk

Linq-to-SQL enums support

SQL

LINQ

sql-functions for better estimation of route-distances and traveling times in pure sql (without routing)

5 Feb 2014Peter BCKR

a simple way to estimate as accurately as possible route-distances and traveling times without exact route calculation in sql

SQL

SQL-Server

Dev

Book Review: ASP.NET 4.0 in Practice

10 Feb 2014CoderPanda

Book review for "ASP.NET 4.0 in practice"

All-Topics

ADO.NET

Membership+ Management System, Part II: Account Settings

22 Mar 2014Shuqian Ying

Implementing the user account setting part of Membership+ management system.

Nested gridview Edit

25 Feb 2014JatinKhimani

Nested GridView With Editing Facility of both gridview.

Find and Fix Fragmented Indexes

5 Feb 2014Duncan Edwards Jones

Quick tip to allow you to identify indexes that could do with defragmentation

SQL

Dev

DBA

DbReaderGenerator Library

23 Feb 2014Paulo Zemek

Generate DataReaders at run-time and get the best performance by avoiding repetitive code and by using the database's most appropriate Get methods.

Converting comma separated data in a column to rows for selection

24 Feb 2014OriginalGriff

If you have an SQL column which contains a comma separated list of names, you may have wondered how to return it as individual rows in a SELECT statement. It's not too bad, really!

SQL

SQL-Server

Dev

Building a Framework - Part I (DAL)

5 Feb 2014V.

First article on creating a reusable framework

A Simple MVC Application using LINQ to SQL

8 Sep 2014Sandeep Singh Shekhawat

This article introduces how to create an MVC application using LINQ to SQL. You will create a simple MVC application for Book registration with a Publisher where the Publisher and Book have one-to-many relationships.

Export to Excel in ASP.NET C#

24 Feb 2014JatinKhimani

Export Gridview data in Excel formate with gridview design.

MSDTC Manager

20 Feb 2014Tammam Koujan

MSDTC manager

UpgradeDB

10 Nov 2014x3F

An incremental database upgrade utility for SQL Server.

VS2013

SQL-Server

Multi Column Filter GridView With Effective Paging (Searchable GridView)

25 Apr 2014sukeshchand

ASP.NET Custom GridView with multi column filter functionality

Desktop Sharing using RDP APIs and Socket

24 Nov 2015nuclear_sun

You can share a peer's desktop with any others using this software, designate the sharer and viewers in any way you can imagine. Detailed development document and user manual can be found in the Download.

IWebBrowser2 Wrapper Class

5 Mar 2014David Johns

A class that wraps the IWebBrowser2 interface of Microsoft Internet Explorer to enable you to browse, print and save web content programatically

Introducing the Data Mapper in Griffin.Framework

21 Feb 2014jgauffin

Introducing the data mapper in Griffin.Framework

Nested Repeater Editing Asp.net c#

25 Feb 2014JatinKhimani

Nested Repeater Editing in asp.net code behind c#

SQL 2012 - Newly Introduced Date and Time Functions

25 Feb 2014Jinesh Parekh

Newly introduced Date and Time functions in SQL 2012

SQL

Windows

Northwind N-Tier Blueprint Application Using WPF/WCF/LINQ to SQL

5 Feb 2014The Cool Wayfarer

A blueprint application to showcase an enterprise standard architecture using the .NET 3.5 technologies like WPF, WCF, and LINQ to SQL.

Getting Started with NoSQL and MongoDB

26 Feb 2014JonB3232

Getting Started with NoSQL and MongoDB

SQL

NoSQL

database

C# Photo Viewer with Windows Forms

16 Feb 2014puja11191

This is an extension of Photo Viewer on MSDN

.NET

ADO.NET

Current Participants

Those with articles that match the contest criteria are automatically entered.

Arun Ramachandran India

Software Developer

India

Arun Ramachandran is a Software Engineer having hands on experience in different Microsoft Technologies who is presently working in Experion Technologies, India. He has written over 95 articles on the subject on his blog at http://BestTEchnologyBlog.com. Along with 3 years of hands on experience he holds a Master of Computer Applications degree from Cochin University of Science & Technology (CUSAT).

BenScharbach

Software Developer (Senior) Image-Nexus

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

CoderPanda

Architect

India

I dabble at many things and many of them at the same time. In short, I am a jack of all trades.

I am a software engineer by profession. My current area of expertise include .net Programming, Analysis, Software Operations and Architecture. I am equally conversant with greenfield and brownfield projects.

By hobby, I am a Technology Enthusiast, Blogger, Arm chair Movie Critic and self-proclaimed Cricket Expert. I have assisted in reviewing quite a few technology books so far. Sometimes I get lucky and take nice pics when I have my D-SLR in my hand.

Hope you found my article useful.

Also check out my blogs here:
http://pandaxp.wordpress.com
http://coderpanda.blogspot.in

Darek Danielewski

Architect BI Software, Inc.

United States

A seasoned IT Professional. Programming and data processing artist. Contributor to StackOverflow.

David Johns

Web Developer

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Duncan Edwards Jones

Software Developer

Ireland

C# / SQL Server developer
Microsoft MVP (Azure) 2017
Microsoft MVP (Visual Basic) 2006, 2007

Eyal Rosner

Architect - Hewlett Packard Enterprise

Unknown

My specialities are at the area of crash dump analysis, memory leaks tracking, network traffic analysis, advanced debugging technics and software security

govardhan4u

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

harleydk

Denmark

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

JatinKhimani

Software Developer (Junior) THOMSON REUTERS

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

jgauffin

Founder 1TCompany AB

Sweden

Github | Blog | Twitter | StackOverflow

Jinesh Parekh

Software Developer (Senior)

Australia

An IT Professional with over 10 years of experience in system analysis, components design, development and testing of client server, Intranet/ Internet, N-tier systems, Have developed applications using technologies like MVC, EDMS, XML, Infopath, SQL Server 2005/2008/2012, SSIS, SSRS, Oracle, Actuate and Crystal Reports. Has excellent analytical and troubleshooting skills exhibited by efficient monitoring and support of production applications. Proven leadership and strong interpersonal and communication skills in dealing with people with diverse backgrounds

JonB3232

Software Developer Symantec

United States

I've been developing for the last few years professionally and recreationally. I'm a Software Engineer for Symantec where I develop for a few of their mainline products. My experience includes development in many spectrums of .NET including MVC, SharePoint and Azure development; as well as additional languages such as Java, Perl, HTML5 and JavaScript. I have two Microsoft certifications; one, for development in SharePoint 2010 (MCTS), and the other for programming in HTML5, JavaScript and CSS3 (MS). My interests are in cloud development and mobile development. Feel free to reach out to me for questions and/or advice.

nuclear_sun

Technical Lead student

China

I am a postgraduate student in China, I would like to absorb fresh things !

OriginalGriff

CEO

Wales

Born at an early age, he grew older. At the same time, his hair grew longer, and was tied up behind his head.
Has problems spelling the word "the".
Invented the portable cat-flap.
Currently, has not died yet. Or has he?

PallavSingh

Software Developer (Senior)

India

I am Pallav Singh working as a Sr. Software Engg. in a software Company, New Delhi since 7 years. I have created a Page in facebook & Developed a Website for those who want to develop their Programming Skills & Logics.

My Coding Community:
https://www.esoftcode.com

Facebook Page Link :
https://www.facebook.com/SoftwareCode

You can go on this page and ask any questions related to programming and logic (C#, ASP.Net, Sql Server, Oracle, Java, FoxPro, Access, Windows etc)

Paulo Zemek

Software Developer (Senior) Microsoft

United States

I started to program computers when I was 11 years old, as a hobbyist, programming in AMOS Basic and Blitz Basic for Amiga.
At 12 I had my first try with assembler, but it was too difficult at the time. Then, in the same year, I learned C and, after learning C, I was finally able to learn assembler (for Motorola 680x0).
Not sure, but probably between 12 and 13, I started to learn C++. I always programmed "in an object oriented way", but using function pointers instead of virtual methods.

At 15 I started to learn Pascal at school and to use Delphi. At 16 I started my first internship (using Delphi). At 18 I started to work professionally using C++ and since then I've developed my programming skills as a professional developer in C++ and C#, generally creating libraries that help other developers do their work easier, faster and with less errors.

Want more info or simply want to contact me?
Take a look at: http://paulozemek.azurewebsites.net/
Or e-mail me at: paulozemek@outlook.com

Codeproject MVP 2012, 2015 & 2016
Microsoft MVP 2013-2014 (in October 2014 I started working at Microsoft, so I can't be a Microsoft MVP anymore).

Peter BCKR

Software Developer (Senior)

Germany

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

puja11191

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Sandeep Singh Shekhawat

Software Developer

India

He is awarded for Microsoft TechNet Guru, CodeProject MVP and C# Corner MVP. http://l-knowtech.com/

Shuqian Ying

Founder CryptoGateway Software Inc.

Canada

His interests in software research and development include security, domain specific meta-language development technologies and tools, meta-language driven code generation, generation of non-invasive and virtual SQL database for "un-structured" data (sqlization), automated relational data service production technologies, file system sqlization technologies and products, structured multi-lingual documentation tools and technologies, sqlization of user's personal data, like emails, etc..

He was a physicist before year 2000. He studied theoretical physics (the hidden symmetry between the past and future, quantum field theories, mirror universe, cosmological dark energies etc.) in which he think to had made fundamental breakthroughs[^] but the community is either not ready for it or is actively rejecting/ignoring it Smile | :) .

It struck me on Apr. 11, 2023 that the said theory above can even generate General Relativity naturally after a recent discussion in the Insider News group that triggers a rethinking of the subject on my side. The first stage of the work is completed in Sept. 2023, it is and will be continue to be published online

On Vacuum
Quantum and Gravity

Most recent software system to share:
- V-NET[^] - Full stack virtualization management system including networking, storage, virtual machines and containers, with an emphasis on networking ... to be released.

sukeshchand

Technical Lead Soft To Rule Solutions

India

Working as a Freelance application software developer.

Tammam Koujan

Software Developer (Senior)

Germany

010011000110100101101011011001010010000001000011011011110110010001101001011011100110011100100001

The Cool Wayfarer

Software Developer (Senior)

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Software Developer

Belgium

Graduate Computer Sciences.
My interests go out to music and movies.
Author of the infamous MQOTD
Creator of this video

x3F

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

First Prize	Paulo Zemek - DbReaderGenerator Library
Prize pool	CodeProject Laptop Sleeve - CodeProject


Second Prize	Sandeep Singh Shekhawat - A Simple MVC Application using LINQ to SQL
Prize pool	Bob Sticker - CodeProject

Contest Entries and Requirements

The contest period covers the the first day of the month 12AM US Eastern Standard Time and ends the final day of the month at 11:59:59 PM US Eastern Standard Time. All entries must be submitted during this period in order to qualify.
Entries must be an article, or blog entry.
With the exception of the Everything Else category, the article must be tagged with at least one of the tags corresponding to that competition's category (for example, to enter the C# Competition you would need to tag your article with a C# tag).
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
Articles may only be considered for a single category. If an article is eligible for multiple categories (for example, it pertains to both the C# and Web Dev categories), CodeProject editors and judges will decide which category the article shall be entered in.
No author can be nominated twice in the same category.
If an author writes has two separate articles, each article may be considered in their respective categories provided none of the aforementioned rules are broken. For example, if an author wrote two separate articles, one related to C# and one related to VB.NET, the author and articles could be nominated in the C# and VB.NET competitions, respectively.
In the event an author wins multiple competitions, and repeat, identical prizes, the number of prizes issued is solely at the discretion of the prize issuer.
Multiple votes from the same IP will be automatically disqualified.
The judges’ decision is final and no correspondence will be entered into.
Only those who live in jurisdictions in which this contest is legal may enter.
Any breach of the rules and the prize will be awarded to the runner up.
By entering the contest you agree to the rules, conditions of entry, and agree that your member alias and any submitted material can be used for promotional purposes by CodeProject.
Entries shall be deemed to be submitted by the authorized account holder of the email address submitted at the time of entry unless clearly indicated otherwise. "Authorized account holder" is defined as the natural person who is assigned to an email address by an internet access provider, on-line service provider, or other organization (e.g. business, educational institution, etc.) that is responsible for assigning email addresses for the domain associated with the submitted email address.

Eligibility

This competition is open to software development professionals & enthusiasts who are of the age of majority in their jurisdiction of residence; however, residents of Quebec and of the following countries are ineligible to participate due to legal constraints: Cuba, Iran, Iraq, Libya, North Korea, Sudan, and Syria. Employees (or a member of their immediate family) of CodeProject or any of their affiliates, subsidiaries, advertising or promotional agencies are also ineligible to participate. Void where prohibited by law.

How to Enter

Entry is by the submission process described above. Please read the submission requirements before submitting your entry and ensure the article is tagged with at least one of the tags corresponding to that competition's category.

Lost, late, misdirected, or illegible entries will be disqualified. Any entry containing content that CodeProject deems objectionable for any reason will be disqualified. All decisions of CodeProject with respect to any aspect of the competition, including, without limitation, the eligibility of entries, are final and binding on all entrants in all matters as they relate to this competition. CodeProject reserves its right to modify the Rules.

CodeProject assumes no responsibility for lost, late, delayed, destroyed or misdirected mail, voice messages, email or any computer errors or malfunctions. No correspondence will be entered into with entrants.

CodeProject does not assume any responsibility for incorrect or inaccurate capture of entry information, technical malfunctions, human or technical error, lost, delayed or garbled data or transmissions, omission, interruption, deletion, defect or failures of any telephone or computer line or network, computer equipment, software or any combination thereof. Entry materials/data that have been tampered with or altered are void. If for any reason, in the opinion of CodeProject in its sole discretion, the competition is not capable of running as originally planned, or if the administration, security, fairness, integrity or the proper conduct of the competition is corrupted or adversely affected, including by reason of infection by computer virus, bugs, tampering, unauthorized intervention, fraud, technical failures or any other causes beyond its control, CodeProject reserves its right to cancel, terminate, modify, amend, extend or suspend the competition including cancelling any method of entry, and select a winner from previously received eligible entries. CodeProject reserves its right in its sole discretion to disqualify any individual it finds to be tampering with the entry process or the operation of the competition or to be acting in violation of the Rules or otherwise in a disruptive manner. CodeProject reserves its right to seek remedies and damages to the fullest extent of the law for any attempts to deliberately damage the competition web site or to undermine the legitimate operation of this competition. CodeProject shall not be held responsible for any errors or negligence that may arise or occur in connection with the competition including any damage to an entrant's computer equipment, system, software or any combination thereof, as a result of their participation in this competition or from downloading any material from the competition website where applicable.