The Wayback Machine - https://web.archive.org/web/20071011085719/http://www.codeguru.com:80/vb/gen/vb_database/

CodeGuru
Earthweb Search
Forums Wireless Jars Gamelan Developer.com
CodeGuru Navigation
Member Sign In
User ID:
Password:
Remember Me:
Forgot Password?
Not a member?
Click here for more information and to register.

jobs.internet.com

internet.commerce
Partners & Affiliates
Online Education
Home Mortgage Loans
Free Credit Score
Promotional Pens
Domains for Business
Marketing Products
Mortgage Refinance
Home Improvement
Phone Systems
Franchise Directory
Promotional Products
Imprinted Promotions
Memory Upgrades
KVM over IP


RSS Feeds

RSSAll

RSSVC++/C++

RSS.NET/C#

RSSVB

See more EarthWeb Network feeds

Home >> Visual Basic >> General >> Database

  Navigating Your IT Career
A career in information technology usually has its share of ups and downs. Download this Internet.com eBook to learn where the jobs are in IT, how to negotiate a salary, and helpful advice on job security and how to deal with a layoff. »
 
  Inside Spyware: A Guide to Finding, Removing, and Preventing Online Pests
Your organization's computers are possibly being used to send spam, harvest e-mail addresses, make purchases on stolen credit cards or take part in denial of service attacks. Learn how to indentify, avoid, and remove malware from computers and keep your network and machines safe. »
 
  Tips for Selecting Software Vendors
IT managers need a proven, steadfast process for sifting through the hundreds of choices available for each enterprise software market segment. There are a series of steps for ensuring a result that will survive the intense, long-term scrutiny this level of investment will certainly attract. »
 
  Storage Basics: A Guide to the World of Storage Technology
Regardless of industry, size, or age, businesses are awash in more data than ever before. Federal regulations require that data be stored, protected, and retrievable for a certain amount of time. Storage is also a growing area in IT, which means employment opportunities exist now, and should exist for some time. »
 
  Building Your Own IP PBX
If you're already into having control of your computing infrastructure, taking charge of your telephone network is a natural progression. Asterisk is an open source PBX that runs on Linux. It can free your organization from expensive commercial PBXs, and gives you complete control over your telephone services »
 
Whitepaper: Putting a Price on Document-based Business Processes. Learn how you can automate document-based business processes to dramatically cut operating costs and reduce compliance exposure.

Database

ADO



ADO Connections over the Internet
Rating:
Mike Korzeniowski - 01/27/2004
This short code shows how to establish an ADO connection over the Internet. (Added: 1-Mar-2000)


ADO.NET



Implementing a Custom ConnectionString Installer for Setup
Rating: none
Paul Kimmel - 10/10/2007
See how a setup project with a custom action lets the user define the connection string using the Data Links dialog and encrypt that connection string using RSA encryption.

An Oracle Query Tool, Part 1
Rating:
dna2 - 03/09/2006
Learn about an Oracle query tool with Syntax Highlight and a tabbed MDI interface.

The TransactionScope Object Makes ADO.NET Transactions Easy
Rating: none
Paul Kimmel - 12/05/2005
Learn how the TransactionScope object enables you to auto-enlist database operations in your ADO.NET transactions.

Using ADO.NET with XML and VB.NET
Rating:
K Balaji - 12/19/2002
Learn about ADO.NET technology and how to connect to, query, and modify a database. Includes information on using XML with ADO.NET. (VB.NET)


DataGrid



Event Spy for MS Data Grid
Rating:
Mark McGinty - 07/13/2004
A utility form that will show DataGrid events with parameters as they happen in realtime.

DataGrid Advanced Techniques
Rating:
Mark McGinty - 07/13/2004
Demonstrates implementing "lookup" columns that let the user select a value from a list, boolean columns represented by checkboxes, context menus, and calculating parent-relative positions of controls inside containers.

One Just Needs to Know Where to Look
Rating:
Paul Kimmel - 03/31/2004
The Data Form Wizard is a tool in VB6 that permits you to pick a table, and it generates a data-aware form and incorporates that form into your project.

The Big ASP.NET DataGrid Article, Part 3
Rating:
Karl Moore - 03/03/2004
Implement the likes of paging and sorting into your DataGrids, but first, start off with the most gruesome of tasks: adding an editable drop-down box to your DataGrid!

