Click here to Skip to main content
15,849,032 members
This competition has ended

Best Database Article of June 2014

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.
20 Jun 2014Debabrata_Das
This article will talk about how to update multiple records in a GridView on a single button click using JSON in ASP.NET
Please Sign up or sign in to vote.
10 Jun 2014Anamera
This XSLT will output an Excel worksheet containing a CSV type of record collection in a more usable XML format.
Please Sign up or sign in to vote.
13 Jun 2014Right Handed Monkey
This is a tutorial for accessing sqlite databases in Android in a thread safe manner. If you download the library code, please bookmark, comment on, or rate the article - it helps out tremendously.
Please Sign up or sign in to vote.
21 Jun 2014george bolovan
Read data from the next row
Please Sign up or sign in to vote.
19 Jun 2014TheSqlGuy
This briefly goes over an issue experienced when executing a query against a linked server to Oracle from SQL Server.
Please Sign up or sign in to vote.
26 Jun 2014Member 8826598
Performance Tuning of DML Operation Insert in different scenario
Please Sign up or sign in to vote.
15 Jun 2014Right Handed Monkey
MySQL Database Performance Diagnostics - Where to start?
4 Jun 2014rapidagiledevelopment
The Software Development process can be time consuming and stressful. Outlined here are some practical tips on how to ease the strain with kissIT!® applications within the context of Prototyping / Agile methods for SQL, C# & VB.NET.
Please Sign up or sign in to vote.
28 Jun 2014Elia Conchione
Moving from old SharePoint server? Something to import inside SharePoint 2013?
Please Sign up or sign in to vote.
16 Jun 2014Sampath Lokuge
The book is Reporting with Microsoft SQL Server 2012.
Please Sign up or sign in to vote.
15 Jun 2014Right Handed Monkey
Android Database Example and Tutorial (thread safe version)
Please Sign up or sign in to vote.
14 Jun 2014Right Handed Monkey
Introducing the WorxForUs Open Source Database & Network Helper for Android
Please Sign up or sign in to vote.
30 Jun 2014Kinyanjui Kamau
To set up an ASP.NET application the implements ASP Identity with Entity Framework to use MySql as a database.
Please Sign up or sign in to vote.
11 Jun 2014Pete_H
This tip explains how to do tracing with SQL Server Express using a desktop application written in C#, .NET 4.
Please Sign up or sign in to vote.
11 Jun 2014CatchExAs
StreamInsight: A simple demonstration
Please Sign up or sign in to vote.
24 Jun 2014Shuqian Ying
Introducing a centralized two stage log4net logging solution and its real-time notification API.
Please Sign up or sign in to vote.
27 Jun 2014Philipp Katscher
Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool
Please Sign up or sign in to vote.
24 Oct 2014Shivprasad koirala, Marla Sukesh
This is the part 3 of the series Learn MSBI step by step
Please Sign up or sign in to vote.
6 Jun 2014Azim Zahir
This is a simple demonstration of using SQLite database in Android.
Please Sign up or sign in to vote.
22 Jun 2014Bohdan Stupak
This tip will cover several interesting issues of SQL
Please Sign up or sign in to vote.
27 Jun 2014Philipp Katscher
How to use barcodelib generated Barcodes in SSRS (consider Barcode fonts don't work in runtime)
Please Sign up or sign in to vote.
6 Jul 2014Dave Elliott
An attempt to create a flexible and re-usable Data Access Layer
Please Sign up or sign in to vote.
20 Jun 2014sazakir
Using SqlCacheDependency with Web caching
Please Sign up or sign in to vote.
1 Jun
In this article, I am going to demonstrate how to get more data on demand i.e. On every click of button fetch more records from SQL Server database table and load in GridView with wait/progress/loading image as shown in image in ASP.NET using both C# and VB languages.
Please Sign up or sign in to vote.
29 Jun 2014mengwangk
Using OpenCV4Android in Android App
Please Sign up or sign in to vote.
12 Dec 2016Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
Please Sign up or sign in to vote.
7 Jun 2014A. Najafzadeh
Saving zip files in access database with encrypting bytes when file saved in access database and decrypting bytes when extracting files from database . . .
Please Sign up or sign in to vote.
10 Jun 2014Alain Peralta
A very simple replication cluster with MariaDB
Please Sign up or sign in to vote.
25 Jun 2014Josef Hardi
This is the third and final article about Semantika. This article will guide you to develop a simple "hello-world" query application

Current Participants

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

Web Developer PaperSave
India India

Hardik Patel

I am ASP.Net developer since january,2014, @ Satva Infotech, Paldi, Ahmedabad.

I like to learn new tips & tricks in development.

I always like to be updated in technology & also in development.

I also like to share my knowledge with everyone.

I also like to accept new difficulties in project development.

I always spend my time in learning new things.

I am working with SQL ,Javascript ,jQuery ,Ajax ,WebServices ,ASP.NET ,C# etc..

Feeling very happy to developing new projects... Big Grin | :-D Smile | :)

