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

With SQL Server, to save a value to a field with an IMAGE data type, a programmer must provide the proper means to save the data so that the data can be properly interpreted by a bound picture box or an image control. Simply binding the image field to a picture box and populating your picture box with a LoadPicture command will not save the image to the database. Here, I will share with you how I tackle this problem so that I can make use of the bound capabilities of an image or picture box. I've tried this way both in SQL Server 2000 and MS Access database, and it all works. With this program, a MS ACCESS database is used, but don't worry, with SQL Servers, you will just have to change the connection string definition in order to access the database and off you go.... Enjoy.

1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool

This update includes the HTML help file. I have made this help with "helpMATIC Pro HTML". This is a very easy to use shareware tool to make html help files. Everything else is same as of the previous version of E - Minder.

I work with Access databases, and occasionally will need to update the front end on the server. With access, you can tell when all users are out when the ldb file is missing. Therefore I created this app that checks for that ldb file. When the file is missing it uploads a specified file to the specified directory. This works excellent for me so that I can update files when all users are out. Hope this is helpful to you. Feel free to add/change or make suggestions.

This program demonstrates how you can take a table from a database (MS Access only in this demo) and convert all the records in that table into an HTML document for viewing in a web browser. With very little effort, you can add more HTML tags, more records, etc to have a really nice looking web page. I'm working on one that will use SQL statements to get certain information, instead of the whole thing. The code is well commented, and any questions can be directed to me

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

This project uses ADO connection and recordset to get the sales from an Access Database. The data is then presented in a Chart with the sales grouped by days of the week. The display is in spanish, when you read the code you will know what Lunes, martes, etc. is. Hope it will be of use to some of you.

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.

Save binary objects to a DAO database, eg: pictures, exe files, dll's etz. Its a generic class module that allows saving/extracting from any access database. Also gets additional fileds if required for example a persons name if it was stored in the same table

It can parser simple XML like file and read/write data in it. Gives simple access like any Database.

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.