Results for "Category: Databases/ Data Access/ DAO/ ADO"

This Program generates ADO code and SQL Statements without the use of an ADO Data Control. It is available as a stand alone executable or as a VB-6.0 AddIn.

This is an Addition to my earlier search function. This is an ActiveX control. It has 9 search functions, inculding rich text box searches, and text box searches, DAO table searches, and Find and Replace searchs for all three. Has a readme file, that explanes all. If you find an error, let me know. This is my first try at making Active X controls. Please leave feedback!

Excel macro that extracts all tables, fields, field types, queries & descriptions from a JET/Access database. Very useful for documenting Access databases.

Converts a SQL statement into a string that can be copied into a VB program as a string. Simply paste your SQL statement into the text box, click the button, and the SQL statement is copied to your clipboard ready to be pasted into your VB source code.

GoXML is a wrapper class for MSXML 2.0 / 2.6 / 3.0 / 4.0, offering access to some of the more basic elements in your xml documents. Use GoXML and easy-to-learn XPath to open, create, modify and save XML documents without a hassle. Don't worry about available MS XML Parser version, GoXML will autodetect it for you! The included code sample illustrates the use of all methods and properties. PLEASE VOTE OR COMMENT, THANKS!

This project demonstrates populating a Microsoft Access database dynamically into a treeview and listview control, by using loops and arrays. Also added the common Add/Edit/Update functions into the database for those who wish to learn the basics functions of ADO. Another purpose of designing the code the way I have with objects is so you can reuse the listview and treeview modules just in case you wanted to load the same information into another treeview or listview control, with out adding extra code. Once any database is loaded you can also edit the values in the treeview with the label edit functions. (F2). anyway there are lots of code samples available in this project. if you like this code please vote. Thanks.

Lists records into a listview control using basic SQL Statements.

Heres a good example of using a winsock control to access a ADO database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control. This program is simply for basic job tracking, from inhouse, and for remote access areas. Bascially how this works, It sends the server a few commands/strings, and the server generates the sql statement and sends back the results, to the client winsock application, it then recieves the information and displays it out into a listview control with columns. --------------------------------If you like the code please vote!

This Project Allows the end user to access a MSAccess Database through a Client Winsock application, without having any Data Access Components installed on the local machine. This also allows fast read/write access through modem, or a dead slow computer. The client app sends the server a few strings and then generates an SQL statement, and then does all the hard work and sends back the results to the client.

Heres another good example of using a winsock control to access a ADO database over a network/dialup connection. This project shows how to Add/Delete, Read/Write access with ease. Also I have inbedded authentication against the database via the winsock control. This project gives you the functionally to store and retrieve data remotely and keep track off multi-users online with up to date online and offline status's, into a treeview control. you can create personal folders and use drag drop features to move messages around (remotely). Also allows users to compress the database to keep hundreds of message clean and tidy. also this code shows how to export messages and send internal messages to the server to be export by email, by a internet dialup connection. Now works with Windows NT / Windows 2000. email me if it doesnt work. chris@hatton.com Please Vote....

This code is the beginning of a library circulation program. Two of my freinds and I woked on this. It doesn;t have many of the feature implemented, but Take a look, show different was of accessing databases. Login:David Smith Pass:98022 The Use Administration >Books to get barcode numbers And use Administration > Patrons to get patron Numbers Then Use Signout. Try double clicking on a book Please send any comments to the feedback or daveismith@hotmail.com

zwo routines for easily retrieving Table- and Fieldnames of MS-Access-Databases

This code will teach a user how to save their data and also how to retrieve it. Very easy to understand if you read the ' comments. :) Enjoy!

Connect to text file(s) and perform advanced queries using ADO. You can even return recordsets on CSV file without a header.

This sample project shows how to scan a network for all domains, then list either all servers on the domain or only the SQL servers on the domain. It uses the NetEnumServers API call and a NetEnumDomains function found in the NIMM.bas module which was originally written and posted here by *Patrick Herbst*. The NIMM.bas module has a TON of features for network management. FANTASTIC JOB Patrick! Thanks also goes out to Michael Monaghan for directing me to the posting that LED me to this solution. Even if this sample is the greatest thing since sliced bread to you (doubt it), please do not vote for this module, 99 percent of the REAL CODE was not written by me. I used alot of ideas from alot of authors (including Microsoft's technical articles).

3-TIER Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures in a 3-TIER ENVIRONMENT USING VB CLASSES for Insert, Update, Delete and Select. This project runs on Northwind db.

A article showing how to create a global ADO connection to SQL server from a Visual Basic Client.I have more examples and programming solutions on my web site www.SQLwarehouse.com

Connects a Data Grid control to a data source using Datalinks and an SQL statement.

Populates a treeview with a database's tables then uses the node click event of the treeview to populate a data grid.

There has been a few questions on how to use VB to connect to a mySql database. This will show you how to connect without using a DSN. Most of the code is from a ADO Tutorial from this site. I just modified it to show how to connect to a mySql Database.