Click here to Skip to main content
15,868,141 members
Everything / ADO

ADO

ADO

Great Reads

by Daniele Fontani
.NET Core showcase: learn basics implementing a toy tool
by Kirill Panov
CDataGrid which was derived from CGridCtrl and used ADO for access to database.
by NavnathKale
Lightweight and simple
by Tharaka MTR
This post will show you how to fix orphaned SQL users.

Latest Articles

by Raphael Adeniji
Many a times, we need to programmatically manage GridView/DataGrid in Visual Studio web applications and this looks very difficult because we do not know what properties or events of the control to use. It may also be as a result of time constraint.
by peterswinkels
A Visual Basic 6 program demonstrating how to access databases using Microsoft ADO and how to automate Outlook and Excel.
by #realJSOP
A tool to generate model and viewmodel classes directly from your selected database
by #realJSOP
A rewrite of a previous article with more liquid nitrogen and bacon

All Articles

Sort by Score

ADO 

8 Sep 2017 by Daniele Fontani
.NET Core showcase: learn basics implementing a toy tool
24 Feb 2002 by Kirill Panov
CDataGrid which was derived from CGridCtrl and used ADO for access to database.
29 May 2017 by tranthanhtu.vn
In this article, We will learn why do we need to manage the stages of our application.
4 Nov 2021 by #realJSOP
A tool to generate model and viewmodel classes directly from your selected database
3 Jul 2013 by Ohad Redlich
This article shows how Java application can retrieve user's data from the Active Directory
17 Dec 2007 by alex turner
Excel 2007 does not seem to support DBF files, here is a VBScript workaround.
28 Aug 2008 by Robert Kirchhof
Provide the OU, and set or clear the checkbox on all managed groups within it
3 Aug 2011 by Eric Lynch
Flexible CSV reader/writer with progress reporting and many file format variations.
29 Oct 2001 by simulant
Transform any XML persisted ADO Recordset into a delimited text file.
1 Dec 2019 by Fedor Dzjuba
Sometimes, we need to present MDX result on the web or a client application that has no native provider to Microsoft Analysis Service. Solution is to use Adodm.Client CellSet, serialize it into sensible JSON and spit it out to the client to render.
26 Oct 2009 by dougturn
An overview of the Microsoft interoperability story for Open Source community and PHP Developers.
18 Jan 2014 by Petr Ivankov
Application of abstract approach to database domain
7 Jan 2008 by Visual Numerics, Inc.
This document focuses on the combination of VSTO 2005 and Visual Studio 2005 Team Edition.
16 Jan 2018 by Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
1 Jun 2013 by shah vatsal
25 Mar 2013 by Rajendra Kondapalli
This article will guide the developers on how you can connect to excel files using ADO.NET and modify the sheets
22 Apr 2015 by lakhdarr
Working with different data stores (SQL, NoSQL ..) in high performance enterprise application using DDD and Repository unit of work pattern
16 May 2013 by Joffrey Brouillet
This is an alternative for "A set of ADO classes - version 2.20"
6 Sep 2005 by Carlos Antollini
Simple database access using an ADO class.
21 Jan 2009 by Ross White
C++ class wrapper for ADO
3 Apr 2019 by Mahsa Hassankashi
This article illustrates how to use Node.js by WCF which is written in C# and using node.js as real time communication technology with the aid of C# code to connect MS SQL Server.
20 May 2011 by Amir Mahfoozi
Improve Delphi's TDBGrid by adding some new features to it
10 Jun 2013 by KK Kod
Developing .Net application with Mongo Db as Back end
10 Apr 2020 by #realJSOP
A rewrite of a previous article with more liquid nitrogen and bacon
7 Aug 2016 by Rahul S Chavhan
Validate an XML document in SQL Server using XSD by Rahul Chavhan
7 Nov 2007 by Syed Mujtaba Hassan
A simple, ready-to-use control for C# beginners to detect all SQL Server instances in a network and then list all the databases hosted on the selected server
10 Nov 2010 by Dmytro Skrypnyk
Using ADO for Access to XLS and XLSX files in C++
7 May 2008 by alex turner
A VBScript which creates Delete and Insert statements to backup data from SQL Server.
21 Jun 2000 by Konstantin Vasserman
How to display multiple pages of records in ASP
30 Nov 2006 by HerbD
Describes how to return tables of values as the result of user defined functions (UDF) in Excel.
5 Aug 2014 by a.alghabban
using ADO.net
27 May 2005 by Marc Brooks
Simple C# code to convert an ADO.NET (System.Data) DataTable to an ADODB Recordset.
3 Nov 2009 by Abhishek Sur
Using this article you will get the basic idea of how you could use NDepend to control/analyze your application. It allows to apply design rules and refactor code.
17 Mar 2008 by User 992674
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
2 Mar 2005 by Ach1lles
A simple technique for selecting random records from a table.
19 Sep 2008 by Valentin Billotte
The proxy generated by the ADO.NET Data
4 Jul 2013 by Khaleel Esbaitah
Models (POCO), Entity Framework and Data Patterns
9 Jan 2016 by Snorri Kristjansson
Active Directory change auditing solution. A Windows Service that stores selected AD change events from the Security log of all Domain Controllers to an SQL database.
20 Nov 2018 by tranthanhtu.vn
How to build the SPA for enterprise application using Angular2 and WebApi (RESTful)
2 Oct 2004 by Alberto Venditti
A proposed class to simulate the ADODB.Recordset behavior in .NET.
17 Aug 2016 by Michael Ecklin
Very often, Excel spreadsheets are using to transfer data between applications. CSV files are also used for the same purposes.
4 Jun 2006 by r.stropek
SSIS has a built in function for loops. In this blog article, I want to demonstrate how to use SSIS's Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e.g. name, language, version, etc.) about them.
5 Feb 2020 by Abenezer Meseret
This part is about making database connection. It starts with familiar data connection code and goes through how to use Typed Datasets.
8 Mar 2006 by KRucker
A description of how how to convert a .NET DataSet to an ADODB Recordset.
27 Mar 2007 by Sujith C Jose
Describes how to use a simple stored procedure in Visual Basic 6.0
24 Aug 2007 by The Ultimate Toolbox
An introduction to using custom datasources with the Ultimate Grid
15 May 2007 by FrankNight
This article shows an example of how to build a software component according to best practices that is customizable through code generation techniques.
14 Sep 2006 by salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
26 Apr 2000 by Chris Maunder
A simple introduction to using Access .mdb databases in your ASP pages
25 Oct 2005 by fstrahberger
Access to Oracle without tnsnames.ora
6 May 2009 by Mostafa Kaisoun
Create a new Table and re-create Table to set existent Field as Primary Key
7 Jun 2007 by callmepls
21 Mar 2005 by Venkat Eswaran
Yet Another Real Drag ASP.NET Draggable Panel like My MSN.
20 May 2009 by Sayedur Rahman
A web application allows user to manage tasks, projects & employees of an organization and also provide reports on them
15 Jan 2013 by Marco Sorich
Some guidelines for developing better MS Access solutions.
18 Oct 2009 by Mostafa Kaisoun
How to use ADO to display Tables, Fields and Records in TreeView and ListView
13 May 2011 by Mostafa Kaisoun
Using Data Report and VB6 code to design and print Invoice
2 Feb 2006 by Rafael Mizrahi, Laurence Moroney
When working with Microsoft SQL JDBC driver, you cannot invoke a stored procedure without specifying all the parameters, including the optional parameters that have default values. Learn how to fix that problem here.
26 Oct 2009 by Mostafa Kaisoun
Display, Add, Edit, Delete records using TreeView and TextBox control
31 Jan 2007 by saqib chuadhry
An article on OLE DB and ODBC API's uses through vc++ (MFC). And with little bit comparision.
1 Feb 2009 by Manish K Gupta
Encryption & Decryption of Connection Strings inside the Web.config in ASP.NET 2.0
11 Jul 2004 by aa2max
Easy Guestbook with ASP and MS Access
6 Jul 2005 by Vitaly Tomilov
Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.
20 Jun 2005 by firefalcon
The first article in the Nhibernate vs. NEO series. Introduction to NEO O/R mapping tool.
31 Aug 2005 by Frank Kerrigan
Integrate reporting services with VS.NET pages and VS.NET controls.
19 Jan 2010 by alex turner
VBScript may be old and ugly, but there are some quick and dirty tricks for which it is still really handy.
29 Sep 2009 by Andrey Chuvahin
Example dynamic configuration of DTS-packages for transferring DBF files to SQL Server with VB
25 Apr 2003 by Sriram Chitturi
This article gives a simple architecture of using StreamReaders and DataSets together to read data from arbitrarily formatted flat files into DataSets, using ini files as an example
20 Mar 2007 by Jeremy T. Fuller
A simple method that compacts and repairs a Microsoft Access database file using the Microsoft Jet library and C# COM interop. The example code is meant to be integrated into an ASP.NET web site.
20 Mar 2009 by Mostafa Kaisoun
ActiveX to display invoice in grid and edit it, print invoices as Data Report using VB6
8 Aug 2009 by _Reinhard
A simple to use tool that generates ADO based classes for calling SQL Stored Procedures. Only a few clicks, and you can access any Stored Procedure in your database.
29 May 2017 by tranthanhtu.vn
In this article, we will learn how to build and deploy the code
26 Mar 2009 by Vimalsoft(Pty) Ltd
How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File
31 Oct 2005 by fstrahberger
nls_lang when using multiple Oracle homes
25 Apr 2004 by Gymson Viente
Creating multiple selection Listbox on the fly.
25 Jan 2008 by cagatay.yildir.im
An oracle database query, schematic view and query export tool
7 Aug 2008 by Ziyad Mohammad
This article explains the best strategy to be followed while designing data storage applications by System Architects
16 Nov 2006 by KRISHNA PRASAD.N
Article to export MS DTS packages from one server to another.
28 Feb 2007 by Asim_Abbasi
ASP based with MS Access as backend, recruitment mangement system. No DLLs.
27 Sep 2005 by Eunge
DataQuicker takes the transparent level, speeds up your application building and reduces the coupling between application and database. It supports convertion from table/view to DAL directly with accessional tools. It can nearly cut off all your efforts on DAL design and coding...
15 Jul 2007 by MalakieUSN
Code storage tool for any language but developed using Visual Basic .NET 2005. Includes syntax coloring for VB code and can load via the tools menu external option in Visual Studio 2005.
12 Apr 2016 by Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table
15 Jun 2007 by alifaraze
A trick to use config file for Custom assembly in reporting services
14 Jul 2007 by daluu
Framework for porting code between different languauges and platforms through a standard XML schema.
24 Feb 2007 by Asim_Abbasi
Visual Basic 6.0 with MS Access Project. Designed for those industries who deals with aluminum parts. Such aluminum parts are used in building glass windows and are available in number of sections. This system handle Stock, Order and Consignment data.
16 Jun 2006 by zhipeng0117
This is a simple sample showing how to get a database connection using ADO to connect a dbf table.