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

This zip file consist of Data Fetching into MSHFlexGrid without using DataEnvironment that is with the help of ADO Coding...This code will also help you in learning how to fetch data into DataGrid, DataList and Database Fetching Controls. This utility as designed for beginers it is FULLY COMMENTED. It is designed to fit into any Managment System Projects. This Zip File also consist of API which explain how you can open weblinks and some tips.... Pass your Suggestion to me....also link to http://www.vivekpatel.cjb.net to find more database related work.

This is a simple Database i have been created it for a factory , its works very nice i liked to share the codes in planet source wish you like it (WITH ACCESS DATA BASE!)

It dynamically writes the code needed to create a new tables/fields in an Access 97 database. You simply add the new fields and it writes the code. This is particularly useful if you have an existing application and wish to add new supporting tables when you release new versions of the software. Uses CreateTableDef and CreateField. This utility has saved me a ton of time.

Use one generic sub to fill all comboboxes or listboxes on your form(s), with data pulled out from database.

- how to use the ADD-In manager (Read Readme.txt) - How to Use ADO Command,Connection and Recordset Objects - How to Load Data from a Database to a Combobox - Using ADO Recordset Find - Properly Close a connection - Set A DBGrids Datasource on Run-Time - How to trap when user clicks the x button of tour Form - Record Navigation with Error Trapping - Using OLEDB Basic - Use With Command to save Time - Use ADO via Referencing or Without Control - DSN Less Database Connection -approximately 1440 twips to a logical inch or 567 twips to a logical centimeter (correction on my Comment :))

Create SQL Insert scripts for Oracle, SQL Server (not 100% tested for SQL Server) to populate a table. This was a quick and dirty tool to allow me to provide data from a test database to a client who did not have a DBA. I would e-mail him data scripts and he ran the scripts. Great for populating databases. There is room for improvement and I have done about all that I want with this.

For people who still use the DAO data control to acess MICROSOFT Access Databases , Here's what's been missing from the control , A way to access a database with a password

[ADODC IS E V I L!] Have you reached a stage when you realize that the standard ADO Data Control Shipped with VB is not enough for you?? Ever Wondered How You Can Connect To A Database with code? How You Can Read, Write, Delete, Change data in Tables ? Well, Here's a small Application which uses ADO Code to manipulate data in a table. I've also included code to Enable or Disable the Command Buttons in the Window based on the context (For exampling disabling First & Previous buttons when you are in the first record...).

Make MSHFlexGrid Editable without help of any textbox or other control

use UDL file instead of a connection string edit / create and test your UDL files from witin your app there is NO error trapping in this code you have to add your own

UPDATED - 11/10/04 This is a Contact Management System for all those who would like to track Contacts, Projects, Appointments, and much more. A few of the features are: 1)Contact Management, 2)Project Management, 3)Appointment views by Month, Week, or Day, 4)Notes & Calls management, 5)To Do item management, 6)Various database utilities - compact, repair, backup, restore 7)Popup To Do & Appointment reminders 8) Query Contact & Project user defined fields. View "ReadMe" for specific update features.

For handling books,members and all library related stuff for library managment system

if you clicked on the name field , a listbox will drop down to choose from it please rate this program

Finds SQL Servers on your LAN

I had a datagrid which I needed to output/print, rather than go through the whole printing process I decided to try export it. This code takes values in a datagrid - populated from an access bound datacontrol, and exports the datagrid to a csv file for input into excel.

Open a password protected MDB using DAO or Data control or OLE automation

How to load DAO objects on runtime, open database and select the DAO version from installed ones! Big news for VB5.0 & 6.0 DAO/JET Access97 database application makers: Capacity to select the DAO/JET engine version on runtime! This is my new invention how to load a "installed" version of DAO in runtime. Also this shows how to use DAO as runtime created object! Tested this in VB5.0 And VB 6.0 The coal why to develop this is solve a potential DAO 3.5X App break when a new install of Office 2000/2002 removes the registry entries of older DAO's. This is the number one end user tech support issue in DAO 3.5x referenced applications, even if they are carefully made! The problem might rise again more when people are installing Office 2002 after your app was there. There are two demos how to use this when the System.mdw file is in effect and second sample for unprotected databases. See file: Readthis.txt in the zip, The instructions and exceptional are explained there!

Demonstrates how to add, edit, delete records in a database. Uses ADO for connection. Treeview is included to view the records alphabetically. User has the option if he wants Automatic treeview refresh or manual (see option buttons in snapshot above). NOTE: This is for real beginners.

Counts all valid curly brackets in a c++ source file. Tells where a file's brackets may be out of balance OR tells the user if the brackets are in balance.

A simple hospital system. Can add, update, retrieve and delete records like patient, ward, employee... I think it's helpful for those who want to know about how to update and delete record. Please give your comment so that I can improve on it.