ExamGuru IT/.Net Guru : System.Data.OleDb.OleDbDataReader Class [Articles]

Accessing Oracle Database

This project presents an Access Database Editor written in C#. The solution consists of two projects One of which the GenericOLEDB dll provides the access to the database through using the Ole Db classes available in C#. As the title suggests the dll code is completely generic and all the main database code that is specific to Access is contained in the project files that call the code. The main project and the consumer of the GenericOLEDB project contains two files the main file takes care of the specific creation and opening of the database as well as the database operations where there is no further information required, and the second file presents and editor that allows the editing of a row of data for insertions or deletions.

C# Corner

This source code shows you how to connect to an oracle database and do operations such as select, insert, update and delete.

Authenticate Web Service

C# Corner

In this example we will build a web service that authenticates userid and password from an a very simple MS Access database. This web service exposes only one method to the client. This method takes input username and password, checks the values in the table, and if found returns the remaining fields from the table.

Basic Content Management System with ASP.NET and MS Access

BETA-PRB: DataReader Has No RecordCount Property in Visual Basic .NET (Q308050)

A very basic web-based content management system using ASP.NET and MS Access

Microsoft Support

When using the OleDbDataReader or SqlDataReader class, there is no RecordCount property to tell how many records are being fetched.

BETA-PRB: No Method in DataReader Closes Its Underlying Connection (Q310369)

Microsoft Support

The DataReader object does not include a property to retrieve its underlying connection. Although you can close DataReader and then close the OleDbConnection or SqlConnection object on which DataReader was opened, DataReader does not have a built-in connection. Thus, if you retrieve a DataReader from a component method, you cannot close the underlying connection. That is, if you retrieve a DataReader object from a component, the DataReader stays connected, and there is no way to disconnect it.

BookStock v2- Samples to Show Simple OleDb.NET Connectivity

Master C#

The bookstock example I had previously created for .NET SDK beta1 consisted of 3 samples to show how to perform basic ADO.NET connectivity with a Ms Access 2000 Database and how to Add, View , Edit , Delete records from it. It also demonstrates how to DataBind Textboxes to a DataSet object.

BUG: The Scale Value for Oracle Numeric Parameter Is Ignored (Q317528)

http://www.kbalertz.com/

When you set the scale for a parameter of type NUMBER, it does not affect the value of the parameter that is passed to the database.

Build a Universal DAL Component

Building a Universal DAL Component

Think about the possibilities of a component in the data access layer (DAL) of your application that didn't care what .NET Data Provider you were using. It could work just as easily with the SQL Server Data Provider or the OleDb Data Provider, or any other potential .NET Data Providers that could surface in the future. A DAL component that you could use against an Access 2000 database in development, and against a SQL Server database in production. In this tutorial, Doug shows how to build a universal data

C# / Oracle Example

C# Help

This is a GUI based data entry application which shows how to add, modify and delete records using Oracle Database. This also shows how to use the ErrorProvider for validations.

Commands in ADO .NET

Common .NET Libraries for Developers

In ADO there are three possible ways to update a data source. One is through direct SQL commands, like INSERT, DELETE and UPDATE, or more complex and sophisticated stored procedures. Another is through batch update, where you submit a new image of a certain table to the server all at once. The third way is through direct fields update using server cursors.

Data Access with ADO.NET - Part 3

Identifies and defines many of common namespaces that you will use when developing .NET applications, and provides examples of the most common classes and methods in those namespaces.

ASP 101

We now know how to access data and put it into a simple, readable form in our ASP .Net web pages, but there's so much more! In this article I am going to explain several more key objects that allow us to efficiently access our data in .Net. I will be using the OleDb flavor of ADO .Net classes for those of you who are not working with SQL Server, but just remember that if you are a SQL Server user, the difference is only in the naming of the classes you use and the connection string (refer to Part I of this series if you're not sure what I'm talking about). So let's get to work.

Data Points

Databinding with Cross a Reference table(many to many)

Contrasting the ADO.NET DataReader and DataSet

DataList vs. DataGrid in ASP.NET

This article shows how to databind a master and details datagrids when using a cross reference table

Displaying Database Stored Images using OleDb .NET Data Provider

This month I want to look at two of the more specialized controls that come with the ASP.NET Framework: the DataList and the DataGrid. Both of these controls are full-featured data-managing tools. In addition to providing a simplified UI programming model for displaying data, ASP.NET includes facilities for binding data sources to these controls so you don't have to write all the code necessary to fish around a database and present your content. This month I'll compare and contrast the DataGrid and DataList controls, starting with DataGrid.

Discussion Forum Board

Master C#

This example updates the previous forum example that I had written for beta1. A lot has changed since then, even though from outside the forum has the same looks internally a lot has changed! Due to this I have taken the trouble to elaborate this example into easy to understand pieces.

Displaying Database Stored Images using OleDb .NET Data Provider

In this article, Donny gives you code illustrating how to display the images stored in a database using the OleDb .NET Data Provider.

In my last article Uploading a file to a database using System.Data.OleDb I described how to save uploaded images to a database using the OleDb .NET Data Provider. In this weeks article I'll give you code illustrating how to display the images stored in a database using the same provider.

File Upload with ASP.NET

Generic Coding with the ADO.NET 2.0 Base Classes and Factories

Back in the ASP world uploading files via a web page was a tricky problem. The problem was that due to the encryption type of the form used to submit the file from the clients browser receiving such files on the server side was a complex task. Data had to be retrieved as a safe byte array and decrypted before it could be used. Most of the people resorted to 3rd party DLLs,a few wrote their own DLLs and some even wrote purely ASP solutions to this problem using VBScript. Fortunately for us, .NET Framework SDK comes with a few classes that make uploading of the files simple from the web developer point of view.

Hardcore Visual Studio .NET: Using DataReaders to Increase Speed and Reduce Memory

Learn more about the new functionality in ADO.NET 2.0 that enables you to create generic data access code.