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...
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...
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
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...
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
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.
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.
Complex Data Binding a collection implimenting IBindingList and ITypedList, with sample windows application.
For those used to programming in Access 97 - how to set a reference to the DAO Object Library in Access 2000/2002.
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
Learn how to use MS Access 2000 with VB and the DAO library. Includes a module for handling simple databases.
How to use Microsoft ADO to add and update unicode code points stored in an Oracle UTF8 database.
Visual Studio.NET's code generation features serve the purpose of creating trivial applications very well...
This tutorial will show you three example of populating a
WinForm control with database-sourced data...