Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
SQL Server

Home >Search > Articles & Samples > ADO.NET
What's New - What's Hot
Listings for General General (335)
Listings for SQL Client SQL Client (2)
Listings for SQL Server SQL Server (58)
Listings for Stored Procedures Stored Procedures (16)

DataTable Enhancements in ADO.NET 2.0  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: Joydip Kanjilal      Rating:  
Read Reviews | Write Review |  Your Rating: 

ADO.NET 2.0 has added many new powerful features to the DataTable class. Some of these features include the ability to load a DataReader instance into a DataTable instance by using the Load method of the DataTable class, the DataTableReader, built-in serialization support, etc. This article highlights these new features added to the DataTable class in ADO.NET 2.0....

Working with Exceptions in ADO.NET  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Joydip Kanjilal      Rating:  
Read Reviews | Write Review |  Your Rating: 

ADO.NET is a very rich data access technology with a plenty of powerful features - improved performance, an optimized SQL Provider, seamless support for XML and ability to work in connected and disconnected mode, to name a few. Handling exceptions properly is one of the prime concerns when working with any data access technologies. The new version of ADO.NET includes powerful support for working with exceptions efficiently. This article throws light on how to handle exceptions efficiently when w...

ADO.NET 101: SQL Connection  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: mysorian      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article meant as a tutorial deals only with connecting to databases on a SQL2000 server. Various connection options are discussed and their implementation details are shown. Data retrieval and data manipulation will be discussed in a future article. Only very simple, but basic code to test the connection is used, and each case uses a different ASPX page. This article is self-contained and complete, a copy of the projects in zip format is provided for download....

ADO.NET v2.0: ObjectSpaces Delivers an O/R Mapper  Version: 0.00     Price: $0.00  
Total Hits: 6  |  Today: 0Author: Paul Wilson      Rating:  
Read Reviews | Write Review |  Your Rating: 

ADO.NET v2.0 will finally provide a built-in object-relational mapper called ObjectSpaces. What is an O/R mapper? Its a framework that lets you totally avoid SQL and stored procs! Note that I'm not talking about generating the SQL or stored procs, like many tools do now; no, I mean totally avoid it and have the framework transparently do all the CRUD for you. That may sound like an impossible dream, if you've never looked into these types of tools, but its very doable and its been rather commonp...

Linq to SQL versus ADO.NET     
Total Hits: 19  |  Today: 0Author: Islam ElDemery      Rating:  
Read Reviews | Write Review |  Your Rating: 

The article shows a simple comparison between Linq to SQL and ADO.NET for the excution time of Selecting data from SQL Server Database. LINQ to SQL provides a runtime infrastructure for managing relational data as objects without losing the ability to query. Your application is free to manipulate the objects while LINQ to SQL stays in the background tracking your changes automatically. Linq to SQL gives you your database, tables, columns as objects that you can use them directly in your C# or VB...

Data Access Strategies Using ADO.NET and SQL     
Total Hits: 45  |  Today: 0Author: John Papa      Rating:  
Read Reviews | Write Review |  Your Rating: 

When your goal is a scalable and efficient enterprise solution, you need to develop an efficient data-access strategy. You can't just do some testing on your production machines and rely on the results. While an application can exhibit excellent response times when serving a few users, performance problems can surface when the load increases. So when I am asked to perform architectural and code reviews, there are several coding patterns I look for. In this column, I will share some of them as th...

Understanding ODBC .NET data provider     
Total Hits: 170  |  Today: 0Author: Mahesh Chand      Rating:  
Read Reviews | Write Review |  Your Rating: 

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 sources such as Oracle, MySQL, Excel, Access, Text, and Sybase using ODBC data provider....

The Journey Toward ADO.NET     
Total Hits: 19  |  Today: 0Author: Reshmi Nair      Rating:  
Read Reviews | Write Review |  Your Rating: 

The journey to ADO.NET started with Microsoft's first offering for accessing data viz. DAO (Data access objects) which was designed basically keeping in mind the need of VB programmers to access Microsoft's Access database (also known as the Jet Engine). This technology could be used for accessing the SQL Server and Oracle databases too but this proved to be extremely slow and painful. The process was slow because even though DAO uses ODBC it is designed specifically to talk to Jet. Jet translat...

Introduction to ADO.NET     
Total Hits: 66  |  Today: 0Author: Dimitrios Markatos      Rating:  
Read Reviews | Write Review |  Your Rating: 

