Click here to Skip to main content
14,921,361 members
This competition has ended

Best Database Article of March 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. The top 50 entries are shown.

Please Sign up or sign in to vote.
28 Mar 2015
Anele 'Mashy' Mbanga
Demonstrates how to use SQLite database for mobile development
Please Sign up or sign in to vote.
17 Mar 2015
Sergey Kizyan
This article explains how to merge your local SQL DB content to Azure DB from scratch
Please Sign up or sign in to vote.
24 Mar 2015
Matt Perdeck
Add a database to your web site on AWS with automatic fail over using RDS
Please Sign up or sign in to vote.
13 Mar 2015
Gaurav Aroraa
Introduction In these days RAD (Rapid Application Development) is growing at its large. There are numerous framework available to develop Web Applications or Web Projects. We can use either ASP.Net or ASP.Net MVC from Microsoft or any other framework. Although, NancyFx is having its own support for
Please Sign up or sign in to vote.
19 Mar 2015
JammoD87
Using Dynamic SQL to create a Pivot Table
Please Sign up or sign in to vote.
12 Mar 2015
Graham D Smith
Continuous Delivery with VSO: Configuring the Basics
Please Sign up or sign in to vote.
12 Mar 2015
TarikHuber
SQL Table Toolkit is a Class Library offering a quite large amount of tools for fast and easy work with SQL Tables
Please Sign up or sign in to vote.
24 Mar 2015
SMPS LLC
With this tip, you can show a map in your WinForm application with the Google Maps API v3.
Please Sign up or sign in to vote.
9 Jun 2015
Freek Kootstra
This is a project to control the modelcars on a vintage toy car track using an Arduino and a Windows Azure service.
Please Sign up or sign in to vote.
21 Mar 2015
Anele 'Mashy' Mbanga
Demonstrates creating, updating, deleting single file json records in a web server using jQuery Mobile and Php.
Please Sign up or sign in to vote.
27 Apr 2015
Jörgen Andersson
A high performance extension for creating a DataTable from a Generic collection.
Please Sign up or sign in to vote.
9 Mar 2015
sunhui
Integrate .NET Component to your Native MFC Application at runtime
Please Sign up or sign in to vote.
3 Mar 2015
Anele 'Mashy' Mbanga
Storing and retrieving encrypted passwords on LocalStorage using Standord Crypto Library
Please Sign up or sign in to vote.
9 Mar 2015
Peter Moore - Chicago
By writing your own Virtual File System with a little C++, you can escape ApplicationData.LocalFolder and read and write databases in any folder your app has access to.
Please Sign up or sign in to vote.
11 Apr 2015
Afzaal Ahmad Zeeshan
This article is for beginners about writing and reading Unicode data from different data sources; including text files, user input, databases. It also demonstrates how to display that data in .NET applications, including ASP.NET web applications.
Please Sign up or sign in to vote.
11 Mar 2015
John C Rayan
An insight into date and time types in SQL SERVER -
Please Sign up or sign in to vote.
31 Mar 2015
Naren Neelamegam
Building robots from the scratch with speech recognition, remote voice control, learning intelligence with Raspberry PI, Intel Galileo and Microsoft Azure.
Please Sign up or sign in to vote.
6 Mar 2015
Chris_Riley
Klocwork is kind of like my code spell check, or professional editor. It just makes me sound good. And if I were part of a larger dev team it would be quite a powerful management tool.
Please Sign up or sign in to vote.
9 Mar 2015
bob.bumsuk.lee
Web app that manages customer complaints and demonstrate how to use Web API, SignalR and AngularJS technologies
Please Sign up or sign in to vote.
16 Mar 2015
Passion4Code
This post covers everything about SQL - getting started
Please Sign up or sign in to vote.
9 Jan 2017
Dan Letecky
Day/week AngularJS event calendar/scheduler with drag and drop support. PHP and ASP.NET MVC backends.
Please Sign up or sign in to vote.
8 Mar 2015
Afzaal Ahmad Zeeshan
This article contains a basic overview of the complex numbers, and their creation and functions most specifically the operator overloading for arithmetic functions. Programming languages include Java, C++, C# and VB.NET at the moment.
Please Sign up or sign in to vote.
4 Mar 2015
DiponRoy
Table Hierarchy or Generation Finder For Relational Database In SQL Server
Please Sign up or sign in to vote.
3 Mar 2015
Anele 'Mashy' Mbanga
MyFamily.Show : A simple Family Tree Mobile App to keep details of your family tree.
Please Sign up or sign in to vote.
5 Mar 2015
65Goat
This contest submission is for a home monitoring solution that reads temperature, humidity and states from various sensors around a home. The data is stored in Azure and can be accessed via mobile devices.
Please Sign up or sign in to vote.
3 Mar 2015
IAndreev93
Very Simply MySQL Viewer with Swing GUI written in NetBeans IDE using GUI Builder
Please Sign up or sign in to vote.
3 Mar 2015
Soufiane Rabhi
What you have to know about ADO.NET and Entity Framework
Please Sign up or sign in to vote.
25 Jul 2016
yuvalsol
Helper class to mitigate working with Dapper against SQL Server database
Please Sign up or sign in to vote.
5 Mar 2015
db_developer
1 alternative  
Reminder.Sou...
Please Sign up or sign in to vote.
23 Mar 2015
TarikHuber
Easy and fast integration of a TreeView menu using STT, with permission management and form opening in a tabcontrol.
Please Sign up or sign in to vote.
8 Mar 2015
Anele 'Mashy' Mbanga
Create a SplitView / Master Details screen in JQuery Mobile
Please Sign up or sign in to vote.
16 Mar 2015
Pankil Bhatt
In this tip, we will see how to use the Google Maps API and Google Maps with custom styles and a custom pin.
Please Sign up or sign in to vote.
30 Mar 2015
Evgeny Bestfator
Sometimes for processing rowsets we need a cursor, but we may not use standard cursor, we can create our pseudo cursor with much more simple syntax...
Please Sign up or sign in to vote.
10 Mar 2015
Jignesh G Trivedi
This tip will help you to understand CLR procedure.
Please Sign up or sign in to vote.
14 Mar 2015
Gaurav_Chaudhary
This tip is a brief introduction to Apply operator in SQL server
Please Sign up or sign in to vote.
22 Mar 2015
Aby Mammen Mathew
IoT devices needs the capability to augment the environment around them, even when sensors utilized by them break down
Please Sign up or sign in to vote.
5 Mar 2015
DotNetForAll
The tip describes how the Table Valued Parameters(TVP) are used in SQl server and how they can be utilized using C# code.
Please Sign up or sign in to vote.
1 Mar 2015
CarNet-India
CarNet is a project which involves creation of an mesh network between vehicles moving in vicinity of each other.
Please Sign up or sign in to vote.
29 Mar 2015
Manoj K Bhoir
Lookup web user control with some basic properties and functionalities
Please Sign up or sign in to vote.
27 Mar 2015
Shivangi_K
SQL injections and their prevention
Please Sign up or sign in to vote.
19 Mar 2015
Nadir Muhammed
Creating an RDLC report by just binding a Dataset
Please Sign up or sign in to vote.
20 Mar 2015
Sarathi Balakrishnan
Remove duplicate files with same file content, even with different file name using FILETABLE with simple CTE.
Please Sign up or sign in to vote.
23 Mar 2015
Satish Jagtap
This article explains how to import database to MySQL server and how to export database from MySQL server.
Please Sign up or sign in to vote.
5 Mar 2015
RiniBoo
Run all .sql files in a directory with results returned showing execution being successful or failure
Please Sign up or sign in to vote.
4 Mar 2015
IAndreev93
Very Simply MDB/ACCDB Viewer with Swing GUI written in NetBeans IDE using GUI Builder
Please Sign up or sign in to vote.
16 Mar 2015
Suffyan Asad
Implementing joins in Hadoop Map-Reduce applications during Map-phase using MapFiles
Please Sign up or sign in to vote.
20 Mar 2015
furytrader
Yes, Virginia, You Can Do This All With One Simple SQL Statement
Please Sign up or sign in to vote.
13 Mar 2015
Rajesh Manjarekar
When CDC is turned ON against a table and the underlying table schema changes, such as adding/removing a column, changing datatype etc
Please Sign up or sign in to vote.
27 Mar 2015
Member 11459717
An application used to manage applications which are categorized by functionality which also prioritizes tasks necessary to manage a household. The application is back-end managed, controlled and operated through Microsoft's Azure cloud platform.
Please Sign up or sign in to vote.
7 Mar 2015
IAndreev93
Standard functions usage, and my own functions... Allowing you simpler process tables... Date and time... Strings...