The Big ASP.NET DataGrid Article, Part 2
Rating:
Karl Moore - 02/26/2004
Look at using HTML, hyperlinks, and formatting in your DataGrid, plus figure out color-coding and the many different ways of allowing the user to select rows.

Nine Steps to a Quick, Editable Web Grid
02/18/2004
Setting up your own editable Windows DataGrid may be an absolute doddle, but creating the equivalent grid for the Web is a little more complicated.


DataSets



Returning Multiple Tables into a DataSet
02/11/2004
Discover how to take advantage of one of the big new features of the DataSet over the old Recordset: Learn how to hold multiple tables of data at a single time.


Database



Listing Available DSN / Drivers Installed
Rating: none
John Pirkey - 01/27/2004
This code shows how to list the available DSN and Drivers installed on the computer. (Added: 9-Feb-2000)

A Practical Approach to Database Theory
Rating: none
Jan Haugland - 01/27/2004
Like it or not, 90% of the work a Visual Basic developer does is likely to be database related. Learn to get comfortable with databases. (Added: 18-Oct-1998)

Creating a Master / Detail Form in VB
Rating: none
Khalifa Ahmed Tarhoni - 01/27/2004
Learn to create a Master Detail style form (similar to those in Access) using standard Visual Basic. (Added: 24-Sep-2000)

Incorporating the Data Link Properties Editor into a VB.NET Application
Rating: none
Paul Kimmel - 07/28/2003
If you want to learn a bit about COM Interop or how to incorporate the Data Link Properties applet seamlessly into your Visual Basic .NET application then this is a good article for you.


Database Access



Handling Database Writes in Data Access Layer Management
Rating: none
Paul Kimmel - 01/22/2007
The write part of managing a data access layer is where things can go awry. Writing requires managing changes, validation, and transactions. Learn how to handle the challenge.

Microsoft CRM Integration: Oracle Database Access from MS CRM
Rating: none
Boris Makushkin - 03/01/2005
Here's a new way to access an Oracle database from MS CRM.

Changing Databases at the Customer's Location Using XML and VB
Rating:
Dinesh Asanka - 01/28/2004
Learn how to change databases at the customer's location by using XML and ADO.

Data Transferring from COBOL to MS Access via VB
Rating:
Dinesh Asanka - 11/19/2003
Using Visual Basic, learn how to transfer data formatted by COBOL (flat data) to Microsoft Access.

Managing SQL in Visual Studio .NET
Rating: none
Paul Kimmel - 10/16/2003
You can generate perfect SQL even if you aren't a SQL programmer, and you never have to leave Visual Studio .NET for most of your day-to-day SQL tasks.


Microsoft Access



[Updated] Fuzzy Matching Demo in Access
Rating: none
DataClean - 01/30/2007
Dare to enter the world of approximate string matching with this introduction, tutorial, and Access 2000 database demo with a 99% precision/recall.

Compact and Repair All Access Databases in a Directory and in the Directories Beneath It
Rating: none
mfyuce - 04/29/2005
Compact and repair all Access databases in a directory and in the directories beneath it using arrays, the "Dir" function, and JRO with MS Visual Basic 6.0.

Create a Microsoft Access Database Using ADOX and Visual Basic .NET
Rating:
Parvez Ahmad Hakim - 10/10/2003
See how to create a simple Microsoft Access database using ADO.NET and VB .NET.


SQL Server



Web Service Method to Back Up a Database from a Mobile Device
Rating:
aleksisa - 03/29/2007
Learn about a web service method to back up a database from a mobile device using the SQL Backup command and asynchronous method calls.

News: Don't Embed That Database!
Rating:
Bradley Jones - 11/09/2006
Did you replace MSDE with SQL Server 2005 Express Edition? Did you make the wrong move?

Extend the SQL Server 2005 Integration Services Script Task with Your Own .NET Class Library
Rating: none
Jeffrey Juday - 12/23/2005
You can customize a SQL Server 2005 Integration Services (SSIS) package using VB.NET. One of the simplest ways is to use the SSIS Script Task. Learn the details.

