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

View the contents of a dBASE file (.DBF). Good example of how to use ListView and ADO together. Code can be easily modified to handle MSAccess files or even CSV files. Only thing particular about dBASE as opposed to other databases is the manner in which the Connection and SELECT strings are created. oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _ "DriverID=277;" & _ "Dbq=c:\somepath" Then specify the filename in the SQL statement: oRs.Open "Select * From user.dbf", oConn, , ,adCmdText Hope someone finds this useful ... Cheers

SQL Navigator is a very good Demonstration of Viewing the Tables, Views & Procedures present in SQL just with the help of some SQL in-built functions through ADO. It will show you the data in the table & even the text of the Procedure which you had made in SQL. Might be unknown to someone how to use the SQL functions through VB just by passing them into the recordsets. It can be used very well by making an application. It is very small easy to understand, fast & hey.. dont forget to rate my code...!!!

This is a Registration System, it has two application, the client and server. It uses ADO connection and Winsock. You can add, edit, delete, view a record. The server is password protected. I also included a chat. Other stuff are Minimize in System Tray, Compress Database, Install on Startup, also every action made by Client is log in the Server. The Help file is included. Please vote first before downloading this code. Thanks to Chris Hatton for the Ado.

This is a payroll system, register new employees and gives them employee no, validates each & every entry. each month, operator can select the Employee ID can generate the Payslip. This is very perfect Payroll System, you should use this, learners will found it extremely useful.

This is just experimental code. The database not included because is very large (8Mb), but can you create one for this aplication (table name=T, fields name see in code...)... This phone book is like a cmd.exe app., example you search a phone number: find *michael*-*street8* Enjoy. Sory for my english....................

Graph designing is one of the most important feature of database programss. This code allows you to design graphs at runtime! It can also read from a database that you can open and display it graphically. It allows you to chose from a list of chart types including both 2d and 3d!,it allows to save graphs to bitmap files!, copy graph to clipboard,print the graph and lot's more.

This simple demo demonstrates the speed of GetRows Method Compared to movenext method of ADO. The first and second listboxes show this while the third demonstates yet another example and use of getrows, joining arrays of data from a recordset. You can compare the speed of this method too.

A chart functionality with data of database using ADO will serves most of your hardcoded task to dynamic and impressive....

Demonstrates how to search/ find data item in ListView Control (ADO). Facilities: 1. Search by index 2. Search by others criteria 3. Sort data in the listview control by HeadColumn 4. Automatic resize control

IT IS USEFUL FOR SMALL COMPANY, & ALSO CALCULATE THE EMI, PF..

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