Results for "Category: Databases/ Data Access/ DAO/ ADO"
The purpose of this example is to connect/display database records (using ADO) with a simple listbox. This is a work around to using bound controls. You will find your apps will run faster.
The purpose of this app is to show some basic operations on databases using DAO 3.51 . Very good for begginers.
Allows user to connect to database(Access or SQL Server), view schema(tables, fields, databases). It's main feature is to allow the user to point and click their sql queries using an updatable text file containing sql constants and a treeview of the actual database. Please let me know what you think.
This code demonstrates a simple way to save Images (or any binary data for that matter) into a database... I would like to receive all kinds of comments and suggestions so, please give the same...
A report wizard which allows users to create their own simple reports and outputs them to a word doc. Includes sorting and criteria. I have modified this from Oracle to Access for demo purposes. I am also still working on it so any positive feedback would be appreciated. There are a few more things I would like to do like sort the Criteria operators according to datatype with, add totals. Feel free to use and modify. If you come up with anything good send it on!! This is the first app i have uploaded so I hope it works!!!!! Please read the attached readme file as there is a few things to do before the app works. i.e. add a query to a database.
Backup and Compact a MS Access database file (*.mdb). Output a *.csv (Comma Delimited)File.
DataAccessDLL's SUCCESSOR - as a control. GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the CTL with an 'INSTRUCTIONS' function.
A complete database application. Sorry, but the program is in Portuguese(brazil), I'm uptade to English soon. It is Intermediate because the code is not commented. Please vote for me or leave a feedback!
Dates in SQl queries often cause problems, as the date must be in the ANSI format whereas dates brought back can be in a different local format. This function simply returns the date in the required format and save having to type Format(DateString, "mm/dd/yy") every time.
Convert a database table to HTML
This simple little function just returns the total number of records in a ADO recordset.
For ADO database application: To show (1) How to use ADO schema to obtain a list of tables of a database. (2) How to provide a re-usable single form for any MDB file name, and with another form to display as many tables as there are in that database at the same time. Otherwise, you will have to repeatedly create/refer to an instance of connection and you may need 10 forms if there are 10 tables in a database (see "3"). (3) The possible techniques to enable opening several tables on the screen in the same session, yet without conflict (otherwise if you create 10 instances of the same form, some common event handlers will mix up Table B as Table A, e.g. when calling yet another form. But with appropriate techniques, this conflict is avoided). (4) How to display various properties/attributes/status in descriptive text(pneumonic), rather than the VB's original numeric codes. Note: MS TreeView itself limits the node count to 32767 only. (For a comparative study of DAO, refer my DBofDAO)
The code purpose is basically to show you how to add multiple files into one single archive structure and to be able to extract the file successfully without no loss of bytes. Any size files can be added in. A swap techneque is used so that in a loop only 1 meg of data is extracted from the file, plus also to save more memory instead of caching large files into memory. I've kept the code basic and easy to use because this is how coders like it. Functions are easy to extract from the code and problems are easy to minipulate.. not saying their is any of course. I've managed with a larger project to fit over 70000 files into an archive with no archive damage or errors, but after that amount of files the speed of file look up does get pretty slow, lol. This is optimized for all versions of vb I believe so it's a good piece of code. Please rate, comments would be good. Thank you for the input. Ps this code can be classed as a file database in a way, you just need to know how to implement it into your applications. Same goes for information instead of files adding, all you have to do is modify the functions to fit specifications.
Connect to SQL Server Database ,and see all tables and columns in Treeview , Datagrid. All Stored Procedures ( Names and Texts of SP ) , Triggers ( Names and Texts of Triggers ) Views ( Names and Texts of Views ), Defaults ( Text and Name ) , Constraints ( Text and Name ) Primary Keys ( relationships ) , Foreign Key ( relationships ). Search Engine , Combo1 > TableName | Combo2 > Column Name , Criteria >> with each letter (or any other character ) you type , you will narrow the result. Direct Connection to Enterprise Manager ( with SQL Namespace object lib ) . You can perform full administration and implementation of SQL server and every Database ( if you have those rights ) : Create Trigger , Stored Procedure , Role , Rule , Default , User def. Type. Find out about Table Properties, Permissions , Dependencies,Delete Table. You can use EM interface for Generate Scripts , Manage Indexes . You can call EM interface for managing SQL server security, New Db user, and use EM's wizards for Import and Export DTS . Everything is commented and Constants are attached in two Word .doc files. With Query Builder you can perform very complex queries , Create tables , Update , Insert , Delete . It supports T-SQL commands , so you can perform (almost) everything as you can with Query Analyzer. Sample Queries , are attached as comments inside module. How to manipulate , easy , with more recodsets at the same time. Practically , this is simple console for administration and implementation SQL Server database ,with using full power of EM. I hope that You can find this app. useful . If so , vote. Thanks.
New to ADO? Worried about ADO? This little subroutine gets round the problems of opening ADO recordsets. Please look elsewhere on this site for info on opening the database itself. If you open a Recordset in your code, ADO expects you to close it before re-opening. But if it's not open you can't close it... (Oh My!). Here's my solution. It requires a public ADODB.Connection - I call it gCn. The routine will open a new recordset (compatible with Janus GridEx), or refresh it if it's open or if the SQL has changed. Optional ReadOnly argument.
This is a simple generic wrapper class to quickly general ADODB Connection strings, including password protected files & shaped recordsets. I've only needed support for Jet & xbase files so that's all I've included. Please feel free to expand and post them as long as I get a copy of any changes.
Small but has everything: Ado 4.0 Access2000 Database; Adding, updating, deleting, editing and printing. 2 different kinds of searching ( 1 thru a listbox, the other 1 thru a textfield ). Microsoft Outlook 2000 support included. (creates a new mail). Database infos given are recordcount, recordposition, databasesize.(in kb) All images with tooltips. Appl. has been tested and works. -------------------------------------- "Its not a bug, its a feature" (Epic Games)
On a machine where the Adobe PDFWriter is installed, the current printer is swapped out with the PDFWriter and the PDF file is created. The original printer is then restored.
This is a simple usage of database as long as VB and MS Access are concerned. But you can certainly use this on your literature class. Zip file includes a database containing more than 200 biographies of classical authors.
This code is a great help for those people without Microsoft Access and want to administer their Databases easily. Includes full source code. Shows all records at a glance, allows editing, adding and removing. If you like this please support me.