Current Participants

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

DiponRoy
Bangladesh Bangladesh
No Biography provided
Manoj K Bhoir
Software Developer
India India
It always seems good to hear about me, but the thing I do is I code. I'm Interested in Designing Windows Based Application, Web Applications and building Mobile Applications. Currently restricting it to Android 4.0 applications, building Internet Based Applications using ASP.NET and contributing to bring the student community to a position which will help technology to reach the greatest heights ever. A very Big fan of Microsoft & Android..!!
65Goat
Architect Terminal Solutions
United States United States
I have recently changed direction in my career and am focusing, once again, on software development. I have over 30 years experience in the software industry. 19 of those years at Microsoft Corporation in many different technical roles. I have a B.S. in computer science from Valparaiso University and deep experience with Object Orientated design and development.

My recent passion revolves around IofT and how this technology can fundamentally change how business understand and react to their competitive landscape.
Aby Mammen Mathew
Architect MLI Dynamics
United States United States
I am interested in distributed computing and architectures. Pretty much like elegant and simple solutions to complex problems.

If you have questions, please feel to reach me at abymmathew@hotmail.com
Afzaal Ahmad Zeeshan
Software Developer
Pakistan Pakistan
Afzaal Ahmad Zeeshan is a computer programmer from Rabwah, Pakistan, currently living in The Netherlands, likes .NET Core and Node.js for regular everyday development. Afzaal Ahmad works at Adyen as a Developer Advocate.

