Click here to Skip to main content
14,573,817 members

Best Database article of July 2013

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.

11 Aug 2013
LarryCharlton
Dynamic data forms.
22 Jul 2013
Paw Jershauge
Want your own movie database??? Download IMDB in 20 minutes.
4 Jul 2013
sumit_kapadia
Create and Bind gridview at client side with Jquery Template and ajax in asp.net
17 Jul 2013
Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
1 Oct 2013
Espen Harlinn
A reflection based wrapper for the Oracle Data Provider for .NET – allows your application to dynamically load the Oracle.DataAccess.dll assembly installed on your client’s computer.
8 Sep 2013
Winfried Wille
MySQL-Fullltext: Start for a simple search-engine using MySQL C-API, WCF, and jQuery
28 Jul 2013
Dino Konstantopoulos
Running MapReduce in a SQL Server database.
24 Jul 2013
Kumar Pankaj Verma
Truncating log file in SQL Server using T-SQL when log file is too large and database becomes unresponsive.
4 Jul 2013
Khaleel Esbaitah
Models (POCO), Entity Framework and Data Patterns
3 Jul 2013
Anil kumar Bhardwaj
Create HTML tree or organization structure for web applications.
8 Jul 2013
Sarvesh Kushwaha
This article describes what XSS is and how to prevent XSS attacks.
20 Jul 2013
AspDotNetDev
This query will show you all tables and columns in a database, and it can be pasted into Excel for easy manipulation.
1 Aug 2013
Bikash Prakash Dash
How to create an auto suggestion control like Gmail/Hotmail/Facebook to add items in list.
11 Jul 2013
Bhushan W. Juare
This tip shows how to use SQLCMD utility in SQL Server 2008.
22 Jul 2013
Kulamani Sahoo
Differences between a stored procedure and a trigger.
8 Jul 2013
JP van Mackelenbergh
Abstracting the ORM Framework via Repository/Unit Of Work patterns
10 Jul 2013
vinothharshad
Except vs Not In in SQL Server
29 Jul 2013
h_wiedey
The article treats the differences between triggers in Oracle and MS SQL and demonstrates the mutating table problem.
23 Jul 2013
Smitten Ediot
Reporting stored procedure error in email and also log the error in a table.
29 Oct 2017
vinothharshad
Use the ON DELETE CASCADE option if you want rows deleted in the child table when corresponding rows are deleted in the parent table.
30 Jul 2013
Gauri Chodanker
SQL function in SQL
9 Jul 2013
Bhushan W. Juare
The different ways of retrieving XML data from SQL Server.
25 Jul 2013
Kumar Pankaj Verma
How to convert a delimited string in SQL Server to a table column.
18 Jul 2013
Mircea Sirghi
Jacob for Excel, pivot tables, VBA functions, etc.
19 Jul 2013
Sebastian Solnica
Diagnosing a collation issue in a MySQL stored procedure.

Current Participants

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

