Results for "Category: Databases/ Data Access/ DAO/ ADO"
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.
Personal email address book that opens directly the default email software, copies and pastes the address selected so as to be ready to write and send an email message. Useful when you use different PCs with different email software.
This will read the table form an access database and then creat the textboxs on a form with the field names mapped to the textbox names. It will then create the code to save what is in the text boxs back to the data base
Need Part 11 compliance then you will need multi-level password security with passwords that expire. This sample application will show you how to this to your applications. All you need to do is copy 2 forms, a class module and a module to your application (see below) and you are ready to go. It was written to use an Access database (DAO); I have also written an ADO version, which I will post later. You set up the access rights, add users, and assign these rights to the users. New users, by default, are assigned the password of password, which they must change the first time they try to log-in. A user can change their password anytime they choose as long as they know what their assigned password is. The security file (security.pwd) can be renamed to anything you like and is password protected. You can assign a unique application ID to insure that the security file can only be used with that application. If you are connected to a network, the application will display your network log-in ID automatically in the Log-in ID text box. The passwords can be set to expire after a user-defined number of days.
This shows you how to make an address book with databases.
This is an example on how to use ADO without ADO controls. I use the typical phonebook example... It is a complete application I use myself. You can store your friends, bussines associates name, adress, company, telephone, email, webpage, info, photo and more.... If there are several people using the same computer they could all have their own adress registers... you can create as many as you want and call them what ever you want. You can backup your database to any location you want. You can restore your backup. You can choose if you want to be in read only mode or in editable mode. When you are in editable mode you can Add a new post, edit a post or delete a post. You can send a email to current person or open his/her webpage. You can search for post using several search criterias such as: LastName, FirstName, Company, Adress, Telephone, Cellular, City, Country. The project is made with VB 6.0, Service Pack 5 and MDAC 2.5. If you dont have MDAC 2.5 you can get it at Microsoft webpage. Comments and constructive Feedbacks are always welcomed.