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

This will show new people to VB or Vb and Database's the basic's of using ADO with VB and access databases. *PLEASE VOTE*

Ado Database which stores Usernames, Passwords, Notes. Passwords are kept encrypted. For the Encryption i used the DS2 Class I found on this site.(Author: David Greenwood)So far the best Encryption - Example I could find here. Uses the Microsoft-Style of Ado Database. Features Add, Update, Delete, Cancel, Edit and a Listbox. See Screenshot! Update available, More security: http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=41006&lngWId=1

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.

A simple, and easy to understand code, whick lists the tables etc. in a microsoft access database. The code uses ADO, so it is handy for beginners to follow while learning. Sorry forgot to comment it.

This Is a great module, which loads data from a recordset into a listview without all the usual hastle. If you like it please rate it and vote for me. Thanks

This example will show you how to move items from datalist (which is connected to ADO control) to a listbox.

This code is used to store, track, research and share recipes. I got the application about 8 months ago from PSC from a posting by Bob Davis from Tallahassee Florida. I loved the concept and some of the recipes were cool too. I really liked what Bob did but since I'm a database programmer I had some challenges that I was interested in tackling with regards to his initial design (plus I was board) so this is the result with a few added plus's that my wife dreamt up. There is one thing that is bothering me about this application though and maybe you fellow coders can help me out. For some reason I cannot distribute this to any family members or friends without installing VB6 on their computers. They are using 95B and 98? I have traced it down to the Data Access pieces for the errors (particularly the compact and repair commands). I have installed the MDAC on their PC's and it does not work until I install my copy of VB (Pssst, Please Don't Tell Bill). If you have any advice or critisisem, go ahead and let me know because there is always a better way, a different perspective or something that everyone did not think of. Pardon some of the not so neat code. ;-) Best Regards, Tom Williams

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

This is a Contact Data Base with to organize our personal contacts or company contacts. This code have other features like Login User and Password, add contacts, delete contacts, edit contacts, search contacts, Print contacts, send email to our contacts without a external email program, a calendar and a digital clock.

My third submission to Planet Source Code demonstrates how to use ADO and the Datagrid Control together. One neat feature of this app is the use of a horizontal scroll bar to move through records. I haven't thoroughly tested this app so don't be surprised if you find a couple bugs. If you're new to ADO or even a novice I'm sure you'll find something useful in this app. Please vote and give me some feedback!

This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access database. Updated with some error handling and other stuff :)

ADO Recordset Paging in VISUAL BASIC !!! There are many code samples that making recordset paging available in ASP ( Web based ). This example of ADO Paging through a recordset is written in Visual Basic !!!

ADO Helper 2.0 now includes example projects to demonstrate the working of ADO. This will help to directly use the codes in application. Example projects include: Demonstrates how to use Cross Tab, How to handle ADO Errors, ADO Find and Seek Methods, How to use ADO with Grid Controls, Use ADO with Data Report to create Simple Data Report, A complete ADO Unbound example to show, add, edit, save, delete with navigation with error handling, How to practically handle ADO transactions. These example programs will definitely help beginners and pros alike. With the passage of time, ADO Helper will become the complete source of ADO Help and Example programs at one place. Coming soon are topics such as: Data Consumers, Data Shaping, ADO MD to summarize data, Creating Data Sources, A complete payment management system using ADO and crystal report.

Demo for database access class automatically generated by CLASSter. Full source demonstrates calling stored procedures, executing parameterized SQLs, multiple recordsets, batch execution, transaction control, XML processing, error handling, etc.

How to create Access database directly from VB code? This program will create BAS module with all the database structure informations and you can include that module in your app. and create as many databases as you want. Sample code and infos included. Don't have to vote, just use it and send an e.mail for any error you find, any feature that you like me to include (like compact, replication, etc)

This is a Bible concordance that you can use to store bible related topics and scriptures. So like you could create a topic entiled "Abortion", with scriptures against it, and come back at a later time and view it. It uses an elaborate database of text files to store all info. Next version im going use MS Database. If you add anything cool to it, please let me know. Thanks.

Ok, Trying this again. I think I have all the bugs worked out. This is a sample of a larger database GUI that A friend and I created thru VB for the company that we work for. If you want the full setup.exe and the cab files (you know if you don't have a full package & deployment options) then email me and I'll send it to you in zip format. (Note: this is a huge file) This is a free version so please all comments welcome as to what more to include, and etc. Please do not distribute this software on any other server other than the original upload to planet-source-code. If you think someone else is interrested or would like this program, please give them the link to this. Thank you so much. We also tried to include as much helpful information with the program as well so, if you are operating it and you have any questions please contact me. So, enjoy.

Im sick and tired of using a third party report generator such as Crystal Reports, etc. so what i did was i mastered Data Report of Visual Basic 6 and here is sample of how to print an image to Data Report using ADO Connections. I hope you like this sample of mine.

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

if u have SQL running on NT this code help you in connecting with SQL server by passing some parameters Like Provider,User,Password etc.After established a successfull connection u can choose tables from the combobox and automatically all records will be shown in datagrid from selected table.