Product Manager
India India
I'm Debabrata Das, also known as DD. I started working as a FoxPro 2.6 developer then there is a list of different technologies/languages C, C++, VB 6.0, Classic ASP, COM, DCOM, ASP.NET, ASP.NET MVC, C#, HTML, CSS, JavaScript, jQuery, SQL Server, Oracle, No-SQL, Node.Js, ReactJS, etc.

I believe in "the best way to learn is to teach". Passionate about finding a more efficient solution of any given problem.
India India
Software Developer Bitasoft Co.
Iran (Islamic Republic of) Iran (Islamic Republic of)
Dear All
Thanks for read this words.

Bitasoft Co. was stablished in 2002. Our activity is programming.

We can supply you with best Source Codes and projects.

Software Developer (Senior)
Mexico Mexico
Great things come from rare ideas. Wink | ;)
H&M Systems Software, Inc.
United States United States
Started programming as a 16-year old nerd on IBM /370 systems, before there were "personal computers" -- at a time when ARPAnet had barely 100 connected systems and when there you could literally "lay your hands" on your 80 column formatted code (well, really 71 columns Wink | ;-) ).

/370 Assembler, COBOL, PL/1, REXX, z80 Assembler, 8080 Assembler, C, C++, C#, Pascal, HTML, CSS, XML, XLS, JavaScript, ASP, .NET, PHP, MS Jet/Access, MS SQL, MySQL, VOIP, SIP...
Instructor / Trainer NIIT, India
India India
I am a trainer by profession. Currently I am working with iFuture Technologies(India) as a Senior Faculty. I enjoy programming as a hobby. During my career I have seen the growth and decline of many technologies, many of them being my favorites like Flash, WPF, Windows Mobile Development. Few of my current favorites are Android, Xamarin and Python, though I also like traditional and evergreen languages like PHP, C#, Visual Basic and Java.

Apart from computers, my favorite pastime is bicycling.
Team Leader
Ukraine Ukraine
Team leader with 8 years of experience in the industry. Applying interest to a various range of topics such as .NET, Go, Typescript and software architecture.
Technical Lead Alpha Integralis Limited
United Kingdom United Kingdom
CatchExAs aka Nick Wilton runs Alpha Integralis, a software development consultancy to companies in the City of London.

Main interests include exploring Algo-Trading, Quant Development and Physics using C# and Java.
Software Developer (Senior) Webbert Solutions
United States United States
Dave is an independent consultant working in a variety of industries utilizing Microsoft .NET technologies.
Software Developer (Senior)
Italy Italy
Elia Conchione is a Banking software engineer from 1986, living in Cittadella, Padova, Italy. Current programming interests include C, C++, C#, Linux, Unix, Mac OS X, Safe Code, encryption applications.
Software Developer
Canada Canada
C,C++,C#,X++,.NET,JavaScript,ASP.NET,MVC,jQuery,Ajax,HTML5,WCF,JAVA,PHP,PowerShell,SharePoint 2010/2013,Dynamics AX,MSSQL,SQLCLR,MySQL,Oracle,Sybase, SSIS,SSRS,Infragistics,BI,CrystalReports,ADO.NET,EntityFramework,Unix,C Shell,PERL,COBOL,Z/OS.
Founder Obidea Technology
Indonesia Indonesia
I am a Software Engineer, specialized in Java application and API design. I have a working experience in knowledge-base representation, domain model and databases. My latest project in Semantika tries to offer a new solution for data querying over relational database using Semantic Web technology.
Software Developer (Senior) GetNet
Kenya Kenya
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior)
Malaysia Malaysia
A programmer for a long time, and still learning everyday.

