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

A simple example of database use in VB. Not very well written but may help some people.

Version 1.5 of award winning Wolf DataGrid, fully working data grid now with many new features.

A must for the SQL Server Developer. Combines what developers use with Enterprise Manager and Query Analyser in one package as well as other features including a simple but effective stored procedure debugger, perfect for the beginning SQL developer. Search utility very helpful also. Requires 1024x screen resolution. Can handle multiple selects (max 10) at a time. Be sure to read the readme.txt file for extra features.

This is a gym application that I created for my VB class. This App. keeps track of members, employees and inventory. This program uses MS Access with SQL DAO.

links to the bible allowing searching and indexing of indervidual passages, works using sql and select statements. Program also demonstrates web browser integration and use of the flex grid and shaped forms. you can either select a bible passages or sub chapter etc... or you can enter a passage using the global format, example: Genesis 5(5:9) NOTE ALL BOOKS HAVE A CAPITAL LETTER AND SEARCHES ARE CASE SENSITIVE.There are a few bugs still in this program in relation to back to menu buttons mid wizard and stuff, so be carefull.

This project was developed to help those just starting or wanting to start usind ADO and MYSQL Database. Contains a module that creates a MYSQL database on the fly. Hopefully this will help some of the new people get off the ground with ADO and MYSQL quickly and learn the full capabilites of using this combination. Please read the Program and Module notes before running.

This zip file consist of almost all Database related stuff!!!. Some of the highlights are Dynamic Report Generation Utility with ADO coding, Chart Generation, Datagrid, MSHFlexgrid, And Much More Stuff!!! including searching databasse..... 1> Connection 2> Traversal such as MoveFirst, MoveNext, MovePrevious, MoveLast 3> Manipulation such as Add, Update, Save, Delete 4> A Complete Search Facility 5> Dynamic Report Generation Facility 6> This utility can be esily copy and paste to any of management system...as it is designed as generalise-code which works for all Management System...with little modification according to their requirement. 7> Each Functionality is well explained through needed comment. Plz...rate my work......if you really enjoyed if you want to collect more work than logged-on to http://www.vivekpatel.cjb.net

This project demonstrates how to open the Crystal Report 10 in VB 6 and assign the path of Access db. to the report file. It has uses some function in the VB, like the Formula, RecordsSelectionFormula.... I weak in commenting the code, but hopefully it help some of you. Please give some comments/ critics and vote to me. Before opening the project, please make sure Crystal Report 10 is installed in your Windows, otherwise, the project cannot function normally.

**Niro Professional Address Book** This is my second use of database. This is an address book with password protection, ect... I've worked hard so please vote! Watch up the screen shot!

This is a quiz administration programme. It was created with the military in mind (Navy) so to login you use an official number and a password.There are two groups of users, the administrators and the students. An adminstrator would have access to the questions database (being able to modify it or add new questions), he can also set the conditions for taking the test like number of questions type of questions and duration of test. Only an administrator can register or modify or delete other users. He also has access to all test scores and can prune the database. The questions are stored according to subjects and could be in form of True/False, Multiple Choice or Short Answer type. Each question can be associated with a picture. A student can either take a test of check his scores. All users can change there password anytime. Even though the application was written to suit the military it can easily be modified. Please leave you comments and views, as I am sure I still have a great deal to learn. I have indeed learnt alot from this great site and most of this code can be traced to this site. I am really gratefull to all members of PSC.

Demonstrate the use VB/ ADO to connect to a mySQL server/database / table. Show the records in MSHFlegrid. You can also user sql statement to customize recordset

Whith this class you can load a lisview control with a recorset, and export the data to the TXT, CSV and HTML Format, you can use or not the progressbar.

The purpouse of this module is to backup and restore mysql databases within a Visual Basic program. Please, don't vote for this one... It is a remake of http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=57138&lngWId=1 which inspires me. It has some improvement on his code: Basically, it take the table creation statement directly from the MySQL engine (so now it publish constrains and indexes correctly) and perfom only on insertion statement per table no matter the number of rows in the table. Also, it prevent MySQL from generating errors because of the constraing and block the tables before the insertion process. Also, it could allows the programmers to give feedback to the user about the process and, last but not least, it is IMHO a bit cleaner.

This code will copy all fields from all tables in a database and add them to another identical database. My company has Rep submitting database reports all the time. I need to append the data from the reports database to a live database. At first I was running querys I had made in the database but our file structure changed and that was no long an option. This is about as simple as it gets but someone might find it useful.

Simple Database Application with find function.

This is Easy. Very Easy. 10 lines of code, 30 of comments. I'm sick to death of trying to find simple, concise code that tells me what I need to know. This is an example of how to access a SQL Database from VB, and how to use the data returned.

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 application will take any table from any database, and converts it into a HTML page, with nice looking tables. I have included a database with the entire 2000-2001 hockey season schedule as an example. The user can then view the schedule for any given date and convert it into a HTML page. Good idea if you're a hockey fan and want to update your page with the games scheduled for the day. Please remember to vote for me!

Haven't made a visual basic program for a long time. Made this for a place that I work. I haven't finished the program yet but couldn't wait to see any comments you make.

It explains the basics on Database managing with ADO using Datagrid.