Anil kumar Bhardwaj
United States United States
No Biography provided
AspDotNetDev
Web Developer
United States United States

  • Managing Your JavaScript Library in ASP.NET (if you work with ASP.net and you don't read that, you are dead to me).
  • Graduated summa cum laude with a BS in Computer Science.
  • Wrote some articles and some tips.
  • DDR ("New high score? What does that mean? Did I break it?"), ping pong, and volleyball enthusiast.
  • Software I have donated to (you should too):
Bhushan W. Juare
Software Developer (Senior)
India India
No Biography provided
Dino Konstantopoulos
Instructor / Trainer Boston University, Northeastern University
United States United States
Dino works at a National Lab, and is a Lecturer at Boston University since 2009, where he teaches Web development (MET CS 651) and Cloud Computing (MET CS 755), and a Lecturer at Northeastern University since 2015, where he teaches about Big Data (INFO 7250).
Espen Harlinn
Architect Powel AS
Norway Norway
Chief Architect - Powel AS.

Specializing in integrated operations and high performance computing solutions.

I’ve been fooling around with computers since the early eighties, I’ve even done work on CP/M and MP/M.

Wrote my first “real” program on a BBC micro model B based on a series in a magazine at that time. It was fun and I got hooked on this thing called programming ...

A few Highlights:

  • High performance application server development
  • Model Driven Architecture and Code generators
  • Real-Time Distributed Solutions
  • C, C++, C#, Java, TSQL, PL/SQL, Delphi, ActionScript, Perl, Rexx
  • Microsoft SQL Server, Oracle RDBMS, IBM DB2, PostGreSQL
  • AMQP, Apache qpid, RabbitMQ, Microsoft Message Queuing, IBM WebSphereMQ, Oracle TuxidoMQ
  • Oracle WebLogic, IBM WebSphere
  • Corba, COM, DCE, WCF
  • AspenTech InfoPlus.21(IP21), OsiSoft PI


More information about what I do for a living can be found at: harlinn.com or LinkedIn

You can contact me at espen@harlinn.no
Gauri Chodanker
Software Developer (Senior)
India India
No Biography provided
h_wiedey
Germany Germany
No Biography provided
JP van Mackelenbergh
Architect Altran
Netherlands Netherlands
I am a relaxed guy, born in '73, who likes to develop software professionally in both my work and in my spare time.

Keywords are C#, WCF, WPF.
Khaleel Esbaitah
Software Developer
Australia Australia
.NET Web Developer from Sydney .
Passionate about Technologies.
Likes Video games.
No Biography provided
Kumar Pankaj Verma
Technical Lead E. Soft Technologies
India India
Never try out to sort other's problem. Tell them the way only ........... Let do themselves.
LarryCharlton
United States United States
I enjoy my wife, living in the woods, my 7 dogs, and learning new things. I like to play with UI stuff and model based coding.
Mircea Sirghi
Software Developer Endava, Chisinau
Moldova (Republic of) Moldova (Republic of)
Graduate: Romania, University of Bucharest, Mathematical - Informatical faculty.
Sarvesh Kushwaha
Software Developer
India India
I do believe life is to help others ... So here i am .. in my spare time i learn new things of programming and try to help people with my knowledge .
I'm an energetic, self-motivated and hard-working Developer and Information Technology Professional with experience in projects, website design and development.

Visit My Technical Blog
Sebastian Solnica
Software Developer (Senior)
Poland Poland
Interested in tracing, debugging and performance tuning of the .NET applications.

My twitter: @lowleveldesign
My website: http://www.lowleveldesign.org
No Biography provided
sumit_kapadia
Software Developer
India India
No Biography provided
Tom Glick Philadelphia, US
Software Developer (Senior)
United States United States
Enterprise developer with over 15 years of experience coding Windows and Web Apps in C#, WCF, SQL, EF, Http, Linq, etc. Enjoy middle-tier development on large BLL/DAL projects, also full SDLC for smaller projects needing single developer.

Currently live near Philadelphia although I've been working for the past 20 months for a large health-care provider in Pittsburgh.
vinothharshad
Software Developer
India India
This is Vinoth from Coimbatore. Vinoth have been working as software developer since Jan 2011. Find Vino's other Interesting article in http://dotnettips4all.blogspot.in/
Winfried Wille
Software Developer Winfried Wille Softwareentwicklung
Germany Germany
I am a .Net programmer working since 25 years as software developer and system engineer. I live in Hamburg, Germany.
My application and blog are here http://w2ww.de .
Currently i work as freelancer.My hourly price is 40€. I gladly accept fixed price projects.
Zafar Sultan
Software Developer (Senior)
India India
I have been involved in web application development for last 8+ years. Currently working as a Senior Software Engineer. Have extensive experience in ASP.Net MVC, C#, MS-SQL Server, JavaScript, AJAX, jQuery and ExtJS. Still learning...
You must sign in to participate in this contest.
This contest has ended.
1 Jul - 31 Jul 2013