Click here to Skip to main content
15,901,122 members
This competition has ended

Best Database Article of May 2015

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.

Please Sign up or sign in to vote.
14 May 2015DaveMathews
Using SIML, a language designed for Digital Assistants, to create a Natural Language Interface to an SQL database.
Please Sign up or sign in to vote.
27 May 2015syed shanu
MVC, AngularJS and WCF Rest Service for Master / Detail HTML Grid
Please Sign up or sign in to vote.
7 May 2015Mr. xieguigang 谢桂纲
You see, this small utility tool save much of your time, this is another happy day! I hope you can enjoyed this code.
Please Sign up or sign in to vote.
13 May 2015essentialSQL
This is a case study on how to use Joins, Subqueries, and Unions to combine data in SQL.
Please Sign up or sign in to vote.
21 May 2015Anele 'Mashy' Mbanga
Exploring the source code behind the offline CodeProject article writer CodeProject.Show.
Please Sign up or sign in to vote.
15 May 2015Anele 'Mashy' Mbanga
Create JQuery Mobile Apps with JQM.Show on your PC with these tools.
Please Sign up or sign in to vote.
1 May 2015Avinash Narnaware
Rename file using MS sql server using xp_cmdshell rename, while file name contain space. Get All file Details in MS Sqlserver 2008 using xp_getfiledetails.
Please Sign up or sign in to vote.
10 May 2015Ankit Bansal MVP
This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.
Please Sign up or sign in to vote.
29 May 2015Asanka Perera
This process can be set up to run on a daily basis to make sure that reports which are interrelated does reconcile with each other, in order to make sure the consistency in report quality.
5 May 2015Tomasz Naumowicz
Take a closer look at scenarios where working with GUID and UUID in a MongoDB environment becomes tricky. We will make you aware of those configurations and provide a set of best practices to follow.
Please Sign up or sign in to vote.
19 May 2015Rami Sayar
In this installment, I will show you how to use your existing express-based Node.js app to create a chatroom backend with WebSocket support.
Please Sign up or sign in to vote.
2 May 2015GhalebBadran
Before starting I want to wish you all a happy labor day :) Overview Building a report on SQL Server Reporting Services (SSRS) is very easy and fast, and it has the most important features to create a very professional business reports that covers the needs.
Please Sign up or sign in to vote.
1 May 2015Intel
In this 2-part series, we will take a look at how these APIs were used in a sample restaurant Android app, providing a seamless user experience.
Please Sign up or sign in to vote.
11 May 2015Sifiso W Ndlovu
XML Document Sourced SSRS Report Using HTTP URL
Please Sign up or sign in to vote.
21 May 2015wkiess01
A work-around to calculate the sum of a multivalue attribute in a secondary D3 file
Please Sign up or sign in to vote.
4 May 2015tanmoysarkar
How to use SMTP Port and Custom Pipeline Component to send Formatted Email Messages to concerned users
Please Sign up or sign in to vote.
26 May 2015CRMcoaching
In this article I will demonstrate an advanced topic that can improve bussiness processes that start in one CRM and continue in another CRM.
Please Sign up or sign in to vote.
25 May 2015César de Souza
Explore your data using statistical distributions: explore, initialize, create, estimate and use statistical distributions from the Accord.NET Framework using an application based entirely on reflection.
Please Sign up or sign in to vote.
20 May 2015Anele 'Mashy' Mbanga
Write your next CodeProject article using CodeProject.Show, a WinForms application
Please Sign up or sign in to vote.
1 Mar 2016Akhil Mittal
My article will explain how we can make our Web API service architecture loosely coupled and more flexible.
Please Sign up or sign in to vote.
1 Mar 2016Akhil Mittal
Enterprise level application architecture with Web APIs using Entity Framework, Generic Repository pattern and Unit of Work.
Please Sign up or sign in to vote.
8 Jul 2015syed shanu
How to use AngularJs Filter, AngularJs Sort, AngularJs Animation, Image Mouse Over and Mouse Out Event
Please Sign up or sign in to vote.
21 May 2015King Fisher
To search data in multiple columns using 'IN' clause
Please Sign up or sign in to vote.
26 Jan 2016syed shanu
Use AngularJS and WCF Rest Service to create a simple Online Shopping Cart
Please Sign up or sign in to vote.
5 May 2015Sandeep Kumar Tripathi
This tip is used for creating SSRS Report Subscription by using C#.
Please Sign up or sign in to vote.
4 May 2015Sibeesh Passion
This article shows how to check whether a Measure Group is mapped with the Dimension Group.
Please Sign up or sign in to vote.
16 May 2015mitchellguzman
Create your common Insert, Delete, Update and Select stored procedures on a single table
Please Sign up or sign in to vote.
25 May 2015Acharya Raja Sekhar
This tool helps in cloning/copying the database from a source environment/server to a target server (usually developers can use it for setting up local DB with production code)
Please Sign up or sign in to vote.
28 May 2015koolprasad2003
This tip explains how to use Word Automation using OpenXML and C# without Word Interop.
Please Sign up or sign in to vote.
7 May 2015Praveen_Kumar Gupta
Clone Existing DB Schema to New Schema by plpgsql in PostgreSQL
Please Sign up or sign in to vote.
19 May 2015Rojalin Sahoo
Creating dynamic grid-view worked like an Excel sheet
Please Sign up or sign in to vote.
17 May 2015Sifiso W Ndlovu
IntroductionThe post, XML Document Sourced SSRS Report Using HTTP URL, demonstrated how a SQL Server Reporting Services (SSRS) data source can be used to reference an Extensible Markup Language (XML) document located via Hypertext Transfer Protocol (HTTP) protocol-based URL.
Please Sign up or sign in to vote.
24 May 2015Anele 'Mashy' Mbanga
Using IndexedDB as a backend for your JQuery Mobile App
Please Sign up or sign in to vote.
26 May 2015Cindy Potvin
Saving an image in a SQLite database in your Android application
Please Sign up or sign in to vote.
6 May 2015MarcusCole6833
Visual Basic SQL to XML
Please Sign up or sign in to vote.
8 May 2015rahulsahay20
ASP.NET 5 Features - Part 1
Please Sign up or sign in to vote.
7 May 2015Val Okafor
In this blog post, I discuss how to convert Android View to PDF.
Please Sign up or sign in to vote.
6 May 2015Jamie Munro
MySQL: insert or update in one SQL statement