He is an expert with Cloud, Mobile, and API development. Afzaal has experience with the Azure platform and likes to build cross-platform libraries/software with .NET Core. Afzaal is an Alibaba Cloud MVP, twice he has been awarded Microsoft MVP status for his community leadership in software development, four times CodeProject MVP status for technical writing and mentoring, and 4 times C# Corner MVP status in the same field.
Anele 'Mashy' Mbanga
Software Developer DanNora Business Solutions
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.

Awards:

Best Mobile Article of February 2015 (First Prize)
http://www.codeproject.com/Articles/880508/Create-a-CRUD-web-app-using-JQuery-Mobile-and-Loca

Best Mobile Article of May 2015 (Second Prize)
http://www.codeproject.com/Articles/991974/Creating-JQuery-Mobile-CRUD-Apps-using-JQM-Show-Ge

Apps
Bible.Show (Android Store App)
https://www.facebook.com/bibleshow
https://play.google.com/store/apps/details?id=com.b4a.BibleShow

JQM.Show (Android Store App)
https://www.facebook.com/jqmshow
https://play.google.com/store/apps/details?id=com.b4a.JQMShow

CodeProject.Show (An offline CodeProject Article writer)
http://www.codeproject.com/Articles/993453/CodeProject-Show-A-CodeProject-offline-article-wri
bob.bumsuk.lee
Software Developer
New Zealand New Zealand
No Biography provided
CarNet-India
Student
India India
I am an undergraduate student pursuing BE computer science in Bangalore Institute of Technology.
I am passionate about new technologies and active to learn new things.
Me and my team members(team of 4) are currently working on IOT based project CarNet for Azure IOT contest.
Project Name: CarNet-India
Project URL: http://www.codeproject.com/Articles/881733/CarNet-India
Team Members:
1) Rajeev Hegde
2) Abhay Sastry
3) Sanjeev Hegde
4) Nishanth Nelogal
Chris_Riley
United States United States
ABOUT

