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

This a example for call one or more store procedures with different input parameters or without parameters.

This simple database will save all your books collection, it shows the use of ADO, DataReport and DataEnvironment, it shows how to Add, Save, Edit, Delete, View Reports. Other cool stuff it contains a toolbar and a file menu. It also shows the enable and disable functions.

Use this class to create select, insert, update, delete sql queries. It automatically manages datatype and build data according. I generated this code in order to reduce my time in creation of queries.

This is a good example to database connectivity....it's an example to match signatures ... in some institutions signatures of a person is scanned and verified by looking into the scanned image and the signature of that person...good example

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 source code was originally to predict lightning strikes. This source code is run in MATLAB and can be modified for different no of inputs. Meaning, this source code can be used for any kind of prediction!

PROBLEM: Creating a copy of a Recordset could mean using the Recordset.Clone method sometimes. However, this is not always appropriate because ADO’s Recordset.Clone method creates a Recordset which points to the same data as the original Recordset. This means that you really do not get a physically distinct copy of the original Recorsdet. Consequently, changes to the clone copy could modify the data in the original Recordset. An alternative solution would be to use a loop to append each record to a new recordset. This, however could end up being an unwieldy solution with potential performance penalties. SOLUTION: ADO 2.5 comes with a Stream object that can be used to create physically distinct copies of Recordsets. The article below demonstrates the use of the ADO 2.5 Stream object in copying Recordsets and the difference between the Recordsets created by the Recordset.Clone method and ADO 2.5 Stream object. Please see attached file.

Perform All Database Operation Using Object.

Sale, Purchase and Stock Management for Airline Tickets. This project is in prgress.

Using this Program one can browse for Access Database through Network or local computer, pick a table you want to make an XML file from, and finally push a button to create a file in XML format. One can also display the newly created XML file and print it into Textbox with further "copy-and-paste". For database browsing I used an API call: GetOpenFileName Lib "comdlg32.dll" instead of bulky CommonDialog Control. For getting a tablenames of the database I used OpenSchema(adSchemaTables)for create Connection and then simply added tablenames into Combobox. Then I used File access VB feature to write an XML file from access table, reading column names and columns, converting it into XML format and writing on disk. The last feature this program has to print out a newly created XML file into Textbox for analysis and, if necessary, "copy-and-paste".

Demonstrates how to add, edit, delete records in a database. Uses ADO for connection. Treeview is included to view the records alphabetically. User has the option if he wants Automatic treeview refresh or manual (see option buttons in snapshot above). NOTE: This is for real beginners.

I think Flexgrid is Important in any Database Project. I made Readable / Writable Flexgrid for convinience to Add / Edit Data.

2 functions to convert a 38 character GUID eg. {2E1EFAD8-4AD9-48A6-B9A9-75505F2B9A51} to a compact/compressed 16 character VB String eg. @#$%

Total remake of earlier submission. I'm using database to to store author,project picture and comments. The actual zip file is stored in a separate folder for easy excess. Project photos can also be saved to a separate folder if option is selected.

Enables any user that can login to a database to monitor sybase activities. You can monitor your SQL transactions, functionalityy accdate, audflags,dbname,fullname,language,name,password,pwdate,resultlimit,spacelimit,srvname,status,suid,timelimit,totcpu,totio,affinity,blocked,cmd,cpu,dbid and much much more

This is a database application. It stores information for keeping track of company inventory. The database is empty, so you will have to populate it yourself

I wrote this code when i was developing a software for an Estate Agent. The code copies the database path in the System Registry and everytime picks it from the registry. If connection fails another dialog box opens where you can specify where the Database is saved. Secondly, you can take out the report of all the data in the table using MS Word. A small routine to accomplish the task. This is basically a three in one program. Save DB Path in the registry, Create Report using MS Word and Specify the database path. Just copy extract the .zip in C:\post directory. Please rate it.

Ok, Trying this again. I think I have all the bugs worked out. This is a sample of a larger database GUI that A friend and I created thru VB for the company that we work for. If you want the full setup.exe and the cab files (you know if you don't have a full package & deployment options) then email me and I'll send it to you in zip format. (Note: this is a huge file) This is a free version so please all comments welcome as to what more to include, and etc. Please do not distribute this software on any other server other than the original upload to planet-source-code. If you think someone else is interrested or would like this program, please give them the link to this. Thank you so much. We also tried to include as much helpful information with the program as well so, if you are operating it and you have any questions please contact me. So, enjoy.

This is just a small login app you can use in your programs. It uses an access database. You can add users. Starting username: username password: password. Please give feedback. I know there are bugs.

a simply sort on de collumsheaders of a datagrid