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

Perform All Database Operation Using Object.

This is an advanced autocomplete function that will autocomplete for a textbox, a listview control or a listbox all from 1 function. I have seen code on this site before that had inspired me to create this function since I need it in a lot of my projects. I tried to comment everything as well as I could. if you have any questions email me and I will do my best to help you. oh yeah - Please vote for me if you like this code. thanks

This is a basic example of how to use an access database in an application.. an address book... It has options like search, add, delete, view all.. again, just an example

Define a connection in Excel, run a SQL query from excel and return the results into an Excel spreadsheet.

Fills a Hierarchical Flexgrid based on a Hierarchical Recordset (a one-to-many relationship). Uses the Northwind database. Code is documented.

An easy example of Searching for records in a database. I posted this code last year without an example so here it is.

Allows you to select a ascii file and import it into your database. Example provided!

This code will create a database and produce a document that contains all of the table and field parameters. This is the first part of a series that will show how to use a single program to dynamically deliver any type of interactive multimedia courseware whether it's Computer Based Training(CBT), Computer Assisted Instruction(CAI), or an Adaptive Evaluation and Examination System(AEES) with all of the information being read from a database.

Sorts the records in a datagrid form when clicking on the column header. Toggles between ascending/descending sort order.

Imports ASCII text databases in any format, to Microsoft Access format. Very nice GUI. You will need to find a "Replace" function from Planet Source Code and paste it in... only if you are using VB4 or VB5.

This SW allows you to create complex SQL sentences, working with the Dictionary of the Data Base in use. This sentences can be saved to use it later. IMPORTANT: This SW was made in Spanish. As I drop the source code, change it to English is easy. Advances: -Works like the ISQL command. -You can select the number of records to be recalled, and the timeout. -The response will be separated by ASCII 9. Pass it to an Excel Worksheet to work with the results. -You can create the masks for: insert, select, update, delete of the tables. -You have a create table/index template. -The sentence can be converted to a string to pass it trough the clipboard onto your VB project. -You have an internal buffer, to work with two 'clipboards'.

Allow easy input and retrieval of images into an SQL database. Includes class file for easy implementation into your own program and a second project based on making the class into a dll for a IIS server. Will allow you to show pictures from you database on a webpage, input pictures into a database, remove the picture, retreive the picture plus more...

This code is an update of my previous submission. I put in code to convert database info to a comma delimited file, and to fill a listbox with data. I'm still working on it to do more things (SQL searches, etc.), and I'm going to do images,and things like that. I'm also going to improve the conversion to HTML to make it even better. Have fun with it!

This little application uses SQLDMO to script out objects in SQL Server 7.0 databases (tables, stored procedures, views, defaults, UDTs, full text indexes, etc.), as well as SQL Agent Jobs, Server logins, Operators, Alerts and Backup Devices. It even lets you save DTS packages as Structured storage file. Can be run in GUI mode or unattended/scheduled from the command-line. The code is a nice example of the use of SQLDMO objects, but even if the code doesn't interest you the application should be useful for SQL Server developers/DBAs who want to generate scripts of their DB objects in a more automated way then SQL Server EM lets you. ------------------------------------------------------------ A short text-file describing use is included. ------------------------------------------------------------ This is not drool-proof paper! Use at your own risk. Don't use on production servers unless your local DBA god has given you explicit permission. Dependencies are described in the included text file. ------------------------------------------------------------ A short (third-party) review of this tool and an executable-only download can be found at http://www.myitforum.com/articles/18/view.asp?id=3117 ------------------------------------------------------------ (Update 20020517 (v2.0.1): Added options to the /DB command-line switch to script out only the user or system databases) ------------------------------------------------------------ (Update 20020701 (v2.1): Server names, login names and authentication modes are now remembered between GUI sessions)

This code connects to a given SQL server and database and returns field info from a specified table. Handy if you need a quick printout of a table definition and you don't have time or patience to wait until EM has launched and connected to the server.

To show the ease of adding any Crystal Report to your VB application

This copies, renames or deletes stored procedures on an SQL server. Also the ability to copy procedures cross database, or even cross server. This thingy is way easier and faster then the import/export wizard.

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.

If you want to build an application that can work with several database engines, the main problem you will have to deal with is the different ways for specifying date expressions. This class will allow you to forget those differences. You can enter date strings in any format "dd/mm/yy", "mm/dd/yy", etc.. The class will validate the correctness of the date string and convert it into an expression you can use. Works for SQLServer, MySQL, Access, Informix and Oracle, and it's easy to add more engines.

A quick little app for querying an OLEDB / ODBC database