Click here to Skip to main content
14,975,219 members
This competition has ended

Best Database Article of May 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.
22 May 2014
djc2032
A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid
Please Sign up or sign in to vote.
14 May 2014
Peter BCKR
In legacy applications you can get a MissingMemberException bei acessing a SqlParameterCollection if you work with object-variables there are reference a SqlCommand-Instance.
Please Sign up or sign in to vote.
28 May 2014
Ben Liebert
Best practice front-end architecture using Microsoft ASP.NET MVC and Rivet.js
Please Sign up or sign in to vote.
27 May 2014
Brendan Lester
Use of an Oracle 11g Skip Lock feature to easily implement a scalable, robust work queue
Please Sign up or sign in to vote.
23 May 2014
Sebastiaan Meijerink
Breeze pitfall. Understanding entityQuery function changing.
Please Sign up or sign in to vote.
11 May 2014
apis3445
This is another book about ADF
Please Sign up or sign in to vote.
7 May 2014
Ashish Tripathi
Sharp RepoGen is a simple tool to create repository interface having methods for CRUD operation and its implementing class. Using this tool easily you can generate your repositry class and interface. Code is generated with the help of xml template, so very easily you may change the template to creat
8 May 2014
Jeffrey T. Fritz
In this article, I’m going to add the Telerik UI for ASP.NET to my previous Faceted Search with dtSearch article and do some refactoring to make my search page look better and easier to use.
Please Sign up or sign in to vote.
21 Oct 2019
Higty
DbSharp is a DAL Generator. It generates a StoredProcedure client class that enables you to call stored procedure easily. DbSharp also creates Table and Record classes that enables you to CRUD operation.
Please Sign up or sign in to vote.
26 May 2014
L. Michael
This article provides a practical approach for exposing a .NET assembly to COM.
Please Sign up or sign in to vote.
15 Nov 2014
Peter Leow
A bridging introduction to server-side scripting.
Please Sign up or sign in to vote.
18 May 2014
Mahesh Bailwal
This is a stored procedure generator for SQL Server
Please Sign up or sign in to vote.
21 May 2014
Arvind Singh Baghel
Import CSV or txt File Into SQL Server Using Bulk Insert.
Please Sign up or sign in to vote.
8 May 2014
Manas Bhardwaj, CHill60
Generating a sequence in SQL
Please Sign up or sign in to vote.
20 May 2014
Ed Nutting
How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"
Please Sign up or sign in to vote.
5 Jun 2014
CatchExAs
How Formula 1 is beginning to use StreamInsight to broadcast data analytics to your screen in real time
Please Sign up or sign in to vote.
20 May 2014
B. Clay Shannon
Learn how to get all records from any SQLite table, passing the Table Name as String and receiving a StringBuilder
Please Sign up or sign in to vote.
2 May 2014
Pavith Goonathilake
RDLC Report Grouping with Page Break for each Group Type, Table Header repeat for each page and Report Totals
Please Sign up or sign in to vote.
1 May 2014
Eric Goedhart
Part two of the ASP.NET MVC Documents Sample
Please Sign up or sign in to vote.
27 May 2014
KarstenK
Emporing C++ on the Windows Phone 8.0
Please Sign up or sign in to vote.
22 May 2014
djc2032
A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid
Please Sign up or sign in to vote.
24 Jun 2014
Debabrata_Das
In this article we will create a project to see how one-to-many relationship can be implemented in ASP.NET
Please Sign up or sign in to vote.
17 Feb 2020
Thava Rajan
Prepare script for specific objects
Please Sign up or sign in to vote.
25 Jun 2014
Marla Sukesh
Learn Business Intelligence step by step - SSIS Day 2
Please Sign up or sign in to vote.
12 May 2014
Nitesh Luharuka
How to do case sensitive string match in SQL Server
Please Sign up or sign in to vote.
8 May 2014
rafaelpb
Generate a postalcode database for lookups from dutch national data BAG
Please Sign up or sign in to vote.
1 May 2014
mhano
The class allows you to encode / decode 4, 9 or 17 bit (for example, 1 through 31 bit unsigned int supported) integers to and from a byte[].
Please Sign up or sign in to vote.
28 May 2014
Debopam Pal
This example shows how you can generate INSERT, UPDATE & DELETE SQL Query for Oracle DB.
Please Sign up or sign in to vote.
8 May 2014
kunal r somani
Regarding progress bar

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
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.
Marla Sukesh
Founder Just Compile
India India
Learning is fun but teaching is awesome.

