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

I am doing a project for a retail system. In the design time, I need a command button for simulate the pageup and pagedown function for flexgrid. I have found no code reference for this function, so I post my own code here to share with you. Your feedback is welcome!

Very simple application that stores information about software. Stores Title,Serial#/CD-Key, Company/Author. Most significant thing is the use of DAO 3.6 to manipulate the database and write the report for printing. Code is commented, and clean. Limited error-checking and input checking. I do not plan on doing much more with this program, other than use it to keep a list of my own software. Please give me comments, votes NOT needed or requested.

This code lets you add a new table to existing database in SQL Server programmatically. Useful when developing a database application for off-line users. Simply send an executable through e-mail, and let it run once.

This project demonstrates a number of important ADO Data Base - VB methods and utilities. 1. Paramount of these utilites, from my perspective, is how to get the totals from a database field as well as how to multiply the items in two DB Fields and then create another field to show the answer. In addition a running total is kept, showing the Sum of the multiplied fields. This is a feature that any inventory data base requires. 2. Make an ADO Connection without using the ADO Data Control. When a program uses the ADO Data Control(s) it hard connects the data base to a given directory ("C:\My Documents\MyDataBase.mdb"), or worse yet the directory that the program is design / built in; (C:\Program Files\Microsoft Visual Studio\VB98\MyDataBaseProgram\etc"). This connection causes havoc when the product is installed to a client's computer. Of course a work around for this is to make a DSN Connection, but this requires the inclusion of numerous files in your setup/install program. When the connection is made through the use of code as opposed to using the ADO Data Control the Database file is located / installed in the program's deployed directory and is easily connected to. 3. Deploy and show all of the data using the MS DataGrid Control. Program shows how to fill and set the Data Grid. This demo allows adding and deleting of records directly on the Data Grid (Although this method is not recommended due to lack of ease, the better method is to use the programs Text Boxes). 4. Program sets up a TextBox and recordset movement procedure that emulates the familiar data control methods, i.e., The user can move through the records - movement is apparent in both the Data Grid and the Text Boxes, and the Current Record and Number of Records are continously displayed and updated when records are added or deleted. 5. Program makes use of the MS Report Designer in lieu of Crystal Reports. I have used Crystal Reports in the past and had numerous problems. I now use the MS Data Report exclusively. If you have any questions/problems with this demo it will be in this area. Study the DataEnviornment and DataReport Designers Structure

** PLEASE VOTE FOR MY CODE - EVEN IF YOU DON'T LIKE IT ** 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 DLL.

Generates Insert, Update, Delete and Select stored procedures for SQL databases

This tutorial aims to provide an intermediate Visual Basic 6 user with the basic skills required to retrieve and manipulate data from many commercial databases and any ODBC compliant database using the Active Data Objects technology. It includes a sample project and a full tutorial in Word format. The html version can be seen at http://users.tpg.com.au/jaqmar/adotutorial.htm.

a simply sort on de collumsheaders of a datagrid

SQL Server Enterprise Manger clone (demo only, not complete). This demo can demonstrate that how to use SQLDMO to create your own SQL Server Enterprise Manager which may perform every job the Enterprise Manager can do. In this demo, the following things are included Enumirating SQL servers on the network Logging on to any Selected Server using Windows Authentication or User Name and PWD Getting List of all Data Bases Getting List of all Tables Getting List of all Stored Procedures Getting List of all Users Getting List of all Views Getting List of all Roles Getting List of all Rules Getting List of all Defaults Getting List of all User Defined Functions Getting List of all User Defined Data Types Getting List of all Accessing properties of each object listed above like date creation, owner etc. Creating New Database Creating New Table Creating New Stored Procedure Deleting Database Creating Table Creating Backup of Database Restoring Backup More things can be done by understanding the way these things work. Not very hard, just simple It will work only if you have SQLDMO Library, If you have SQL Server installed, then it will work definatelly Sameers (theAngrycodeR)

Please check it out. It is a good tool.

New and improved database application for storing Serial numbers and CD/Product Keys. It uses DAO 3.6 (part of MDAC, downloadable from Microsoft) flex grid, simple encode/decode function for keeping the database "secure." Let me know what you think, I dont care about the votes. Sorry, but I did NOT include ANY actual serial numbers or CD/Product Keys.

Exaple of using MS-Chart control and ADO database. Load data (by projet id, by dates) into 2 dim array and graph it. Ability to Save/Print/Copy graph .

Creates a Microsoft Database (MDB) on the fly and adds tables dynamically in Visual Basic. The program needs a reference to Microsoft ADO Ext for DDL and Security.

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.

This code makes easy the creation of databases and tables in a MySQL Server.

A very fast way to fill or populate a MSFlexGrid control with a Recordset 18,000 Records / 2 Sec.

The JC Persistence framework is an abstract database layer that manage transactions in a transparent maner to the developer in any relational database, focused on Object oriented programming, mappings your objects with the database through an XML configuration file.

This application illustrates basic manipulation of the treeview control like populating a treeview with items from a database, expanding the treeview nodes manually by clicking or by automatically by code, searching a tree for an item and others. This also illustrates how to simply create a splitter by using pure vb code. Please give feedbacks.

Class object that can be compiled or copied and pasted into your application that will dynamically create ODBC DSN's for you.

This zip file consist of complete Database and Report Utility with ADO coding, Highlighted Functionality is mentioned as : 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