The advent of ASP back in late 1996 when ADO 1.0 was released represented a new way of dynamically retrieving data from a database. Though ADO was at its very infancy then, and was something of an offshoot of DAO and RDO, nevertheless it represented a new bold direction. Each subsequent version of the technology leads us one step closer to ADO 2.6, when development came to an end. At this point, emerging from the shadows came the most revolutionary framework to date - .NET, with it the very powe...

ADO.NET Overview     
Total Hits: 68  |  Today: 0Author: Karl Moore      Rating:  
Read Reviews | Write Review |  Your Rating: 

Most applications handle data, whether in the form of a database, text file, spreadsheet, whatever — the majority of modern day programs need access to an information store.
Now when Visual Basic 3.0 came along with its new and groovy data access capabilities, people were amazed. Suddenly a mass of Access desktop applications sprung up and the world was at peace....

Handling Concurrency Issues in ADO.NET     
Total Hits: 163  |  Today: 0Author: Peter A. Bromberg      Rating:  
Read Reviews | Write Review |  Your Rating: 

One topic that keeps coming up in our forums and in newsgroups could be phrased as “how can I prevent users from updating data that another user is editing”. Usually this revolves (incorrectly) around the idea that you should have some way to “lock” a table or tables while a user is editing same. However, the “disconnected data” paradigm of ADO.NET makes this approach both unrealistic and in many cases, unfeasible....

What is ADO.NET?     
Total Hits: 42  |  Today: 0Author: Amit Verma      Rating:  
Read Reviews | Write Review |  Your Rating: 

.ADO.NET is an evolution of the ADO data access model that directly addresses user requirements for developing scalable applications. It was designed specifically for the web with scalability, statelessness, and XML in mind. ADO.NET uses some ADO objects, such as the Connection and Command objects, and also introduces new objects. Key new ADO.NET objects include the DataSet, DataReader, and DataAdapter....

Connected Operations in ADO.NET     
Total Hits: 138  |  Today: 0Author: Dale Michalk.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Connected operations in ADO.NET are data access scenarios that require tight binding and open connection to the data source while working with the connected subset of the ADO.NET object model. This is in contrast to the round-tripping and client manipulation of the DataSet, which is the disconnected data vehicle of choice in ADO.NET....

Disconnected Operations Part I: DataSet and DataAdapter     
Total Hits: 66  |  Today: 0Author: Dale Michalk.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Disconnected operations in ADO.NET consist of data access scenarios that don't require the maintenance of an open database connection while working with data. This contrasts with the connected operations discussed in the preceding article in this series, which utilize the DataReader and Command classes. The primary vehicle for working with disconnected operations is the DataSet; it allows us to connect to a data source, manipulate the DataSet offline, and later reconnect to update the data sourc...

Overview of ADO.NET 2.0(Whidbey) New Features     
Total Hits: 32  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, i am going to talk about some of the new features of ADO.NET 2.0. I just started working on ADO.NET 2.0. So this is just an starting, I will keep updating this article as when i find anything interesting in ADO.NET 2.0...

Total Hits: 41  |  Today: 0Author: Anoop. H      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article talks about ADO.NET object DataSet and its types.As the name implies, Dataset store data in disconnected cache. This object resides in memory that provides a relational programming model regardless of the data source....

Programmatically using ADO.NET and XML     
Total Hits: 77  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

With ADO.NET, a database can be regarded as a virtual XML document. XPath query and XSLT transformation are naturally available...

Retrieving Database Schema Information using the OleDb     
Total Hits: 40  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

As well as querying and inserting data into a database, there is sometimes the need to retrieve information about the database schema. Steven Swafford looks at how we can accomplish this using the OleDbSchemaGuid class of the System.Data.OleDb namespace....

Getting Started with ADO.NET     
Total Hits: 26  |  Today: 0Author: devcity      Rating:  
Read Reviews | Write Review |  Your Rating: 

Introductory article in a series of articles on ADO.NET by Gurneet Singh. Covers the essentials of ADO.NET...

Using the DataGrid Control     
Total Hits: 58  |  Today: 0Author: codeproject      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Windows Forms DataGrid control provides a user interface to ADO.NET datasets, displays ADO.NET tabular data in a scrollable grid, and allows for updates to the data source. In cases where the DataGrid is bound to a data source with a single table containing no relationships, the data appears in simple rows and columns, as in a spreadsheet.As soon as the DataGrid control is set to a valid data source, the control is automatically populated, by creating columns and rows based on the structure ...

Disclaimer - Privacy
© 2002-2017