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

A VERY simple guide to aid the beginner in creating a simple database.

Example shows how to connect to an Access database; browse, add, and delete records.

This is a real simple demo on how to use Inet's sockets.. This will make Inet run a lot faster when you need it to execute a lot of stuff at the same time.

I worked really hard on this for my VB2 college class.. I got a REALLY good grade and even my teacher said it was the best she has ever seen.. I am really proud of it and I hope to get more out of it by giving to everyone to help them out on ideas and what not. I spent about 100+ hours on it but it's not perfect. Had a last minute crash and had to do some crappy coding.. But, I spent most of the time on the GUI.. It uses Flash, Nicer Looking Buttons, CoolXP, Listview, MDI, etc. I hope everyone enjoys it! Please, Vote or Comment! Thanks...

If you hate Microsoft DataGrid and you dont need, cant find or dont have $300 for other grid then you are gonna love this ;). This is an activex control made in vb to replace bug-plagued DataGrid that you got with vs6. It is pretty fast, supports many things that are left behind in MS DataGrid and it is open-source (though not for proper distribution for now). Have a look at screenshots if there are some (psc might not allow me to upload them). There are some examples included on how to use the grid. It does not matter what drivers are used since this grid uses t-sql for reading/writing data. For now it does not support built-in editors, but that is to be added in next version. Just download the example and experiment a bit. If you need any help on using the control post comment here and I will be glad to help. This is first version, so please post any bugs you may find.

This sample code is an example of how to put text and graphics into a richtext box on a form and then save that information into a database. The example uses MS Access, but should work with SQL Server as well. I needed this for a specific purpose and when I could not find any examples, I created my own solution. Use this however you like there are no copyrights on the code.

Using this code You can easily backup your sql database. There were some code here that used ADO for the backup purpose, here in my code i have used the SQLDMO object for all the sql transactions. Few code are taken from here and are upgraded with comments. Hope you all would like the work

Database Operations Using Automatically Generated Class This is demo application that demonstrates powerful database functionality of database class automatically generated by CLASSter 2.0. Demo is for MS SQL Server, but CLASSter supports now MS Access, Sybase and Oracle server. Powerful features implemented by class - executing stored procedures, parameterized SQLs, multiple recordsets, batch execution, XML processing. The class code shows full implementation of these features

Unfinished video rental proj.(currently working on int) Shows you how to make your code multi-tier ready, reusable, how to use class, how to dynamically add toolbars, this is kinda basic but will help begginers to intermediate! I like the way PDSA codes that's why i pattern my code to them :) Begginners if you like my code or learn from my code pls. vote!

Clinic Management for Doctors

it is hospital lab management system,manage the patient profile and their diffent Test record

Flex Grid is Made to be More Flexible. A editable Flexgrid with textbox moving along to cells on a click or a cursor movement:)

Tired of seeking through your hard rives to find Access databases, to compact them and gain some free space? Then this tool could help you. Basically it parses all the directories and sub-directories of a given hard drive unit, and tries to find Access Databases. When this operation is done, you can repair or compact them. I gained on one of my HD unit over 6Gb of data. What you need to make this project work: vbalSGrid6.ocx and ssubtmr6.dll fro vbAccelerator. These files should be in the libs directory. If ever they had been removed then, just go to this url: http://www.vbaccelerator.com/home/VB/Code/Controls/S_Grid_2/S_Grid_2/VB6_SGrid_2_Binary.asp 1- Open a blank project. 2- Goto to project -> references and select ssubtmr6.dll, it should register it for you. 3- Open your the test project (an error should appear), then goto project, components, and select the vbalSGrid6.ocx 4- close the test project. 5- restart it it should be ok. You'll also need Microsoft DAO 3.51 or 3.6 (depending on the Access version installed on your computer). Generally 3.51 works well with Ms Office 97 databases 3.6 or above should suit best to newer versions of Access. I'm currently using Ms Office PRO 97, and thus for referenced DAO 3.51. If you have troubles or do not understand how to make this thing work, don't hesitate to send me an email.

This inventory system for tires include: Administrator Password, User Account, Tire Maintenance with Category, Tire Size and Tread Pattern Data Entry and Data Report, Customer Maintenance with Data Report, Sales Invoice with Receipt, Printable Monthly Earnings and Order Slip Form with Supplier Data Entry. Made with ADO. 100% working and bug free. *Administrator password is "DBMS"* VOTE OR DIE!

Updated!! Ado project now supports multi-user connections and is much more stable than ever before. if you have more than one connection open, the server now refreshes all clients connected when a new job has been created or modified. Server keeps a real time status of active and disconnected users, great great over vpn, or internet connection. ADO Project allows remote users to access a 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

CompactAllMDBs is a Microsoft Access 2000/2002 (XP) application that will (1) Search for all specified files (default is .MDB and .MDA files) in a specified directory (and optionally, in all subdirectories below it) (2) Display all such files found in a listbox with their sizes (3) Compact all the files it found or only the ones selected from the list by the user (4) Search for the same files it found the first time and compare their size as compacted with their original size, to see how much disk space has been reclaimed It's handy to keep your ever-inflating MDB files of a manageable size, and it works nicely on networks. This can't really eb smoothly ported to MS Access 97 because it uses ENUMs in the code, which isn't supported by VBA in Office 97, to my understanding. Also included: (1) A simple routine for calculating and displaying elapsed time for the process down to milliseconds. (2) A "Browse For Folder" routine, based on a Windows API call (I originally wanted to make this start with a specified default folder, but I haven't had a chance to figure out how to do that yet) (3) Uses the Access (2000/2002) routine to Compact and ReCompile the application when it's closed down. In your VBA code, this application requires a Reference to MS DAO 3.6 library If you have any comments or questions, drop a note to [email protected]

Binary Search Tree Nodes Class - an effective and very fast searching/database storage methodology. This is a self-contained binary tree class along with a non-gui listbox class to create, search and maintain any unique key data in a binary tree. A lot of databases use this methodology as the basis for their database engines. Now you can have the database power inside your application. For example, a search of 3,000 keys will only require an average of 7-11 tree visits/seeks regardless of the key your are trying to locate. Also included are member routines to output all the data keys in tree in alpha order or even in reverse alpha order. This has been extensively tested for reliabilty and fast response for searching, insertions, deletions and traversals of tree nodes in general. Included root node release, tree re-balancing and garbage threshold detection and collection. Also extensive notes and a built-in commented example project/form to build a couple of example binary trees which output to a gui listbox. Also to demonstrate some of the class member functions usage. You may be surprised to learn there is little emphasis on recursion so no worries of runaway stack levels.(**IMPORTANT**: this latest version includes a major bug fix. When using the data index to reference external data, during a tree rebalance the data index was being lost or mixed up with another. It is a simple fix but significant to keeping the database integrity. This latest version is 1.1 and also includes the functions referenced in the supplemental article). ## LATEST: ## now includes a CD,DVD,Books Media Library application sample. ## (c) David K Richmond

Supplements existing article by similar name and by this author. This is a new release and includes the extra member functions in cBSTNStorage.cls in order to allow node removal. (INCLUDES major bug fix to preserve data index during node removal).

This sample shows how create Excel file using ADOX. In database apps when ADO and ADOX is used it's simple way to create 'Excel reports'. Using ADOX is about 3 times faster than Excel Automation. If you find this code useful, please vote...

adressbook well commented databse