Click here to Skip to main content
14,271,765 members

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

Current Participants

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

HardikPatel.SE
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 | :)


Debabrata_Das
Architect
India India
My name is Debabrata Das, also known as DD. I started working as a FoxPro 2.6 developer then gradually moved towards VB6, Classic ASP, COM, DCOM. Presently in love with ASP.NET and C#.

I believe in "the best way to learn is to teach". Passionate about finding a more efficient solution of any given problem.
A. Najafzadeh
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.

==========================
+989131253620
najafzade@gmail.com
http://www.a00b.com/
==========================
Alain Peralta
Student
Mexico Mexico
Great things come from rare ideas. Wink | ;)
Anamera
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...
Azim Zahir
Instructor / Trainer NIIT, India
India India
I am a trainer by profession. Currently I am working with NIIT (Mumbai, India) as a Senior Faculty. I enjoy programming as a hobby. My favorite technologies are Flash, Flex and Silverlight.

Of late I have developed keen interest in WPF and Windows Mobile programming.

Apart from computers, my favorite pastime is bicycling.
Bohdan Stupak
Software Developer
Ukraine Ukraine
https://twitter.com/BohdanStupak1
CatchExAs
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.

www.nickwilton.info/Blog
Dave Elliott
Software Developer (Senior) Webbert Solutions
United States United States
Dave is an independent consultant working in a variety of industries utilizing Microsoft .NET technologies.
Elia Conchione
Software Developer (Senior) 42yo.com
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.
http://www.42yo.com
george bolovan
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.
Josef Hardi
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.
Kinyanjui Kamau
Software Developer (Senior) GetNet
Kenya Kenya
http://www.kinyanjuikamau.com
Member 8826598
Unknown
No Biography provided
mengwangk
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.

https://mengwangk.github.io/
Pete_H
Engineer
United States United States
BSCS. Software engineer. Programming since we chiseled code in stone. (Up hill! Both ways! And we liked it!)
Peter Carrasco
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.
Philipp Katscher
Software Developer (Senior)
Australia Australia
No Biography provided
rapidagiledevelopment
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 www.rapidagiledevelopment.com for generating C# & VB.NET, SQL, DAL & BLL, script management, testing and much more
Group type: Organisation

1 members

Right Handed Monkey
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!

righthandedmonkey.com
Sampath Lokuge
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 ASP.net 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 ASP.net 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

ASP.net MVC 5 With C#

Hybrid Mobile App with WinJS
sazakir
Technical Lead
India India
.net developer
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..
Suresh Dasari's
Technical Lead
India India
Software Design Engineer - III with 10+ 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).
Tamas Lorincz
Software Developer
Hungary Hungary
No Biography provided
TheSqlGuy
Software Developer
United States United States
No Biography provided
Webcodeexpert.com
Software Developer (Senior) www.webcodeexpert.com
India India
I am a passionate programmer and a Software Engineer love blogging and developing applications in Microsoft Technologies.
I have a blog https://www.webcodeexpert.com/
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.

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