Current Participants

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

Software Developer Motherson Sumi INfotech and Designs Limited
India India
I'm Graduated with B.Tech in Information Technology at year of 2012.
2013'June-2015'June :Worked as Web Developer in Avail Technologies, Madurai
2015 -till Date :Working as software Engineer in Motherson Sumi INfotech and Designs Limited,Chennai
Technical Skill : Sql Server, C#, JavaScript, Jquery, Asp.Net

நெஞ்சு பொறுக்கு திலையே-இந்த
நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

This is a Social Group

16 members
Software Developer (Senior)
India India
Working as a Senior Developer in an MNC with 3+ years of experience in .Net related technologies. Passionate about programming and software architecture.
India India
Akhil Mittal is two times Microsoft MVP (Most Valuable Professional) firstly awarded in 2016 and continued in 2017 in Visual Studio and Technologies category, C# Corner MVP since 2013, Code Project MVP since 2014, a blogger, author and likes to write/read technical articles, blogs, and books. Akhil is a technical architect and loves to work on complex business problems and cutting-edge technologies. He has an experience of around 15 years in developing, designing, and architecting enterprises level applications primarily in Microsoft Technologies. He has diverse experience in working on cutting-edge technologies that include Microsoft Stack, AI, Machine Learning, and Cloud computing. Akhil is an MCP (Microsoft Certified Professional) in Web Applications and Dot Net Framework.
Visit Akhil Mittal’s personal blog CodeTeddy (CodeTeddy ) for some good and informative articles. Following are some tech certifications that Akhil cleared,
• AZ-304: Microsoft Azure Architect Design.
• AZ-303: Microsoft Azure Architect Technologies.
• AZ-900: Microsoft Azure Fundamentals.
• Microsoft MCTS (70-528) Certified Programmer.
• Microsoft MCTS (70-536) Certified Programmer.
• Microsoft MCTS (70-515) Certified Programmer.

This is a Collaborative Group

780 members
South Africa South Africa
I'm a Bachelor of Commerce graduate, fell inlove with ICT years back with VB5. Used Pick & System Builder to create a windows app. Very curious, developed my first web database app called Project.Show using ExtJS. Published on Google Play Store, learned JQuery Mobile, a project manager at best. My first intranet app eFas with MySQL.

Fear closes people to a lot of things and we hold ourselves back being held by it. Thus the sooner you believe you can't do something, the sooner everything will work towards that belief. Believe in yourself at all times because you can do anything you set your mind to it!

I have a very beautiful woman and four kids, the best joys in the world. East London, South Africa is currently home.


Best Mobile Article of February 2015 (First Prize)

Best Mobile Article of May 2015 (Second Prize)

Bible.Show (Android Store App)

JQM.Show (Android Store App)

