Results for "Category: Databases/ Data Access/ DAO/ ADO"
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. :)
Analysis any kind of report from a company. Cash Flow Analysis Working Capital Analysis Ratio Analysis
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.
Some SQL Server actions: - create database - delete database - execute SQL command - execute SQL script
Here are two functions that will allow you to read and write a Large Binary Object (BLOB) to and from a database. This could be used to store and retrieve images, documents, etc inside the database it self. This is great for those of use that have a lot of Binary files around that we want to keep in a central place that can be backed up and protected with the same security that a database offers. This code will work with *ANY* database that ADO can connect to.
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! :)
VBRSGen is a handy VB 6.0 Add-In that creates formatted ADO/DAO recordset and SQL code from Access database tables and queries. Generates variables, sets objects, etc. Also includes a simple "Where" clause creator tool and a results preview grid. Code is ready to paste from the Clipboard or Notepad. Some SQL statements aren't parsed properly, but these can be easily edited; this still saves a lot of time in repetitive ADO/DAO database coding. I'm making this available elsewhere as shareware for $20, but because the PSC community has provided so much invaluable support and helpful code, feel free to download the open source code here for your own personal use at no charge! This was originally posted in early April 2002 and received amazing feedback and dozens of "5-Globe" votes, until the PSC database had some problems. So please vote and leave feedback to let me know what you think!
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
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
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
CompactAllMDBs is a Microsoft Access 2000/2002 (XP) application that will (1) Search for all specified files (default is .MDB and .MDA files) in a specified directory (and optionally, in all subdirectories below it) (2) Display all such files found in a listbox with their sizes (3) Compact all the files it found or only the ones selected from the list by the user (4) Search for the same files it found the first time and compare their size as compacted with their original size, to see how much disk space has been reclaimed It's handy to keep your ever-inflating MDB files of a manageable size, and it works nicely on networks. This can't really eb smoothly ported to MS Access 97 because it uses ENUMs in the code, which isn't supported by VBA in Office 97, to my understanding. Also included: (1) A simple routine for calculating and displaying elapsed time for the process down to milliseconds. (2) A "Browse For Folder" routine, based on a Windows API call (I originally wanted to make this start with a specified default folder, but I haven't had a chance to figure out how to do that yet) (3) Uses the Access (2000/2002) routine to Compact and ReCompile the application when it's closed down. In your VBA code, this application requires a Reference to MS DAO 3.6 library If you have any comments or questions, drop a note to brianb@battleszone.com
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!
This is an updated version of a previous project, to demonstrate the use of a MSChart control with ADO to show scientific data. Some other tricks are shown... A newer version will be coming out very soon to teach DML with ADO.
This application was written with the intent to serve as an example of how to use the MSChart control that is shipped with Visual Basic. I've found out, the hard way, that the documentation for Microsoft's chart control is poorly written, if not totally useless! This example might be silly but I garantee that it will help you understand how to manipulate and create graphs, specially for those who work with scientific data (like me).
A complete Database application. Based on ADO Database.It has some new mathematical features. I used here FLEX GRID. Moreover coold design. For more code Please Contact with GENERAL CORPORATION BANGLADESH didar911@yahoo.com tahmina911@yahoo.com