| Accessing Data Using System.OleDb |
| C# Help |
| This simple application demonstates several aspects of object-oriented
programming in C#. It builds a simple class called "Batters" with several
fields and then populates their values by retrieving data from an Access
Database. In my research on how to retrieve data using System.OleDb I found
that there wasn't any one help file that demonstated how to put it all
together. I hope this helps. |
|
| An ADO.NET multi-tier solution |
| The Code Project |
| A view of how ado.net can be used in a multi-tier environment. |
|
| Building a Custom Data Provider for Use with the .NET Data Access Framework |
| MSDN |
| The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers. |
|
| FIX: The .NET Framework Managed Provider for OLE DB may not return an Oracle error message if the locale setting is not "en-us" |
| http://www.kbalertz.com/ |
| (326722) - Explains that the .NET Framework Managed Provider for OLE DB may not return an Oracle error message if the locale setting is not "en-us". Requires that you install a hotfix to resolve the problem. |
|
| How do I add a DropDownList to EditItemTemplate, Using an Access Database (And Then Some)? |
| DotNetJunkies |
| In a recent artlicle we discussed how to populate a DropDownList box from within a DataGrid's Column while the DataGrid was in "edit mode". Well, this article builds off that example, and adds some new elements and features. First, instead of using the SQL we are going to use Access - specifically, the Northwind database. Second, when filling the DropDownList we aren't going to make a seperate call to the database to get the data - instead we are going to use a DataView and filter out the specific rows we n |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| Microsoft Support |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| HOW TO: Obtain Underlying Provider Errors by Using ADO.NET in Visual Basic .NET |
| Microsoft Support |
| (308043) - 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 underlying provider errors when using ADO.NET in... |
|
| HOW TO: Obtain Underlying Provider Errors Using ADO.NET in Visual Basic .NET (Q308043) |
| Microsoft Support |
| 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 underlying provider errors when using ADO.NET in Visual Basic .NET |
|
| HOW TO: Obtain Underlying Provider Errors Using ADO.NET in Visual C# .NET (Q308650) |
| Microsoft Support |
| Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. This article shows how to gather this information.
|
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual C++ .NET |
| http://www.kbalertz.com/ |
| (317017) - Use this step-by-step guide to read and write data to and from BLOB (LongVarBinary) columns in a database table. NOTES This article contains examples for both the SqlClient and the OleDb DataAdapter classes. The only differences, apart from the class... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317043) - This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, you may have to retrieve a large... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual C++ .NET |
| http://www.kbalertz.com/ |
| (317044) - This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, sometimes you may need to retrieve... |
|
| PRB: "Cannot Start More Transactions on This Session" Error Message When You Use OLE DB Provider for SQL Server in ADO.NET |
| Microsoft Support |
| (316872) - When you use Microsoft OLE DB Provider for SQL Server (OLEDBSQL) in ADO.NET, if you try to start more than one transaction in a session, you receive the following error message: System.Data.OleDb.OleDbException: Cannot start more transactions on this... |
|
| PRB: "Could Not Find Installable ISAM" (0x80004005) Error Message When You Try to Set Session-Level Jet Properties (Q318161) |
| http://www.kbalertz.com/ |
| When you try to set custom, provider-specific properties for the Microsoft OLE DB Provider for Jet in the ADO OLE DB connection string, you receive the following error message: Could not find installable ISAM Error Code: 0x80004005 (or |
|
| PRB: Error Occurs When You Use ADO.NET OLEDbDataAdapter to Modify Excel Workbook |
| Microsoft Support |
| (316756) - When you try to add, to update, or to delete records in an Excel workbook that uses the OLEDbDataAdapter with ADO.NET, you receive one of the following error messages: When you add a record: Syntax error in INSERT INTO statement. When you update a... |
|
