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

This is an app to organize and keep track of the different recruiters that I have been dealing with looking for a new job. It stores all of your contacts in an access database, allows you to search on all fields, sort on Company Name or Contact. Allows you to send email or go to the recruiters website. This is my first submission to PSC. I would appreciate as much feedback as possible (Good or Bad),and some votes if you like my code.

Converts your code ISBN to Code Bar. Convierte tu codigo ISBN a Codigo de Barras.

CreateMDB will analyze and dump the sturture of an Access database into a BAS-module, you can include in your own project. From your own project you can now create an access database on the fly. This project is using ADO/ADOX v2.5 but will also work on v2.1. Updates in v1.0.13 : Minor bug regarding Nullable columns fixed. Updates in v1.0.12 : Minor bug regarding table description fixed, and found a solution regarding Nullable/Allow Zero lengh. Updates in v1.0.11 : More tableproperties added and a MRU list added to menu. Updates in v1.0.10 : Password dialog added, and some minor code updates. Updates in v1.0.9 : Support for Queries aka Views and Procedures and improved Errorhandling.

This application discovers all about ADO Connection builder to help you Creating ADO Connection String to any databases or maybe use the codes to your project in simple way as 123.... Don't forget to vote me.....

PlanetSource code is a life for VB programmers. I have learned many thing from this website so I felt I will give this code to all the programmers who are willing to learn the database concepts. I tried for this kind of code but all in vain. Dont worry. This is the best and the ultimate code for all the Database programmers who have been waiting for ages. The whole world is looking for a control of this sort. I as a enterprise solution provider found it very difficult to debug the recordset and find the exact match in the recordset by pressing F8 .. F8 .. F8. Dont you think doing this way wastes your time and money... The main purpose of this code is to print the contents of the recordset of ADO,DAO,RDO. Within a fly we can see the contents of the recordset. This will save a lot of time. The main purpose of this code is to pin point the exact location of the data that we need. We use filters to check the data and reduce the recordset to find the exact match. But this control by clicking on the tab sort the contents of the recordset and display to us. You can change the order of the recordset fields by dragging.

Good database program to learn from. I suggest getting it. It was one of my first database programs, and this makes it easy and stuff. Has add, delete, edit and search feature. Also uses SysGarbage.ocx for system tray access. It is cool. Please rate.

This is an update to the fantastic work of Jeremy van Dijk on SQLScripter 2.0. I have added just a few minor enhancements by borrowing more great code from Royce D. Powers (SPGenerator). The main feature that I've added is the ability to generate INSERT scripts for a selected set of tables - definitely NOT difficult, but handy. I have also made the command line options more complete and added a few extra.

This program, show many statistic about your Data Base And it convert your data base to HTML and SQL format. Please, Vote for my source code...

The purpose of this class is make easy to generate ConnectionStrings to open ADO databases. Just setting some parameters you can easy open Access MDB with or without password, SQL server using username and password or Windows NT login, DBase III files, Excel Worksheets, Oracle and ODBC. Plus, with a minimum of modification you can easily add support to any other database. Of course that you always can hardcode your connections strings but this class will make this for you on a very friendly way. I'm updated with minor changed and translation of comments to english. Since it's my first submission to planet source code will be glad if I have some feedback positive or negative. I hope that this class can be so useful for you as it is for me. :)

This application can Extract the existing DAta structure of any SQL Server database and it can be saved in HTML table format.Tables structure of selective tables can be Printed.Table can be taken copy

This Application is used for quick access to an Oracle Database. The DataFetcher gives you power to Add, Remove, Search, View, Records at a click. DataFetcher also has it's own built in SQL*Net emulator in it! If you access an Oracle database frequently, then this is a must have Application. You must have Oracle Client installed on your machine to take advantage of the ORacle Object used in this code. Please Email for any questions or feedback. Thanks.

Address DataBase Shows VB and ADO

Backup and Compact a MS Access database file (*.mdb). Output a *.csv (Comma Delimited)File.

This shows how to two things, first how to pass variables to a stored procedure on a SQL server, second it shows how to handle multiple recordsets being returned from the stored procedure. This allows for a greater speed then trying to pass the entire SQL query to the server especially when you have several. Please Vote if you like it! :)

Allows users to select any DSN-less ODBC data source, or an MS Access database, to display the tables in it, and select a table, which is automatically loaded into an Excel spreadsheet, complete with column headings (field names). Based on project submitted by Ian Mitchell: http://www.planetsourcecode.com/xq/ASP/txtCodeId.25934/lngWId.1/qx/vb/scripts/ShowCode.htm I just changed it to use ADO instead of DAO, and DSN-Less ODBC data sources, instead of just MS Access. Slight modifications (error handling etc) on august 9, 2001

Finds SQL Servers on your LAN

Allows users to select any DSN-less ODBC data source, or an MS Access database, to display the tables in it, and select a table, which is automatically loaded into an Excel spreadsheet, complete with column headings (field names). Based on project submitted by Ian Mitchell: http://www.planetsourcecode.com/xq/ASP/txtCodeId.25934/lngWId.1/qx/vb/scripts/ShowCode.htm I just changed it to use ADO instead of DAO, and DSN-Less ODBC data sources, instead of just MS Access. Slight modifications (error handling etc) on august 9, 2001

If you're ever wondering what's contained in a recordset you currently have open, here's a quick and dirty way to dump all the data you could want to the Immediate window, which you can view there, or copy and paste into a notepad document or other textfile for printing, etc. I like to keep this somewhere I can quickly copy and paste it into any module or routine that uses a recordset in case I lose track of which field is which. (I've only tried this with VB 6.0 and AO 2.6, but I imagine it would work with other versions.) --Brian Battles WS1O Middletown, CT USA

Undocumented Trick for calling stored procedures in vb using ADO

This application will take any table from any database, and converts it into a HTML page, with nice looking tables. I have included a database with the entire 2000-2001 hockey season schedule as an example. The user can then view the schedule for any given date and convert it into a HTML page. Good idea if you're a hockey fan and want to update your page with the games scheduled for the day. Please remember to vote for me!