Chris Riley is a technologist who has spent 12 years helping organizations transition from traditional development practices to a modern set of culture, processes and tooling. In addition to being a Gigaom Research analyst, he is an O’Reilly author, regular speaker, and subject matter expert in the areas of DevOps Strategy and culture and Enterprise Content Management. Chris believes the biggest challenges faced in the tech market is not tools, but rather people and planning.

Throughout Chris’s career he has crossed the roles of marketing, product management, and engineering to gain a unique perspective of how the deeply technical is used to solve real-world problems. By working with both early adopters and late, he has watched technologies mature from rough solutions to essential and transparent. In addition to spending his time understanding the market he helps ISVs selling B2D and practitioner of DevOps Strategy. He is interested in machine-learning, and the intersection of BigData and Information Management.

EXPERTISE

application lifecycle management (alm) devops enterprise content management (ecm) information architecture (ia) information governance
Dan Letecky
Czech Republic Czech Republic
db_developer
Database Developer Freelancer
Ukraine Ukraine
MS SQL Server Database Developer with 7+ years experience

Technologies/languages: Business Intelligence, SQL, MDX, VBA, SQL Server, Analysis Services (SSAS), Reporting services (SSRS), Integration Services (SSIS), DataWarehouse.
Also: economic background.

Feel free to contact me for rates and details.
DotNetForAll
Software Developer (Senior)
India India
I have 8 years of experience of mostly developing the .NET windows as well as web applications. Passionate about learning and sharing.

Visit my personal blog to know more about the .NET technology and increase your knowledge about C# and .NET. You can always follow me on twitter @dotnetforall.
Evgeny Bestfator
Software Developer (Senior) Saber Interactive
Russian Federation Russian Federation
My specializations:

C# (especially multithreading)
WPF (MVVM, styling)
WCF (message inspectors, configuration)
MSSQL (administartion, creation, procedures, recursive queries, bulk processing)
Freek Kootstra
Architect Freek Kootstra ICT
Netherlands Netherlands
No Biography provided
furytrader
Unknown
No Biography provided
Gaurav Aroraa
Architect
India India
There is no age limit for learning and its never late, to start.
Gaurav_Chaudhary
Web Developer
India India
No Biography provided
Graham D Smith
United Kingdom United Kingdom
Dr Graham Smith is a former research scientist who got bitten by the programming and database bug so badly that in 2000 he changed careers to become a full-time software developer. Life moves on and Graham currently manages a team of software engineers and specialises in continuous delivery and application lifecycle management with the Team Foundation Server ecosystem.
IAndreev93
Russian Federation Russian Federation
No Biography provided
JammoD87
Software Developer (Senior)
United Kingdom United Kingdom
No Biography provided
Jignesh G Trivedi
Technical Lead
India India
No Biography provided
John C Rayan
Engineer
United Kingdom United Kingdom
Areas of Expertise:

.NET, MVC, SQL Server, XML , SOA and WEB solutions.

* Microsoft certified in C# Programming.
* Microsoft certified Techology Specialist (ASP.NET)
* IBM certified in XML Technology
* Sun certified Java Programmer
* Sun certified Web Solution Developer
Jörgen Andersson
Database Developer
Sweden Sweden
No Biography provided
Matt Perdeck
Architect
Australia Australia
Twitter: @MattPerdeck
LinkedIn: au.linkedin.com/in/mattperdeck
Current project: JSNLog JavaScript Logging Package

Matt has over 9 years .NET and SQL Server development experience. Before getting into .Net, he worked on a number of systems, ranging from the largest ATM network in The Netherlands to embedded software in advanced Wide Area Networks and the largest ticketing web site in Australia. He has lived and worked in Australia, The Netherlands, Slovakia and Thailand.