A supporter for open source solutions, and have written quite a few open source software both in .NET and Java.
United States United States
BSCS. Software engineer. Programming since we chiseled code in stone. (Up hill! Both ways! And we liked it!)
Team Leader
United States United States
I am a senior software engineer and technical lead for a mid-sized technology firm. I have an extensive background in designing, developing, and supporting ASP.NET web-based solutions. I am currently extending my skill-set to the area of application identity management and access control.
Software Developer (Senior)
Australia Australia
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Founder Cove Bay Software Limited
United Kingdom United Kingdom
Cove Bay Software has over 18 years experience in Software Engineering including Analysis, Architecture Design, User Interface Design and Implementation in C#, ASP.NET, VB.NET & Delphi with SQL Server 2000 / 2005 / 2008 / 2012 & 2014.

Rigorous use of Design Patterns and strict adherence to Coding Standards ensure Product Quality.

We specialise in Custom Software Development using Agile / Prototyping (RAD) Methods and Tools to ensure rapid delivery of Products to Market.

We have just launched our range of kiss!® Rapid Agile Development Applications on for generating C# & VB.NET, SQL, DAL & BLL, script management, testing and much more
This is a Organisation

1 members
Chief Technology Officer WorxForUs
United States United States
I am a programmer who posts rambling on about java, Android, PHP, or whatever I am motivated to type on my charcoal colored Kinesis Freestyle2 keyboard. Please send +1's, shared links, warm thoughts of encouragement, or emasculating flames of internet fury to my blog. Thanks for reading!
Software Developer (Senior) Freelancer
Sri Lanka Sri Lanka
Sampath Lokuge holds a Bachelor of Science degree in the Mathematics and Computer Science at the University of Colombo, Sri Lanka.

He possesses over 8 years of experience in constructing web applications using Microsoft Technologies including MVC, C#, SQL Server, Web API, Entity Framework and also other web technologies such as HTML5, CSS3,jQuery and AngularJS.

Sampath has earned Microsoft certifications such as MCP, MCAD, MCSD and MCTS and very recently he has completed MS (Microsoft Specialist) for MVC 4 and MCSD (Windows Store Apps Using HTML5).

Besides that, he is an active blogger, writing about web and mobile development issues and promoting best practices.He also actively participates in online communities such as Code Project and StackOverflow.He himself is handling three communities, which are MVC 5 With C# on Linkedin,Entity Framework 6 on G+ and Hybrid Mobile App with WinJS on Facebook.

Now, I am a 100% Freelancer. Smile | :)

Tech Blogs

Sampath Lokuge Tech Universe

Communities which I'm Handling :

Entity Framework 6 MVC 5 With C#

Hybrid Mobile App with WinJS
Technical Lead
India India
.net developer
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 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.
Technical Lead
India India
Technical Lead with 13+ years of experience in requirement, analysis, design, development and execution of software applications using Microsoft Technologies (C#.NET, ASP.NET, SQL Server, VB.NET, ADO.NET, WCF, LINQ, MVC, WEB API, Windows Services).
Software Developer
Hungary Hungary
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
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.
Software Developer (Senior)
India India
I am a passionate programmer and a Software Engineer love blogging and developing applications in Microsoft Technologies.
I have a blog
It is a collection of code snippets for web programmers, including code for Asp.Net, Sql Server, C#.Net, VB.Net, Ajax,LINQ, Jquery, JavaScript, XML, WCF Services, C, C++, Interview Questions and answers and more!

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.


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 Jun - 30 Jun 2014