If you are using ADO to retrieve data from a database, and your request was rejected by the SQL Server, where can your program look for details about the error?
We are all familiar with the CDatabase classes, and the CDaoDatabase classes. They are relitivly simple to use, they mesh well with our applicaiton and they are easily distributed. Using something like the GenericRecordset class (found here ar code g
1 , datafile.zip
"This sample demonstrates how to do file input and output using Visual Basic. The sample creates a new database file and allows you to view, add, or delete records in this database."
2 , dbprint.zip
This demonstrates how to print data from a database.
3 , edittbls.zip
This is an EXCELLENT example on how to edit database Tables through
4 , graphdb.zip
This demonstrates how to graph information from a database to a picturebox.
5 , ClassBuilder1.zip
Class Builder - reads SQL Server or Access database and creates a class of the selected table
6 , adoView1.zip
ADO viewer. Retrieve all columns, querys and fields of a database and put them in a TreeView(using OpenSchema ADOConnection method)
7 , imagechunk1.zip
This application will save JPG,BMP,GIF files in your database and allows you to fetch the same. Code example for saving and fetching the same in oracle and sql is also given.
8 , DBImpExp.zip
A utility to import/export Access database from/to other application formats, e.g. Excel and text files. With sample files and help, as well as ample remarks.
9 , pb_test.zip
Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures for Insert, Update, Delete and Select. Two methods for Selects are shown
10 , Employees.zip
This is a database project, for storing employees data.
11 , DBProject2.zip
New version of DBProject. Allows you view, scroll through, and edit an access database.
12 , adoview.zip
ADO Viewer,This code retrieve all columns, querys, fields of a database(Access, SQL Server, etc...)
13 , Cheques2.zip
New version of Cheques program. Must see...
14 , ADOSQLcodeGenerator.zip
SQL and ADO Code Generator. Generate SQL statement and ADO Code Connection without the use of an ADO Data Control.
15 , client.zip
This application is about programming with Client Side Cursors.
16 , AccessSecurity.zip
An Access97 security tool. Replaces going into Access97 and switching between security forms.
17 , DatabaseViewandEdit.zip
Do about anything with Access databases. View, edit, export contents to Word or Excel, etc., etc.
This is a complete database program for sales which help you to create purchase order, Invoice, etc.
19 , accidents.zip
A programme meant to add, edit,delete,and searching data. It includes how to show statistics regarding the accidents information.just try it. It is handy in studying database programming.
20 , MySQLExplorer.zip
Explorer for MySQL Data Base.You can retrieve and execute your query.
21 , ICDBaseSource115.zip
DAO based database program with many features in it
22 , ICDBSourceBeta115.zip
teach people just beginning with databases and also i am new to databases so this is pretty well commented.
23 , Diary.zip
This application everything you need.t has a CALCULATOR.It has TIME & DATE u can even set the system time
24 , L_datab.zip
The functions are for open Databases including passwords, creating Recordsets , executing SQL statements, renaming tables and many more.
25 , CodeGen.zip
code generator,The application currently generates data classes for Access '97 databases.
26 , dbexample.zip
The best part about using a MS JETDB EnGINE4 is that the DB can be accessed through a network.
27 , ComboLookup.zip
Zip Code Database Is A Program To Find Zip Codes By Using A Lookup Field.
28 , UDL.zip
This is a class that lets you create and edit UDL files
29 , qbd-dbCoder131.zip
This code shows how to take data from a
database application and place it into an Excel spreadsheet.
30 , Family_v2_upload_Apr_05_2000.zip
This is a family address book program created using
31 , datsearch.zip
Application which searches an Access database for a specified search term entered by the user.
32 , DBTextGrid.zip
This program is the modification of my previous Textgrid.Now you can Add, Modify, Delete, View, Save data to/from your database with this Grid. The grid was formed with array of text boxes.
This program creates text box array dynamically and loads the database fields onto it.
This program Demonstrates how to use LIKE operator in Jet SQL Query (uses DAO).
This project is a demonstration of how to convert a recordset into an XML format file. Its well documented and more XML stuff to come along.
This program will allow the user to select a MDB file to compact. Its then backed up just in case, compressed and then the original is deleted before the new compacted version is moved back in place of the original.
We've written this mainly for when we develop databases, but really you could adapt it for productive use too. By supplying a DSN entry, it will attempt to connect to that database and list all the tables in it. When you click on a table, it lists all
An Inventory System, you can add, edit, sort, find, delete, print, change your password and create a backup of your database
Full original RANDOM DATA INDEXING (SY-32)METHOD),Faster DATA access than a classical database application. the 1st source of new indexing method (SY-32)
This is Student Administration Project , u can administrate student through this programme in any institute when u run the programme please use password "mars3" then u can run please check it.
ADO DataBase Viewer. Can open multiple concurrent databases from seperate providers. Works with Access, SQL Server and DSN. I included the ODBC Logon from
6 so it should be able to hook up to any data provider that supports ADO.
Passing parameters with data reports. I have set two parameters and passed them during run time.Open with
A small application that shows you how to compact and repair a Microsoft Access mdb or mde using ADO (JRO).
This is simple GL ledger Project, again a database program. It has an interesting part if you click About button. Must see it.
Ado Data Sort Control will display your data from database, filter, sort (up to 3 levels) all in HFlexGrid!!!
Use ADO to convert database records into an XML file. All users must have MSXML.dll version 3.0, and Internet Explorer 5.5.
Simple application that shows how to use the Data Control to connect to the Biblio.mdb database and display all authors in the Authors table.
An SQL Query tool for SQL Server or Oracle.
Complete Database Address book With Lots Of New Facilites.....下载 Now.
DataBase Viewer is a program that lets you to look at your database files. It opens the recordsets in a table for easy viewing and also has a percents and progress bar to show the exact loading progress of the RecordSet.
This program generates a dynamic datareport during runtime without using any DataEnvironment object. I have passed the datasource and recordset properties during run time. Opens with
This is a newer version of the Edit UDL class. This version 2.3 enables you to Create, Edit and Save UDL files either by the UDL properties Dialog Box or by a connection string. The class adds some additional Properties. The Zip file contains not only the class but a sample project demonstrating the use of the UDL class.
In a network environment, open a connection to a database, retrieve data, close the connection, work with the data, reopen the connection to communicate with the database again and do a batch update.
This application reads universal data link files from disk, creates them, and saves modifications to them to a file. UDL files contain ADO connection information to data sources. Their output can be used as a connection string in your applications.
This is a full 3-tier dababase application which includes a activex dll project(business objects) and a standard exe(UI).
Application which shows how to access a password protected Access database using DAO and ADO.
Database explorer for viewing all tables and queries in a database. Also includes an SQL editor similar to SQL Query Analyzer.
ADO Database, Improved login and made the program smaller but with the same options as before just a few extra ones with the login such as write the login to the registry instead of just to a ini file also better encryption for the ini file... Now you can save your password as a number, in the previous login the encryption was poor.
ADO Database... FriendsDatabase Version 1.05 ... Updated Again, Added even more error handling and images to the listview box also added a few forms to stay on top. Some major error additions i skipped before, runs much smoother now not that it didn't before.
GREATLY UPDATED: Added much better error handling just to be safer and more neat... Also added more sound so all commands have a sound and upon loading a 3 second wav plays also included is the advanced progress bar and ocx that i found in someone elses source that is great for multiple reasons..
My first ADO database, i learned from tutorials on here specifically from Jerry Barnes so i think this would be great for people new to ADO databases to learn from but i suggest finding Jerry Barnes ADO For beginners source because it is incredibly commented on and will surely have you creating ADO within 20 minutes.
The Application basically allows you to connect to any Access Database view records of each table, along with the table design ,write sql statements on the fly(any dml statement).Most Of The Functionality Of The Application Has Been Automated. A must See..
Database application. Must see...
Cheques. Must see...
DAO based database program with many features in it, I also noticed after searching around I seen no databases that supported saving gaming info so I made one witht he ability for saving game info such as favorite game, gaming handle, clan name, clan rank...
Pizza Program. Must see...
database application shows how to use DataEnvironment in code.
This is new version of a family address book that I released some time ago. This time around I mostly use ADO instead of DAO and now the user isallowed to add or remove any category of their choice.
An Agenda which uses a text database file.
This is a database project that uses the
DBGrid control to display and scroll through all records in an Access database.
Database app. I did as a college assignment. Only simple stuff but there is some good tab strip code etc...
Database Viewer application. Allows you to view and scroll through all of the records in a database.
Access97 Database Coder. Analyses a database and writes the code required to create blank copy. Two projects dbCoderAddIn.
p can be compiled as an add-in and will place the code in a new module of the active project.
Demonstrates how to use the data control to move through a recordset.
Opens an access database using ADO and then displays all records, provider properties and error information in a list box.
An example of a bound form using the ADO control(4KB)
Examples of a connectionless recordset(2KB)
！！！！！！ Making a new SPARC program 1 。Examine the source for the sum program. The comments in the code should be sufficient for you to determine where the addition of the values read from the keyboard occurs. 2。 Create a program
指教一二。 另外我看了Notes C++ API的文档全部是E文,因为时间比较紧,我自己翻译了一些,还
翻译一段。相信通过翻译你也可以学到东西。小弟在这先谢过了。oicq=197575欢迎交流。 About C++ API sample programs This toolkit contains sever
Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code