Database Connectivity
Article

The Ins and Outs of Stored Procedures in VB.NET

A well-designed application that uses a relational database management system in the backend should make extensive use of stored procedures. A stored procedure is a named collection of SQL...
Article

Understanding ODBC .NET Data Provider

This article is an unedited part of Chapter 11: Working with ODBC .NET Data Provider from A Programmer's Guide to ADO.NET in C# book. This chapter teaches you how to work with various data...
Article

Accessing MySql Database using ADO.NET

In this article, I will show you how to access MySQL server database using ODBC data provider. There are two ways to access MySQL Server database using ODBC data providers. First, using ODBC...
Article

Working with Data Bound Controls in VB.NET

Working with data-bound controls using .NET ADO.NET and WinForms is so fun. You write few lines of code and these controls take care of rest for you. In this article, I’m going to show you how...
Article

A Generic Data Access Component using Factory Pattern in VB.NET

I just read Mahesh's article Writing a Generic Data Access Component. Another way to solve this problem is to utilize the System.Activator class and a factory pattern to create the concrete...
Article

Encapsulating ODBC in ASP .NET

HotQuant, LLC, builds on their previous ODBC article by demonstrating how to use encapsulation to isolate an application's data access layer and significantly streamline the code.
Article

Implementing ODBC in ASP .NET

With Microsoft's ODBC data server controls, .NET finally supports ODBC... but not very well. HotQuant, LLC, has published an in-depth technical article demonstrating an effective workaround.
Article

Data Binding your own collections

Complex Data Binding a collection implimenting IBindingList and ITypedList, with sample windows application.
Article

Using DAO with Microsoft Access 2000/2002

For those used to programming in Access 97 - how to set a reference to the DAO Object Library in Access 2000/2002.
Article

Object-oriented menus in VFP 6.0

In this article, I use object-oriented programming in Visual Foxpro 6.0 to go through the process of "wrapping" some of FoxPro's older Xbase commands - specifically those dealing with menus -...
Article

DAO 3.6 Library

Learn how to use MS Access 2000 with VB and the DAO library. Includes a module for handling simple databases.
Article

ADO and Unicode

How to use Microsoft ADO to add and update unicode code points stored in an Oracle UTF8 database.
Article

Creating a Custom ADO.NET DataAdapter

Visual Studio.NET's code generation features serve the purpose of creating trivial applications very well...
Article

Populating WinForm Controls with ADO.NET

This tutorial will show you three example of populating a WinForm control with database-sourced data...
 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.