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

VERY VERY SIMPLE CRYSTAl REPORTS VIEWER - View Any Crystal Report with ease..lets you add reports to a list that you use all the time. Also allows for changing the parameter values. Very easy to understand code -- example report included. Hope you enjoy.

Since MS-Access doesn't support accent insensitive queries by itself (MS SQL Server does as far as I know), I had to create a function that would fix the problem. With this function, it is possible to turn any SQL query into an accent insensitive query. With a few little modifications, it works great with ASP too!

To show how to ADD / EDIT / DELETE information from an access Database. Fully Functional - Ready to be used in your programs!!!

How do you avoid the "Invalid use of null" error when reading null values from a database?If you try to retrieve a null value (empty field) from a database, you will get the error: "Invalid use of Null". Here is one way to get around this problem: ..

I used this class for well over 2 years. It is easy. It comes with a simple program that show you how to use it. I am sure that once you will know how it is working that you will adopt it.

PLEASE FIND A BUG!!!!!!!!!!!!!!!!!!!!!!! I DARE YA! I fixed the one that was found when you type somthign in the main interface when you have an empty dat file then click in the search list box. See if u can find more. By the way PLEASE VOTE!!!! thanx ;-) Well finally after heaps of emails complaining about the source safe protection HERE you go!! a non protected version, as you will see the code is a shocka, it really needs arrays. It reads everything off a text file to save HD Space. I am going to make an Access version prolly in about a month or so, well maybe longer coz i am doing my HSC. Anyway, this prog provides a simple to use, yet useful phonebook/contacts program. I have gone through and sussed out pretty much every bug I could think of, see if you can find any! I DARE YA TO FIND A BUG!!!!!!!!!!!!!!!!!!!!!!

PLEASE FIND A BUG!!!!!!!!!!!!!!!!!!!!!!! I DARE YA! I fixed the one that was found when you type somthign in the main interface when you have an empty dat file then click in the search list box. See if u can find more. By the way PLEASE VOTE!!!! thanx ;-) Well finally after heaps of emails complaining about the source safe protection HERE you go!! a non protected version, as you will see the code is a shocka, it really needs arrays. It reads everything off a text file to save HD Space. I am going to make an Access version prolly in about a month or so, well maybe longer coz i am doing my HSC. Anyway, this prog provides a simple to use, yet useful phonebook/contacts program. I have gone through and sussed out pretty much every bug I could think of, see if you can find any! I DARE YA TO FIND A BUG!!!!!!!!!!!!!!!!!!!!!!

Create an MS Access Style Combo or ADO DataCombo using a class and a single property

THIS IS AN EXAMPLE OF HOW YOU CAN DO A SIMPLE TABLE WITH DATA, SO YOU CAN NOT USE THE FREEFILE() , YOU CAN MAKE MSFLEX GRID, TEXT BOX,COMBO BOX ETC WITH THIS CODE, AND IS SO EASY, TRY IT, PLEASE DONT FORGET TO VOTE FOR ME THANKS.....

Creates a database using a Random-access file. also shows how to use Multi-Interface Documents in your applications.

This nifty little program interrogates Microsoft SQL Stored Procedures and generates VB code to interface with them. The concept was Adapted for VB from David R. K. DeLoveh's work for Active Server Pages found at : http://www.15seconds.com/issue/010718.htm the article make for a very good read so do so if you can! I converted it to run under VB and spruced it up a bit. While programs like LockWoodTech's PROCEDURE BLASTER do the same thing they cost $$$ and this is free. If you like it remember to give a vote. And again thanks goes out to David R. K. DeLoveh's for his original work. With this code in hand it would be easy to modify it to be MTS/COM+ compatiable. For more extensive developers tools like this one check out www.LockWoodTech.com.

select any access database then select the table you want then select and insert any fields to a richtextbox then preform a mail merge like MSWord. you can then browse through the database while viewing the merged data.

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

Sorry !, My contents of snippet was posted very strange as below. So, i will post my source code Once again, Sorry

Complete Library Management Software fully commented,No dirty coding. Very useful for beginners!!!!!! Please vote

I was in need of certain application that can store data in to the database and the database is stored on the Web.. And I want it without XML. I asked many people that how Audiogalaxy and Napster are doing those all the things.. they told they are using such service like XML or other.. But I don't want to use XML. So I develope application for me.. It is really very easy to use and also very easy to develope.. This is made with Visual Basic and simple codes of ASP. Must See this code.. and please vote for it.. NOTE: Now probleme is that, that I am not able to get data from the web. If any one can do it.. please let me know..

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

Stores CD-Keys, serial numbers and registration information for software. This shows database functionality with viewing, adding, deleting and updating records using DAO as a reference. Also, shows using the database to authenticate users, a simple encoding and decoding mod is included to somewhat encrypt the data in the database. This is worth the look, even if you do not plan on using the database. Sorry guys, I only include the database structure, not data. No serials/keys included. That's illegal ;> No votes requested, however I do like comments on how to improve the code. I will be adding comments when I get the chance.

This source code compares two database structures and wrote report or copy differences into second database. It uses DAO control and works with MDB database.

This VB test project demonstrates how to insert, delete, update and select from a Microsoft Access database using parameterized stored queries and ADO command objects. .mdb file in included.