Language
Visual Basic
Remove
Platform
Any
License
Any
Mike Hillyer explains how to work with BLOB columns using the ADO 2.5 stream object. One of MySQL's strengths is it's use of Binary Large Object (BLOB) columns. These columns store unprocessed binary...
Databases are an inevitable part of most of the real world applications. Deploying such database centric applications has always been tricky in all the platforms, be it Microsoft Visual Basic 6,...
This article presents a more powerful alternative for use with DataSets that can disable controls when data is missing and provide nice feedback on validation failures. The source for this new...
This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT, or the DELETE command) by using a Visual Basic .NET console application.
This document illustrates how to save relational data that is loaded into a DataSet class to a file as Extensible Markup Language (XML). This demonstrates the transition between relationally mapped...
Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual Basic .NET to programmatically create a Microsoft SQL Server database.
Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. This article dicusses how to obtain the...
This article demonstrates how to persist an ADO.NET DataSet object to XML.You can use the WriteXml method to write Extensible Markup Language (XML) schema and data from the DataSet object.
This article demonstrates how to search for data in a Windows Form DataGrid control and synchronize the grid with the search results. In this sample, you programmatically retrieve data into a...
This article demonstrates how you can manage quotation marks in string values when you concatenate SQL statements. The article provides a sample solution that uses the Sql managed provider (Microsoft...
This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object. If your client application uses an ADO.NET DataSet object to store changes that are...
It seems with every new release of Visual Studio we get a new data access method. DAO, RDO, ADO...and now ADO.NET. Well, this version of Visual Studio not only introduces ADO.NET, but also the SQL...
Microsoft introduced ADO.NET together with the .NET Framework. This new data access object is built upon the .NET Framework. When you install the .NET Framework on your machine, two .NET providers...
ADO+ is the new set of data access services for the .NET Framework. ADO+ is a natural evolution of ADO, built around n-tier development and architected with XML at its core. This article presents the...
Recently there was a discussion related to DataSet’s HasChanges
and GetChanges methods. This article discusses the basics of
DiffGrams and how DiffGram format is utilized by a DataSet to
in...
A well-designed application that uses a relational database management system in the backend should make extensive use of stored procedures. A stored procedure is a named collection of SQL...
This article is an unedited part of Chapter 11: Working with
ODBC .NET Data Provider from A Programmer's Guide to ADO.NET in
C# book. This chapter teaches you how to work with various data...
Working with data-bound controls using .NET ADO.NET and
WinForms is so fun. You write few lines of code and these
controls take care of rest for you. In this article, I’m going
to show you how...
I just read Mahesh's article Writing a Generic Data Access
Component. Another way to solve this problem is to utilize the
System.Activator class and a factory pattern to create the
concrete...
