The Wayback Machine - https://web.archive.org/web/20071112114044/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
Build a Server Rack
Affiliate Programs
Prepaid Phone Card
Online Meetings
Business Lists
Promotional Pens
Promos and Premiums
Complex Webhosting
Memory Upgrades
PDA Phones & Cases
Computer Deals
Corporate Awards
Cell Phone Plans
Web Design


RSS Feeds

RSSAll

RSSVC++/C++

RSS.NET/C#

RSSVB

See more EarthWeb Network feeds

Home >> Visual Basic >> General >> Database

eBook:
Migrating to Oracle Database 11g

WHITEPAPER:
Oracle Database 11g Solutions for Security and Compliance

WHITEPAPER:
Innovate Faster with Oracle Database 11g

WHITEPAPER:
Oracle Database 11g for Data Warehousing and Business Intelligence

WHITEPAPER:
Oracle Real Application Testing and Manageability


Usability and Design
The Usability and design space brings together the latest information, research, tools, podcasts, and conference information related to usability and design. Content is pulled from IBM and non-IBM sites. »
 
Ajax Resource Center
This space is your one-stop shop for information on the Ajax programming model, including articles and tutorials, discussion forums, blogs, wikis, events, and news. If it's happening, it's covered here. »
 
Linux Security
The Linux security space gives an overview of security issues related to Linux and covers all aspects of securing a Linux distribution. It also links to Linux security-related news and articles. »
 
Ruby Programming
Take a closer look at Ruby, a dynamic programming language that is growing rapidly in popularity. Explore its intriguing features and learn what programmers are doing with it. »
 
Wiki: WebSphere, SOA, J2EE in Practice
This wiki discusses how to use J2EE and related technologies to develop business applications, including how to make best use of IBM J2EE products like WebSphere Application Server and Rational Application Developer, and IBM SOA products like WebSphere Process Server and WebSphere Integration Developer. While it occasionally delves into tangential topics and future trends, the primary focus is on how to make use of the products and technologies that we have today. »

Whitepaper: The Network Is your Business. From e-commerce and email to VoIP, video, and collaboration, a strong, healthy, and well-managed network is vital to achieving business success.

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.
The Microsoft Platform - Driving Your Business Forward with ALM. Click here to read this whitepaper.
Intel Go Parallel Portal: Translating Multicore Power into Application Performance
Whitepaper: Elementool Bug Tracking--Keep Software Fixes On Course.
Generate Complete .NET Web Apps in Minutes . Download Iron Speed Designer today.



JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info