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

Please download part I at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=44040&lngWId=1. I'm sorry but i can't load the zip file in one. It is a great visual tutorial to learn about Databases in Visual Basic. This is not a simple tutorial, it have steps by step and with every step have a photoscreen to guide you With it you can learn: - How to link an Access database to VB - How to view the database in labels - How to create, delete and edit the differents register - How to make a filter (search engine) of strings, number and Dates - How to resolve common problems with DB - How to show the database in a sheet like Excel (Datagrid control) - How you can manipulate the DB with the Ado Control invisible - How to specify a format for a type of data like "$ 23.80" or "23/sep/2003" - and much more... Also have a very good example divided in VB in three parts: 1- View, add and edit DB 2- Find in DB 3- Non visible Ado Control with Datagrid control I recomend it for beginner or newbies in DB and also for that who want to make better

This project shows how we can print a very simple report to text file using RichTextBox control and to printer. The report contains simple information with quantity and sum of item per page, the sum of money per page, and total of sum of money in the end of report. User can select category to display the report. User also can change the number of record would be displayed in the screen/printer, and can change which printer will be used in combobox. The selected printer is the default installed printer in your computer. Including functions to adjust text-alignment in the report. This is very useful for you who want to print a simple report with many record to your screen and to your printer, without using the third party activex control. Any comments, feedback, and votes would be truly appriciated.

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