[Updated] What to Know About Visual Studio 2005 — The Products
Rating:
Bradley Jones - 11/11/2005
Visual Studio 2005 ("Whidbey") has released. Get a first look at answers to some up-front questions you might have. Start by simply understanding the multitude of editions that entail the Visual Studio 2005 product line. After all, how many different editions can one product have?

FREETEXT Searches with SQL Server and ADO.NET
Rating: none
Paul Kimmel - 08/10/2005
Learn how to install, configure, and use the MS Search Engine with SQL Server. Once installed, MS Search permits you to perform fuzzy searches of small and large amounts of character-based data.

ADO.NET Generates SQL for You Via the SqlCommandBuilder
Rating: none
Paul Kimmel - 11/30/2004
ADO.NET's SQL command builder reads a schema and generates SQL for you; this can be an excellent timesaver in the appropriate circumstances. When applied with sound judgment, this technique is a nice shortcut.

Calling Stored Procedures with ADO.NET
Rating:
Paul Kimmel - 11/19/2004
If you're a Visual Basic .NET programmer who has to write stored procedures for MS SQL Server, this article is for you. Learn how to isolate SQL code from VB.NET code to clearly create divisions of labor and focus for your solution.

Database Build Wizard
Rating: none
Clearcode - 09/24/2004
The database assembly build tool is a tool to allow a developer to select database schema items (tables, views, stored procedures, users, and so forth) and export the DDL to create these items to an SQL file.

Accessing The Registry From SQL Server
Rating:
dinesh123 - 07/02/2004
Learn how to find the country list from a computer's registry. You see how to read and write to the directory from SQLServer.

Generate Complex Next Numbers with SQL Server
Rating:
dinesh123 - 07/01/2004
Generating 'next numbers' numbers in SQLServer should not be a problem. But problema arise when a customer asks for different types of next numbers that you cannot generate directly from SQL Server. Learn how to tackle this problem in different scenarios.

Load Images from and Save Images to a Database
Rating:
Fatima Ahmed - 06/21/2004
Learn how to build a Windows Forms interface that allows you to work with your images database.

Checking Whether SQL Server Is Available
02/13/2004
In building ASP.NET database applications, in addition verifying a connection to the Net, you also need to ensure that your database server is up and running.


Stored Procedures



Rendering Images in ASP.NET Directly from Your Database
Rating: none
Paul Kimmel - 08/01/2007
There's no need to store file system paths in a database. Just store images in your database and then directly load them to your ASP.NET pages.

Better Entities with Nullable Types
Rating: none
Paul Kimmel - 04/25/2007
Tired of checking database entries for null values? This month, Paul illustrates how you can use Nullable types to make fields and properties accept nulls.

Programming with Stored Procedures in Visual Basic .NET (Part 2)
Rating:
Paul Kimmel - 12/30/2002
Paul continues his discussion on stored procedures and Visual Basic .NET.

Programming with Stored Procedures in Visual Basic .NET (Part 1)
Rating:
Paul Kimmel - 12/23/2002
Stored procedures are an excellent way to optimize complex business solutions for database applications. Learn how you can edit and run stored procedures in Visual Studio .NET and how to incorporate them into your Visual Basic .NET applications.


Strongly Typed Data



[Updated] XML Data Binding
Rating:
Simon Sprott - 07/17/2007
XML Data Binding allows you to manipulate an XML document via a set of simple objects. Learn about the generation of these objects, and see a summary of the existing products on the market.

Using XML Schemas to Create Strongly Typed DataSets
Rating:
Paul Kimmel - 08/26/2003
Learn the technical aspects of defining an XML schema, generating a typed DataSet, initializing, and using that typed DataSet within Visual Basic .NET.


Cache', the world's fastest object database, does away with mapping. Free download.
Fix bad addresses and phone numbers before they ruin your database. Download a free Data Quality Tools trial.
Download: Sun Java Studio Creator. Build apps visually with minimal code creation, automatic page navigation & more.
PDF Download: Software Optimization Guide for AMD Family 10h Processors.
Whitepaper: Elementool Bug Tracking--Keep Software Fixes On Course.

Access FREE NAVTEQ Location and Navigation Technical Tools:
Article:
WiMax Summary
Enter to Win:
2008 NAVTEQ Global LBS Challenge
Development Guide:
Understanding JSR 179
Webinar Replay:
Understanding the Basics of Route Calculation

Solutions