Click here to Skip to main content
14,302,925 members

Best Database Article of February 2014

This competition has ended

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.

20 Feb 2014
PallavSingh
Converting data column (contains OLE db image binary Format) to image file (.jpg)
14 Feb 2014
BenScharbach
How-To Convert a String Collection to a Multi-Enum item using TryParse
25 Feb 2014
Darek Danielewski
This article demonstrates how to safely dequeue items from a shared table
13 Feb 2014
Eyal Rosner
If you are looking for memory leaks related to BSTR pointers, this tip might be very relevant for you.
11 Feb 2014
harleydk
Linq-to-SQL enums support
23 Feb 2014
puja11191
This tip shows how can we generate and save XML files
25 Feb 2014
govardhan4u
Determine the datatype of a column in a Excel file in SSIS
22 Mar 2014
Shuqian Ying
Implementing the user account setting part of Membership+ management system.
24 Feb 2014
JatinKhimani
Export Gridview data in Excel formate with gridview design.
25 Feb 2014
JatinKhimani
Nested GridView With Editing Facility of both gridview.
5 Feb 2014
Duncan Edwards Jones
Quick tip to allow you to identify indexes that could do with defragmentation
23 Feb 2014
Paulo 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.
18 Jun 2018
Dan Letecky
Weekly HTML5 event calendar with CSS themes, drag and drop support, date navigator. PHP/AJAX and ASP.NET MVC backends.
24 Feb 2014
OriginalGriff
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!
5 Feb 2014
V.
First article on creating a reusable framework
8 Sep 2014
Sandeep 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.
20 Feb 2014
Tammam Koujan
MSDTC manager
10 Nov 2014
x3F
An incremental database upgrade utility for SQL Server.
25 Apr 2014
sukeshchand
ASP.NET Custom GridView with multi column filter functionality
24 Nov 2015
nuclear_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.
5 Mar 2014
David Johns
A class that wraps the IWebBrowser2 interface of Microsoft Internet Explorer to enable you to browse, print and save web content programatically
21 Feb 2014
jgauffin
Introducing the data mapper in Griffin.Framework
25 Feb 2014
JatinKhimani
Nested Repeater Editing in asp.net code behind c#
25 Feb 2014
Jinesh Parekh
Newly introduced Date and Time functions in SQL 2012
5 Feb 2014
The Cool Wayfarer
A blueprint application to showcase an enterprise standard architecture using the .NET 3.5 technologies like WPF, WCF, and LINQ to SQL.
26 Feb 2014
JonB3232
Getting Started with NoSQL and MongoDB
16 Feb 2014
puja11191
This is an extension of Photo Viewer on MSDN
5 Feb 2014
Peter BCKR
a simple way to estimate as accurately as possible route-distances and traveling times without exact route calculation in sql
10 Feb 2014
CoderPanda
Book review for "ASP.NET 4.0 in practice"

Current Participants

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

BenScharbach
Software Developer (Senior) Image-Nexus
United States United States
No Biography provided
CoderPanda
Architect
India 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
Dan Letecky
Czech Republic Czech Republic
Darek Danielewski
Architect BI Software, Inc.
United States United States
A seasoned IT Professional. Programming and data processing artist. Contributor to StackOverflow.
David Johns
Web Developer
United States United States
No Biography provided
Duncan Edwards Jones
Software Developer (Senior)
Ireland 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 United States
No Biography provided
harleydk
Denmark Denmark
No Biography provided
JatinKhimani
Software Developer (Junior) THOMSON REUTERS
India India
No Biography provided
jgauffin
Founder 1TCompany AB
Sweden Sweden
Jinesh Parekh
Software Developer (Senior)
Australia 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 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 China
I am a postgraduate student in China, I would like to absorb fresh things !
OriginalGriff
CEO
Wales 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 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) Niantic
United States 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 Germany
No Biography provided
puja11191
United States United States
No Biography provided
Sandeep Singh Shekhawat
Software Developer
India 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 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 likes to use distributed code version control system to manage codes. For that reason, a tool to manage git repository forest (related git repositories) was even developed internally.


He was a physist 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 | :) .







Most recent free tools to share:



  • V-NET[^] - connects you devices anywhere on the internet. Voice/video chat, multicase, monitoring and file transfer, private networking, etc..
sukeshchand
Technical Lead Soft To Rule Solutions
India India
Working as a Freelance application software developer.
Tammam Koujan
Software Developer (Senior)
Syrian Arab Republic Syrian Arab Republic
010011000110100101101011011001010010000001000011011011110110010001101001011011100110011100100001
The Cool Wayfarer
Software Developer (Senior)
India India
No Biography provided
V.
Software Developer
Belgium Belgium
Graduate Computer Sciences.
My interests go out to music and movies.
Author of the infamous MQOTD
Creator of this video

Owner of VMA Guitars
x3F
United States United States
No Biography provided

Contest Entries and Requirements

  1. 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.
  2. Entries must be an article, or blog entry.
  3. 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).
  4. Articles entries must follow the CodeProject submission guidelines.
  5. No cheating, lying, plagiarizing articles, chicanery, or kicking.
  6. 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.
  7. No author can be nominated twice in the same category.
  8. 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.
  9. 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.
  10. Multiple votes from the same IP will be automatically disqualified.
  11. The judges’ decision is final and no correspondence will be entered into.
  12. Only those who live in jurisdictions in which this contest is legal may enter.
  13. Any breach of the rules and the prize will be awarded to the runner up.
  14. 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.
  15. 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.

You must sign in to participate in this contest.
This contest has ended.
1 Feb - 28 Feb 2014