He is the author of the book ASP.NET Performance Secrets (www.amazon.com/ASP-NET-Site-Performance-Secrets-Perdeck/dp/1849690685) in which he shows in clear and practical terms how to quickly find the biggest bottlenecks holding back the performance of your web site, and how to then remove those bottlenecks. The book deals with all environments affecting a web site - the web server, the database server and the browser.

Matt currently lives in Sydney, Australia. He recently worked at Readify and the global professional services company PwC. He now works at SP Health, a global provider of weight loss web sites such at CSIRO's TotalWellBeingDiet.com and BiggestLoserClub.com.
Member 11459717
Student student
United States United States
No Biography provided
Nadir Muhammed
Software Developer (Senior)
India India
Naren Neelamegam
Software Developer
India India
Naren started coding during 1999 with FORTRAN, then COBOL, PASCAL, C, C++, VC++ ..... C#, Java, ASP so on, till today. He claims himself as techie who loves coding, but he is not even sure which technology or platform he loves, most of the time Windows, some time WinCE, some time Linux, nowadays Android and embedded platforms. He can do some query stuffs with Oracle, SQL Server, MySQL. He strongly believes that C/C++ is a must for all programmers, "if you know C/C++, you can do programming on any language". He is an electronic gadget guy who likes to buy small gadgets all the time, at least he will do window shopping on a gadget shop. His interest always have been with Automation in any form, call it a little automated program sitting in his Laptop or a home automation program runs on his mobile. Apart from coding, he likes to do...???
Pankil Bhatt
Software Developer
India India
No Biography provided
Passion4Code
Software Developer (Senior)
India India
No Biography provided
Peter Moore - Chicago
President Legistek Corporation
United States United States
No Biography provided
Rajesh Manjarekar
Technical Lead
United States United States
No Biography provided
RiniBoo
CEO Kitty Enterprise LLP
Canada Canada
I have been working for some corrupted government agencies in Canada who are known for scandal and milking tax payers' money. I always feel like I am in the wrong industry and want to try something more interesting because life is short. I am so tired of technologies after being in I.T. for so many years, I am a bit sick of everyday waking up and work for money, especially dealing with stupid annoying people, company politics and policies. But every time they give me a paycheck, I shut up temporary. Then the cycle begins again.....
Sarathi Balakrishnan
United States United States
No Biography provided
Satish Jagtap
Software Developer (Senior) Intellirich DevSoft Pvt. Ltd.
India India
Software developer
India
Sergey Kizyan
Architect
Ukraine Ukraine
Working on different projects and technologies from web to low level core programming, from scripting languages to C++. With all this stuff my personal opinion is that C#,.NET and Microsoft environment is the best thing programmer may have. Basing on it I prefer to publish only about my favorite technologies that are .NET and Azure now.

P.S. Looking for partnership and cooperation in outsourcing.
Shivangi_K
Software Developer
India India
No Biography provided
SMPS LLC
SMPS
Morocco Morocco
No Biography provided
Soufiane Rabhi
Technical Lead
France France
Sofiene Rabhi is Microsoft certified professional in C# ,HTML 5 and JavaScript, Asp.net and Microsoft Silverlight, consultant, trainer specializing in application development with Microsoft technologies, including c#, Vb.net, and Microsoft Azure.
Suffyan Asad
Software Developer
Pakistan Pakistan
Software Engineer and Data Scientist
sunhui
Web Developer
China China
No Biography provided
TarikHuber
Engineer ICS Logistik & Transport GmbH
Germany Germany
Born in Bosnia and Herzegowina where I studied Traffic and Communication in the University of Sarajevo. After the Bachelor, found a Job in a Logistic Company in Germany where I live and work now as an Software developer for our Company needs.

With programming I started as an hoby at work. For now I have almost 2 years programing experience. First with excel then VBA in Excel. That growed up to VBA with Access and a first Access DB. Then an SQL Server camed in and VBA with Access could not handle it. The next move was of cource VB.Net but with Visual Studio I came in contact with C#.
yuvalsol
Web Developer
Israel Israel
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. 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.

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