Members

Technology Zones

Articles

Hosted By

Info

• Index
• / Programming Languages
• / Visual Basic
• / Database Development

Articles & Tutorials

• Identifying Your New Records

  by LACanadian

  While the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. This article reveals two techniques for retrieving the value of an AutoNumber/Identity field..

• DAO 3.6 Library

  by LouisRose

  Learn how to use MS Access 2000 with VB and the DAO library. Includes a module for handling simple databases..

• Beginning Active Server Pages

  by James Crowley

  Expand your VB skills to the web - learn how to create Active Server Pages in this extensive tutorial.

• SQL Distributed Management Objects Part 2

  by S.S. Ahmed

  Learn how to administer SQL Server remotely..

• SQL Distributed Management Objects

  by S.S. Ahmed

  You will learn how to administer SQL Server remotely. I have selected VB to develop a component that will be used in ASP scripts to harness the power of SQL-DMO..

• More Database Development Articles & Tutorials...

Sample Code

• DSNLess ADO Connection

  by Einsclaws

  It is always troublesome to add a DSN entry whenever the program has to be run on another computer. This source code tells how to prevent this problem..

• Treeview and ADO

  by alucard5

  This code will save the treeview node when click add region/branch in Access format. When run the program the treeview will load the Access file..

• Compact & repair MS Access database

  by mrjdesign

  Simple snippet of code to compact and repair any MS Access database..

• ADO Utility Class

  by NeverMalchik

  ADO class containing useful functions - counting records, creating database from scratch, openning/closing database, filling listbox/combo box with an sql statements, manipulating records....and much more..

• Basic ADODC Example

  by mooeypoo

  Too all you newbies out there, This is something I wrote for a friend of mine, teaching how to use the basic extraction-from-db utilities. It shows how you can link an Access database using the ADODC Component. It includes thorough explanations and examples. It really is teaching the basics of ADODC components - nothing fancy - I just remembered my own time as a beginner, trying to search for new ways to learn. I hope it will help you :) ~moo.

• More Database Development Sample Code...

Sample Chapters

• Stored Procedures

  From Beginning Visual Basic SQL Server 7.0

  An introduction to Stored Procedures, from the book Beginning Visual Basic SQL Server 7..

Books

• Database Access with Visual Basic 6

  Published by Sams Publishing

  Database Access with Visual Basic's major emphasis is on solutions, not technology. Rather than rattling off a list of features, diagrams and acronyms, this book provides step-by-step examples of the most important techniques developers typically go through to create database applications..

• Beginning Access 97 VBA Programming

  Published by Wrox Press

  Learn how to take advantage of VBA in Access 97. Lots of clear samples and realistic examples teach users how to optimize their database to improve performance. "Beginning Access 97 VBA Programming....

• Beginning Visual Basic 6 Database Programming

  Published by Wrox Press

  This book covers all of the new and improved data-access features of Visual Basic 6 (VB6) and illustrates how to put the various components and techniques to work in real-world applications. The first chapter spells out the concepts of databases in general and then introduces the reader to the Data Control and the VB Data Form Wizard--a quick way to snap together a database interface. From there, author John Connell spends a few chapters illustrating how to code the data control and build a "bul.

• Murach's Visual Basic 6

  Published by Unknown

  Murach's Visual Basic 6 covers everything from beginning VB 6, to extensive coverage of databases, ActiveX components, and other core programming skills .

• Beginning Visual Basic SQL Server 7.0

  Published by Wrox Press

  Most Visual Basic applications involve database programming of some kind, and SQL Server 7.0 is gthe database of choice for many Visual Basic programmers. This book introduces SQL Server 7.0, cover....

• More Database Development Books...

Products

• Store Images in a Database

  Inserting image into database as well as retrieving image from database using this DLL.

• Generate VB Source Code from Access Database

  Automatically generates VB code for your database applications

• XControls

  LGB-XControls for Visual Basic 6.0 are the powerful model-driven data-aware components that enables application developers to quickly develop scalable and robust database applications.

Web Sites

• Code Generation Network

  The Code Generation Network covers all aspects of code generation and model-based development. The site's resources include a database of code generation tools, interviews with leading exponents of code generation and book reviews on code generation and software development in general.

• Unicode and ADO

  Learn how to return Unicode through and ASP Web page to an IE5 brower.

• ADO and Datagrid Step by Step

  Learn how to setup ADO step by step and embed a datagrid in a form

• Visual Basic Users

  The VB and VBA users resource center. Contains Excel Workbook rebuilder, NetSend 3, Excel Sub Classer and API/VB/VBA code. Plus online discussion groups, code postings etc (all free).

• REMADO

  REMADO is an ActiveX component that has been developed as a means of retriving data from a remote data source using standard SQL queries. Although Microsoft provides RDS or SQL Server, most Internet S

Search

Code Samples

New Members