Introduction Few months back Microsoft released Data Access Application Block for .NET. The application block is nothing but reusable data access layer for SQL Server. This layer encapsulates most of the frequently used data access tasks such...

Introduction While developing a real life software project you need to take in to account many things. One of these things is the choice of database. Most of the times your client will have predefined database (e.g. SQL Server or Oracle). However,...

Introduction Some times we need to store binary data in database. SQL Server provides a special data type called image that can hold such binary data. The examples of binary data include images, documents etc. In this article we will see how...

Introduction ADO.NET provides a powerful way to create objects like dataset and datatale dynamically through code. This code sample illustrates these capabilities of ADO.NET. Namespace involved We will need following...

ADO.NET is next generation of data access technology from Microsoft target at .NET platform. ADO.NET is built with distributed and internet applications in mind. ADO.NET provides strong support for XML and disconnected data processing...

ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and...