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

Here is my first submission on www.pscode.com, This project prepared to help you to convert your Ms Access Database into MySQL data source format. On this project, I'm using some API function to Draw caption or Picture, so it is helpfull for newbie in VB to learn about API programming. I'm using osenxpsuite controls, to improve my GUI application. if you does not have osenxpsuite controls, you can download it from: http://download.osenxpsuite.com/osenxpsuite.zip I WAS TESTED THIS APP IN MY PC P-III 730 Mhz, and It work fine. It can convert nwind.mdb to MySQL data source for 7.07 seconds If this project usefull for you, PLEASE VOTE THIS APPLICATION IN www.pscode.com Note: - MDAC 2.5 needed - OsenXPSuite controls (http://download.osenxpsuite.com/osenxpsuite.zip) needed - MySQL oDBC 3.51 Driver needed DOES NOT SUPPORT: • cREATE INDEX • CREATE PRIMARY KEY • CREATE FOREIGN KEY • CONVERT BINARY DATA VALUES (BLOB) IF ANY IDEA HOW TO SOLVE SOME TROUBLE ABOVE, PLEASE LET ME KNOW. I REALLY NEED HELP ADVANCE VB DEVELOPER TO SOLVE MY APP THANK YOU

This sample shows how to secure Access database using ADOX and SIDs. In apps where database is created on-the-fly from code its only way to prevent your database from being modified.

Good for beginners who want to learn database. I include simple code in searching,add,edit,delete,print in the system. It has good GUI.JUST TRY!!!

This class makes VB Database Applications easy to write on the fly! This class includes over 30 functions for ADODB programming in VB! It encapsulates all the Find Functions, Move Functions, along with AddNew, Delete, Update functions and a ton of error trapping for easy use! Also includes events to program at your disposal! Please leave comments/feedback and vote if you'd like. This is my first class file I have been working on.

A vb test application which opens queries from access instead of tables for a datareport.I could not individually open selected records so i made this instead.

Analysis any kind of report from a company. Cash Flow Analysis Working Capital Analysis Ratio Analysis

The Code auto-resizes all columns of a DataGrid. The longest string of a gridcolumn is the new width of the column. Similar to this ListView- or FlexGrid- feature. I havn't found anything similar here, so I just want to put it in the codebase.

This is a nice program for Browsing through the MS Access file i.e. *.mdb. It works quiet fast comparatively. This shows you the number of tables present in the selected Database. Further it will show the fields in the selected table.Theres also a provision for seeing the whole selected table in the grid. Its quiet a good thing for using & even for the users who are not well known with the usage of Access Databases & dealing with the uncertainity tables into it.

my english is bla bla so try to understand my words first i want to thank mr.opal coz of the code he put here about the same thing printing flexgride. i want to say to mr.opal great mind = great code but vb has a great tool called DataReport what u need to deal with this tool is imagine take ur mind a way. if u don't understand my words u will understand my code.

A viewer and editor of a database with 10,000 computer acronyms.

This is a program that uses the ADODB connections to link to an Access database. All connections are created/opened at runtime. Security,passwords,usernames are in Database. Users are in two user groups. Uses SQL statements such as INsert, SElect etc. Links to website uses MDI form and Child Forms. Toolbar with Image list. Status bar that displays a random message. Data Reports using Datareport control. Class Module Example. ISnumeric validation. Search facility for searching the database. examples of using the List View Control

I created this for work to maintain a list of databases that we have for different product lines. It uses the Access 10 Object Library to perform this functionality "behind the scenes", so to speak. By doing it this way, you should notice a vast performance increase. NOTE: If you do not have Access 2002, this will not work for you unless you have msacc.olb registered on your system, but there are other options that work in much the same way.

A VERY simple guide to aid the beginner in creating a simple database.

Example shows how to connect to an Access database; browse, add, and delete records.

This is a real simple demo on how to use Inet's sockets.. This will make Inet run a lot faster when you need it to execute a lot of stuff at the same time.

I worked really hard on this for my VB2 college class.. I got a REALLY good grade and even my teacher said it was the best she has ever seen.. I am really proud of it and I hope to get more out of it by giving to everyone to help them out on ideas and what not. I spent about 100+ hours on it but it's not perfect. Had a last minute crash and had to do some crappy coding.. But, I spent most of the time on the GUI.. It uses Flash, Nicer Looking Buttons, CoolXP, Listview, MDI, etc. I hope everyone enjoys it! Please, Vote or Comment! Thanks...

If you hate Microsoft DataGrid and you dont need, cant find or dont have $300 for other grid then you are gonna love this ;). This is an activex control made in vb to replace bug-plagued DataGrid that you got with vs6. It is pretty fast, supports many things that are left behind in MS DataGrid and it is open-source (though not for proper distribution for now). Have a look at screenshots if there are some (psc might not allow me to upload them). There are some examples included on how to use the grid. It does not matter what drivers are used since this grid uses t-sql for reading/writing data. For now it does not support built-in editors, but that is to be added in next version. Just download the example and experiment a bit. If you need any help on using the control post comment here and I will be glad to help. This is first version, so please post any bugs you may find.

This sample code is an example of how to put text and graphics into a richtext box on a form and then save that information into a database. The example uses MS Access, but should work with SQL Server as well. I needed this for a specific purpose and when I could not find any examples, I created my own solution. Use this however you like there are no copyrights on the code.

Using this code You can easily backup your sql database. There were some code here that used ADO for the backup purpose, here in my code i have used the SQLDMO object for all the sql transactions. Few code are taken from here and are upgraded with comments. Hope you all would like the work

Database Operations Using Automatically Generated Class This is demo application that demonstrates powerful database functionality of database class automatically generated by CLASSter 2.0. Demo is for MS SQL Server, but CLASSter supports now MS Access, Sybase and Oracle server. Powerful features implemented by class - executing stored procedures, parameterized SQLs, multiple recordsets, batch execution, XML processing. The class code shows full implementation of these features