CodeProject.Show (An offline CodeProject Article writer)
Software Developer HCL Technologies Ltd.
India India
I am a software developer. I have working on .NET Technology for a long time and still learning and sharing.
Software Developer
Sri Lanka Sri Lanka
Software engineer with 3+ years of experience in the IT industry working for reputed local and international companies. Currently pursing a career in Data Warehouse and Business Intelligence field while having special interests in the areas of Pattern Recognition, Bioinformatics and Statistical Data Analysis. Reading for Msc in Data Science, Engineering and Analytic at University of Moratuwa - Sri Lanka.
Product Manager GENPACT
India India
Working as Product Manager in GENPACT. Very much passionate about coding. Good exposure in salesforce technology. Total 9 year experience in IT programming. Mostly worked over Sale cloud, Service Cloud. Proficient in Salesforce Lightning, Apex class, trigger, OOB functionality, Apex Batch Class, API integration(REST and SOAP). Have Admin, SalesforcePlatform Developer 1 and Salesforce Platform Developer 2 certified developer.
Engineer NAVER LABS Europe
France France
Computer and technology enthusiast, interested in artificial intelligence and image processing. Has a Master's degree on Computer Science specialized on Image and Signal Processing, with expertise on Machine Learning, Computer Vision, Pattern Recognition and Data Mining systems. Author of the Accord.NET Framework for developing scientific computing applications.

If you would like to hire good developers to build your dream application, please check out DaitanGroup, one of the top outsourcing companies in Brazil. This company, located in Brazil's Sillicon Valley but with US-based offices, has huge experience developing telecommunications software for large and small companies worldwide.
Canada Canada
Cindy Potvin is a software developer based in the Montreal area. At her day job, she creates web applications using the ASP.NET MVC framework and mobile applications using the Android SDK.
Software Developer (Senior)
Israel Israel
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior)
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Easy Computer Academy, LLC
United States United States
Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here
Software Developer (Senior)
United Arab Emirates United Arab Emirates
United States United States
You may know us for our processors. But we do so much more. Intel invents at the boundaries of technology to make amazing experiences possible for business and society, and for every person on Earth.

Harnessing the capability of the cloud, the ubiquity of the Internet of Things, the latest advances in memory and programmable solutions, and the promise of always-on 5G connectivity, Intel is disrupting industries and solving global challenges. Leading on policy, diversity, inclusion, education and sustainability, we create value for our stockholders, customers and society.
This is a Organisation

42 members
Software Developer (Senior)
Canada Canada
I am the author of five books: ASP.NET MVC 5 with Bootstrap and Knockout.js, Knockout.js: Building Dynamic Client-Side Web Applications, 20 Recipes for Programming PhoneGap, 20 Recipes for Programming MVC 3, and Rapid Application Development with CakePHP.

I enjoy reading and writing and I like to blog as much as I can on my personal blog EndYourIf.

I'm a father of three kids, twins (boy and a girl) and another baby girl.
Technical Lead
India India
Hi there, I am Prasad. Author, Blogger, contributor and passionate about Microsoft .NET technologies. I like to write an articles/blogs on different .NET aspects and like to help Developers, to resolve their issues and boost them on Microsoft Technologies.

Certifications: Microsoft Certified professional (MCP), Microsoft Certified technology specialist (MCTS), Agile-Scrum Master.

Awards: Microsoft Re-connect MVP (GSC Member), Most valuable member at dotnetspider, Most popular curator, Most active curator, featured curator at Microsoft Curah, Editor at dotnetspider.

Microsoft MVP 2014 [ASP.NET/IIS]
Click here for more .NET Tips
-After all Knowledge is an endless entity
Software Developer (Junior) ABB
United States United States
On career 2.0 mainly work in the dot net environment predominantly SQL and SSMS.
Software Developer (Senior)
Iran (Islamic Republic of) Iran (Islamic Republic of)
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Database Developer PCM
United States United States
I've been programmer for over 18 years.
Technical Lead PANOMIX
China China
He is good and loves VisualBasic! Senior data scientist at PANOMIX

