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

This artical simplifies the usage of ADO objects . If you like me article, please vote for me!

This example shows a way to manage persistence with classes in VB using a 3 Tier framework with XML for inter layer communication.

This Sample create's a Datareport by filtering a Database. It is quit useful for small Reports. (Sorry this is the Englisch Version!)

update from my previus posting. This my sample code how to manipulate Datareport without using DataEnvironment this sample included datashape concept and how to link image dynamicly.

Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox & HTML. This is a NEW VERSION of Any-to-Any Database converter. Please follow the link if you like to vote me / to get the original version http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=47434&lngWId=1

This is a One Form One Ini solution to the frustration of writing repetitive VB/ADO/ASP Database code. I hope you will find this extremely useful for certain tasks, and a sound concept for improved coding and tailoring to individual requirements. As I can't live without it now - so I thought I would share it. (1) Opens any Access 97/2000 Database and Lists Tables, Fields, Types. (2) Type one line of code, program will replicate the line using the correct Fieldnames/Numbers/Types and Sizes - ASP programmers dream. (3) Create a choice of connection strings based on the Open database. (4) Create Sql INSERT, UPDATE & SELECT statments with actual field names. (5) Print your output code, or Double Click Ouputbox to send to clipboard. (6) Split Screen to adjust to preferred ListBox v Outputbox areas. (7) Most settings saved, return to where you were when restarting. (8) MRU File List, Auto-Open last database, Synchronized Clipboard etc. (9) Tool Tips explain most items, can be turned off when desired. (10) Reminder bar shows current User Keys, DblClick to turn off. (11) Disconnected Recordsets, freeing off DB during development. (12) All Translation 'Keys' are user definable. At the simplest level, Open a database and type in a template like - MyArray(##) = rs("$$") In the Ouputbox, ## and $$ get translated as FieldNumber and FieldName MyArr(0) = rs("ID") MyArr(1) = rs("qCode") MyArr(2) = rs("Title") MyArr(3) = rs("Lastname") MyArr(4) = rs("firstname") ........... ........... and so on to n fields

This little utility allows the user to select an Access database and then generates the code to make a connection. It also allows the user to select a table from the database which then generates a simple SQL. Also attached are instructions for use and a test program If there is sufficient interest I will continue to develope code writing programs and submit them to PlanetSourceCode. Although a few votes would be nice I am more interested in feedback. Taken from an idea by Carlos Vara, thanks.

Hi everybody, This is for a database programming lovers especially those beginners...There will be no module so you will understand the flow of the program....Not Fully documented yet co'z I have no time for that....Maybe in my next update !....You will enjoy while using this program co'z there are lots of animations in this program....I hope you have learned from my codes co'z that was I wanted for beginners....Have fun coding ! If you like this program please vaote for me or just rate it...Thanks ! For comments email !

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! :)