Who I am? Trainer + consultant + Developer/Architect + Director of Just Compile

My Company - Just Compile

I can be seen in, @sukeshmarla or Facebook
apis3445
Software Developer armheSistemas
Mexico Mexico
I'm a software developer. I like to develop web pages and desktop systems. I'm learning unity, xamarin, swift, android, security, UX
Arvind Singh Baghel
Software Developer
India India
I am a software developer having 3.6+ years experience in .Net technology with Sql server database, Having working knowledge of ASP.Net, C#.Net, SQL Server 2005/2008, AJAX, Java Script, JSON, Crystal Report and WPF.
I have great fun while working on database.
Ashish Tripathi
Founder Aspirea Technologies Pvt Ltd
India India
• 8 years of experience in IT Industry as a Developer.
• Experience of End-To-End Software Development and Implementation (Entire SDLC i.e Software Development Life Cycle)
• Real time Exposure to Banking, Finance and Energy industry.
• Expertise in distributed application architecture as well as web based applications using Microsoft.NET platform.
• Expertise in database design, SQL programming and SQL performance tuning.
• Expertise in Web Services and WCF Services.
• Experience of Rich Internet Application using Adobe Flex.
• Experience in migration of legacy application to latest technology, migration of VB application to .NET.
• Knowledge of OOPS and Design Concepts.
• Expertise in Agile/ Scrum software development processes.

Specialties
• Languages\ Technologies-
.NET Framework 1.1/2.0/3.0/3.5, C#.NET, VB.NET, ASP.NET, VB6, AJAX, ASP.NET, Adobe Flex 3.0, Web Services, Windows Communication Foundation (WCF), LINQ, SQL Server, Oracle, MySql, MS Access, HTML, XML, JavaScript, C# Script, CSS and XSLT.

• Methodology/ Concepts-
OOPS, Data Structures, Design Concepts and Agile/ Scrum Software Development
B. Clay Shannon
Founder Across Time & Space
United States United States
I am in the process of morphing from a software developer into a portrayer of Mark Twain. My monologue (or one-man play, entitled "The Adventures of Mark Twain: As Told By Himself" and set in 1896) features Twain giving an overview of his life up till then. The performance includes the relating of interesting experiences and humorous anecdotes from Twain's boyhood and youth, his time as a riverboat pilot, his wild and woolly adventures in the Territory of Nevada and California, and experiences as a writer and world traveler, including recollections of meetings with many of the famous and powerful of the 19th century - royalty, business magnates, fellow authors, as well as intimate glimpses into his home life (his parents, siblings, wife, and children).

Peripatetic and picaresque, I have lived in eight states; specifically, besides my native California (where I was born and where I now again reside) in chronological order: New York, Montana, Alaska, Oklahoma, Wisconsin, Idaho, and Missouri.

I am also a writer of both fiction (for which I use a nom de plume, "Blackbird Crow Raven", as a nod to my Native American heritage - I am "½ Cowboy, ½ Indian") and nonfiction, including a two-volume social and cultural history of the U.S. which covers important events from 1620-2006: http://www.lulu.com/spotlight/blackbirdcraven
Ben Liebert
Architect BlackBall Software
New Zealand New Zealand
No Biography provided
Brendan Lester
Architect
New Zealand New Zealand
Architect, designer, developer for corporate, government & private.
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
Debopam Pal
Software Developer National Informatics Centre (NIC)
India India
Hello! Myself Debopam Pal. I've completed my MCA degree from West Bengal University of Technology at 2013. I'm from India. I’ve started to work with MS Technologies in 2013 specially in C# 4.0, ASP.NET 4.0. I've also worked in PHP 5. Now I work in JAVA/J2EE, Struts2. Currently I'm involved in a e-Governance Project since Jan, 2014. In my leisure time I write Blog, Articles as I think that every developer should contribute something otherwise resource will be finished one day. Thank you for your time.

Visit: Linkedin Profile | Facebook Profile | Google+ Profile | CodeProject Profile
djc2032
Retired Retired
United States United States
Dan retired from the business world in November, 2014. But his programming experience includes C/C++, C#, Oracle SQL and PL/SQL, MFC, WCF, gSOAP. He has developed systems for everything from IBM, Burroughs and Honeywell mainframes to Radio Shack PCs. He does not have a favorite platform, just enjoys solving business problems by applying modern technology.

