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

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

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...).