Software Developer
Sri Lanka Sri Lanka
I am a professional developer with a working experience in .NET (VB and C#, WinForms, MVC, Entity Framework, SharePoint), JavaScript, SAP development and SQL Server.
Software Developer (Senior)
India India
I am Praveen, a passionate software developer.
Actively seeking for new opportunities. Please feel free to contact me via my mail.

I'm working with Microsoft Technology [ C#]
I'm building websites, web Applications, API ,SPA,
mobile applications and desktop software.
Architect Publicis Sapient
India India
Hey there, it's Rahul Sahay! I'm thrilled to be a platform specialist at Publicis Sapient, where I get to work on some exciting projects. I've been honing my skills in various aspects of the software development life cycle for more than 15 years, with a primary focus on web stack development. I've been fortunate to have contributed to numerous software development initiatives, ranging from client applications to web services and websites. Additionally, I enjoy crafting application architecture from scratch, and I've spent most of my time writing platform agnostic and cloud agnostic code. As a self-proclaimed code junkie, software development is more than just a job to me; it's a passion! And I consider myself lucky to have worked with an array of cutting-edge technologies, from .NetCore to SpringBoot 3, from Angular to React, and from Azure to AWS and many more cousin technologies...

- 🔭 I’m currently working @ below tech stacks
- Microservices,
- Distributed Systems,
- Spring Boot
- Spring Cloud
- System Design,
- Docker,
- Kubernetes,
- Message Queues,
- ELK Stack
- DotNetCore,
- Angular,
- Azure

- 💬 Ask me anything about my articles [My View](
- 📫 How to reach me: [@rahulsahay19](
- 📫 Github: [@rahulsahay19](
United States United States
Rami Sayar is a technical evangelist at Microsoft Canada focusing on web development (JavaScript, AngularJS, Node.js, HTML5, CSS3, D3.js, Backbone.js, Babylon.js), open data and open source technologies (Python, PHP, Java, Android, Linux, etc.) Read his blog or follow him @ramisayar on Twitter.
Software Developer ComputoIT Solutions Pvt. Ltd.
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior) R1 RCM Pvt. Ltd.
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
Germany Germany
I am Sibeesh Venu, an engineer by profession and writer by passion. I’m neither an expert nor a guru. I have been awarded Microsoft MVP 3 times, C# Corner MVP 5 times, DZone MVB. I always love to learn new technologies, and I strongly believe that the one who stops learning is old.

My Blog: Sibeesh Passion
My Website: Sibeesh Venu
Technical Lead select SIFISO
South Africa South Africa
Sifiso W. Ndlovu is a certified Microsoft professional who holds a Master’s degree in IT Management from the University of Johannesburg. He specializes on a range of enterprise and consumer technologies using open source and proprietary software. He is the member of the Johannesburg SQL User Group wherein he has made several presentations on User Group Meetings and SQL Saturday sessions. He has written for a number of publications including and
Team Leader
India India
Microsoft MVP | Code Project MVP | CSharp Corner MVP | Author | Blogger and always happy to Share what he knows to others. MyBlog

My Interview on Microsoft TechNet Wiki Ninja Link
Software Developer (Senior)
India India
my name is Tanmoy Sarkar. I am currently working as a BizTalk developer.
United Kingdom United Kingdom
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior)
United States United States
My name is Val Okafor, I am a Senior Software Engineer with specialization in Android Development. Learning and problem solving is my passion and I share my Android development knowledge through my blog

My Android courses are the courses I wish I had when I started. I teach Android development in the context of a fully developed Android app. I believe that new Android concepts are better understood if they are presented in the context of creating an app from scratch to finish.

I focus on creating Productivity Android apps and besides Android development I have 7 years’ experience as System Administrator supporting Enterprise applications and 2 years’ experience as a Web Developer building websites using PHP and ASP.Net.

I have worked for corporations such as The Home Depot, American Council on Exercise, Legend3D and HD Supply, Inc. I have a bachelor's degree in Information Technology from National University San Diego, California and a master's degree in Software Engineering from Regis University Denver, Colorado.

I enjoy sharing my extensive work experience through my blog, social media.
SA Police Super
Australia Australia
I have always been interested in electronics and computers. I built my own C/PM micro system as a teenager and progressed from there to the System80, C64 and finally the PC. I've been a programmer and analyst for most of my working life in private and government employment, using languages based on BASIC and C. Most of my career was spent as a Senior Systems Analyst using PICK, Universe, D3 and VB6. I am now working in C#, .NET4 and SQL Server 2008/2012, but still keeping in touch with D3 (PICK).
Although I spend most of my time in a Windows (7 & 2008) environment, I also have a bit of a Unix background and dabble in a bit of LINUX here and there.
I'm currently the Manager IT at SA Police Super where I look after all their IT needs. I'll probably be here until I retire. So much to do...

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. In the event an article has multiple authors and/or contributors, the number of prizes issued is solely at the discretion of the prize issuer.
  11. In the event of a tie, the number of prizes issued is solely at the discretion of the prize issuer.
  12. Multiple votes from the same IP will be automatically disqualified.
  13. The judges’ decision is final and no correspondence will be entered into.
  14. Only those who live in jurisdictions in which this contest is legal may enter.
  15. Any breach of the rules and the prize will be awarded to the runner up.
  16. 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.
  17. 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.


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 May - 31 May 2015