Dan is the father of two, and has two wonderful grandchildren he now gets to see more often, now that he is retired.

His current interests include MFC projects to do simulations of baseball and football. Hobbies he was unable to pursue when still working.
Ed Nutting
Student
United Kingdom United Kingdom
No Biography provided
Eric Goedhart
Software Developer Eric Goedhart
Netherlands Netherlands
Smile | :)
Higty
CEO TinyBetter, Inc
Japan Japan
I'm a CEO of TinyBetter, Inc in Japan.
Jeffrey T. Fritz
Program Manager
United States United States
Jeff Fritz is a senior program manager in Microsoft’s Developer Division working on the .NET Community Team. As a long time web developer and application architect with experience in large and small applications across a variety of verticals, he knows how to build for performance and practicality. Four days a week, you can catch Jeff hosting a live video stream called 'Fritz and Friends' at twitch.tv/csharpfritz. You can also learn from Jeff on WintellectNow and Pluralsight, follow him on twitter @csharpfritz, and read his blog at jeffreyfritz.com
KarstenK
Software Developer
Germany Germany
I am living in germany and now living from programming for some Years. In my spare time I like sports as jogging, playing football (soccer) and basketball.

We must take care for our planet, because we and our family has no other. And everybody has to do something for it.
kunal r somani
Software Developer
India India
No Biography provided
L. Michael
Architect
Denmark Denmark
I am a software architect/developer/programmer.

I have a rather pragmatic approach towards programming, but I have realized that it takes a lot of discipline to be agile. I try to practice good craftsmanship and making it work.
Mahesh Bailwal
Software Developer (Senior)
India India
Developer
Manas Bhardwaj
Architect
Netherlands Netherlands

Read my personal blog at www.manasbhardwaj.net.

mhano
Architect
Australia Australia
No Biography provided
Nitesh Luharuka
Team Leader Director @ Rebin Infotech
India India
An Independent IT Professional and Consultant on MS Technologies like .Net | MVC | Silverlight | Sharepoint | MS Project Server along with open source CMS Systems like DotNetNuke etc.

I am an enthusiastic technocrat who love to debug problems and solve them. I love writing articles on my website in my spare time. Please visit my Website for more details and subscribe to get technology related tips/tricks.
Pavith Goonathilake
Business Analyst
Sri Lanka Sri Lanka
I am a dedicated and innovative software developer that likes to research in Business and its Strategies.
Understanding Business, its Strategies and its Management is my own passion of career, but I add those to my career knowledge and experience in a different taste which is Information Technology and Computer Science. I am employed in IT field. Being in Software Development Industry added more knowledge in IT and its concepts and how to convert those technologies to business world and how to use those in effective and profitable manner.

I am Certified in;
Microsoft Specialist - Programming in HTML5 with JavaScript and CSS3
Peter BCKR
Software Developer (Senior)
Germany Germany
No Biography provided
Peter Leow
Instructor / Trainer
Singapore Singapore
Stop by my website at https://peterleowblog.com/

Check out my publications at https://www.amazon.com/author/peterleow

Follow me on twitter at https://twitter.com/peterleowblog

“Live as if you were to die tomorrow. Learn as if you were to live forever.”
― Mahatma Gandhi

子曰:"三人行,必有我师焉;择其善者而从之,其不善者而改之."
rafaelpb
Software Developer
Netherlands Netherlands
No Biography provided
SarmadAsghar
Team Leader VF
Pakistan Pakistan
No Biography provided
Sebastiaan Meijerink
Software Developer (Senior)
Netherlands Netherlands
I'm a developer with 15+ years of experience. Starting of on a MVS mainframe, moving to building big multi-tier ERP systems with unix backends, to building web-based BI-Portals. I've seen a lot of different languages, environments and paradigmes.

At this point my main interest is webdevelopment. Mainly javascript and ASP.NET. But I also like getting my hands dirty on some PHP.

My main focus has been shifting towards full javascript the past years. Almost anything can be accomplished now. From building full offline webapps, to IoT (Tessel), to server (node).
Thava Rajan
Architect
India India
No Biography provided

