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

shows how to send datagrid data to report thru a recordset also how to autobind recordset fields to report. This is my first submission. hope u guys will like it. i really like to hear any comments.

Here is a list of this control futures: 1. Login in to MS SQL Server 2. Backup, repair and restore databases 3. Upload databases and delete databases 4. Control the server (Start, Stop, Pause and Continue) 5. Check Server Status (Started, Stoped or Paused) 5. Check connection if active to server or not 6. List databases in the MS SQL Server, list teables and fields in table 7. Open connection with database and SQL statments (like select) 8. Save any file to Binary Field in table (like upload picture to table) 9. Display picture saved in database field to object (like Picture control) 10. Save a file from database field (like picture or txt files) to harddisk 11. Check if EOF or BOF 12. Find any record easy 13. Add, Edit, Update and Delete records 14. Bind the database fields to VB Objects (like Text Box or Label) 15. Bind the database table to MSFLEXGRID32 control 16. Handle All errors easy (no visible run time or desgin time errors), all hadled by name & num. Its the easiest, coolest code ever seen! You can learn even how to upload and download files from MS SQL Server! Its learning control and can be used for your projects as well! I hope you like it, if yes, please rate it, thx anyway! :)

Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox, HTML.

This source code permits to connect to a DSN ODBC connection on a remote computer running dbTCP. THis can be very useful if ODBC licences are very expensive (I had the case).

This Program explains how you connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE and Table Description. please Check Out subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one. Check Each and every code.

to easyly find edit and store unlimited phone numbers

Compact Access Databases with one line of Code! "One line of Code", like this: ;-) CompactDB Database, ShowResume, Password or this example: CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" Private Sub CompactDB_Click() If DB Is Nothing Then 'the database is Closed CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact Else 'the database is open DB.Close 'close CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact [Call your Routine to load database] 'Open database End If End Sub Works fine with Access 2000 and XP Actual Revision - Jan/20/2004 Jan/20/2004 · some Form changes. · fixed some variables declarations. (Variants in place of Strings). · added Compact Password protected databases. · added some Comments. · added some Code examples. · added a compress level indicator. Jul/25/2003 · Initial Release

Hello guys!!! This submission is a complete OLE DB Provider Guide. Many beginner database programmers out there don't know how to connect there application in defferent database, in lan and even in a remote. This guide will help you a lot coz it gives all example on how to connect to a database using OLE DB Provider. Pls. Pls. Pls. Don't forget to vote this appliction.

shows how to filter a datagrid by selecting option buttons. useful to search multiple entries with a criteria. here i have shown how to filter payments by Due, by Paid, by student name etc... Hope u find it useful.pls vote.

This is an updated version to (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=53106&lngWId=1) It is quite out of date: 1.I found it years ago; 2.it is first written in 1992 by Ethan Winer; 3. seldmom people use dBase nowadyas. But I picked it up last night and decided to make it better: wrap it into a handy OO class, support for all character-sets, tidy up all the codes that strictly follows the coding standard. Changes: 2004/4/13 15:05 GMT-8 1.mimics part of the ADO mechanism(MoveFirst/MovePrevious/MoveTo/MoveNext/MoveLast/BOF/EOF) 2.State(Open/NotReady) 2004/4/14 09:55 GMT-8(v3) 1.all long types to support as more records as possible 2.built-in all field types

a Crystal Report TTX example Shows how to create a report using TTX files, that is you dont need to specify a fixed database for your report. It'll be based on a simple TTX file. Using this you can pass an ADO recordset to the report at runtime. This method solves great deal of problems for many crystal programmers who will benefit from the simplicity of intergrating their report with VB. The report will execute even if the database location changes or renamed. Only you hav to do is change the connection from VB. [supports versions 8 & above.] Read the step by step tutorial and the official crystal guide to TTX available at http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr8_ttxado.pdf.asp if you like it,dont hesitate to vote :)

Allows you to programmatically create an ODBC connection to a MySQL database using the Registry API.

Recovers an Access 2000 password

Sample of using VB access data from a MySQL database (Create Table ,Add ,Edit ,Delete ,Search ,Show and Upload Picture) for beginner. Tester with mysql-4.0.18 for Win32 and MyODBC-3.51.06.exe ***MySQL Server configure (set to no password) username:root port:3306 database:test

This Program explains how to connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE. Also featuring subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one.

A solution for who does not want to use ADO/DAO or ODBC to have access its database in MySQL. With only one DLL you it has the power on all functionalities of the MySQL.

Hi, This project gives you an idea how to access ORACLE through VB and ADO. Project describe How you interacting with ORACLE Table, view, Stored Procedure, Type, Package, Package Body, Synonyms, Sequence etc. I developed an Active X Skin which is used throughout the project. If you want to test the Skin just put the controls (OFrmCtl, Edge Right, Edge Bottom, Edge Region) in a form and run the project. Please close the project from FORM CLOSE Button, otherwise IDE will be crashed. Please check all the menus and form. Now, I’m trying to develop this project in Visual Basic.NET. Resize the form From X Axis and Y axis. Check it out. Using of My developed Active X Skin and other components are strongly prohibited.

Add any BLOB you like to an Access database. For example, add pdfs, docs, mdbs,zips etc. All the different types are displayed in a tree view and you can view them by dragging into a frame and launching their respective application.

A simple PIN Generator with access database. Try it!!!!

[Updated 27/2/05] Make your recordset universal! Use this class to export ADO recordsets into the industrial standered [csv], commercial standered [html] and the power user standered [Excel]. This is an updated version of my previous work, now complete Events, Properties, Documentation and even more options! Fuly optimized and commented. All bugs fixed. A must have for any database devoloper and a must add to any code library!