Contest Entries and Requirements

  1. The contest period covers the the first day of the month 12AM US Eastern Standard Time and ends the final day of the month at 11:59:59 PM US Eastern Standard Time. All entries must be submitted during this period in order to qualify.
  2. Entries must be an article, or blog entry.
  3. With the exception of the Everything Else category, the article must be tagged with at least one of the tags corresponding to that competition's category (for example, to enter the C# Competition you would need to tag your article with a C# tag).
  4. Articles entries must follow the CodeProject submission guidelines.
  5. No cheating, lying, plagiarizing articles, chicanery, or kicking.
  6. Articles may only be considered for a single category. If an article is eligible for multiple categories (for example, it pertains to both the C# and Web Dev categories), CodeProject editors and judges will decide which category the article shall be entered in.
  7. No author can be nominated twice in the same category.
  8. If an author writes has two separate articles, each article may be considered in their respective categories provided none of the aforementioned rules are broken. For example, if an author wrote two separate articles, one related to C# and one related to VB.NET, the author and articles could be nominated in the C# and VB.NET competitions, respectively.
  9. In the event an author wins multiple competitions, and repeat, identical prizes, the number of prizes issued is solely at the discretion of the prize issuer.
  10. Multiple votes from the same IP will be automatically disqualified.
  11. The judges’ decision is final and no correspondence will be entered into.
  12. Only those who live in jurisdictions in which this contest is legal may enter.
  13. Any breach of the rules and the prize will be awarded to the runner up.
  14. By entering the contest you agree to the rules, conditions of entry, and agree that your member alias and any submitted material can be used for promotional purposes by CodeProject.
  15. Entries shall be deemed to be submitted by the authorized account holder of the email address submitted at the time of entry unless clearly indicated otherwise. "Authorized account holder" is defined as the natural person who is assigned to an email address by an internet access provider, on-line service provider, or other organization (e.g. business, educational institution, etc.) that is responsible for assigning email addresses for the domain associated with the submitted email address.

Eligibility

This competition is open to software development professionals & enthusiasts who are of the age of majority in their jurisdiction of residence; however, residents of Quebec and of the following countries are ineligible to participate due to legal constraints: Cuba, Iran, Iraq, Libya, North Korea, Sudan, and Syria. Employees (or a member of their immediate family) of CodeProject or any of their affiliates, subsidiaries, advertising or promotional agencies are also ineligible to participate. Void where prohibited by law.

How to Enter

Entry is by the submission process described above. Please read the submission requirements before submitting your entry and ensure the article is tagged with at least one of the tags corresponding to that competition's category.

Lost, late, misdirected, or illegible entries will be disqualified. Any entry containing content that CodeProject deems objectionable for any reason will be disqualified. All decisions of CodeProject with respect to any aspect of the competition, including, without limitation, the eligibility of entries, are final and binding on all entrants in all matters as they relate to this competition. CodeProject reserves its right to modify the Rules.

CodeProject assumes no responsibility for lost, late, delayed, destroyed or misdirected mail, voice messages, email or any computer errors or malfunctions. No correspondence will be entered into with entrants.

CodeProject does not assume any responsibility for incorrect or inaccurate capture of entry information, technical malfunctions, human or technical error, lost, delayed or garbled data or transmissions, omission, interruption, deletion, defect or failures of any telephone or computer line or network, computer equipment, software or any combination thereof. Entry materials/data that have been tampered with or altered are void. If for any reason, in the opinion of CodeProject in its sole discretion, the competition is not capable of running as originally planned, or if the administration, security, fairness, integrity or the proper conduct of the competition is corrupted or adversely affected, including by reason of infection by computer virus, bugs, tampering, unauthorized intervention, fraud, technical failures or any other causes beyond its control, CodeProject reserves its right to cancel, terminate, modify, amend, extend or suspend the competition including cancelling any method of entry, and select a winner from previously received eligible entries. CodeProject reserves its right in its sole discretion to disqualify any individual it finds to be tampering with the entry process or the operation of the competition or to be acting in violation of the Rules or otherwise in a disruptive manner. CodeProject reserves its right to seek remedies and damages to the fullest extent of the law for any attempts to deliberately damage the competition web site or to undermine the legitimate operation of this competition. CodeProject shall not be held responsible for any errors or negligence that may arise or occur in connection with the competition including any damage to an entrant's computer equipment, system, software or any combination thereof, as a result of their participation in this competition or from downloading any material from the competition website where applicable.

You must sign in to participate in this contest.
This contest has ended.
1 May - 31 May 2014