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)

Building a data grid using ADO.NET and SQL Server     
Total Hits: 85  |  Today: 0Author: Wim Hollebrandse      Rating:  
Read Reviews | Write Review |  Your Rating: 

Time to have a look at some ADO.NET stuff. In this article we will see how easy it is, to create a simple DataGrid control and bind it to a DataSet object. No more "While not rstProducts.EOF….Wend" statements anymore to list your recordsets! Also, we will have a look at how code behind works. Note that code behind itself has nothing to do with the CodeBehind attribute in the @Page directive, which is only used by Visual Studio .NET....

Getting Distinct Rows in ADO.NET     
Total Hits: 102  |  Today: 0Author: J. Michael Palermo IV      Rating:  
Read Reviews | Write Review |  Your Rating: 

Accessing data with ADO.NET is usually straight forward. However, once the data we receive is stored in a DataTable, we may begin to feel the limitations of the API when real-world scenarios demand more than the built-in features. One such case is when we need to get the distinct values of an already populated DataTable (or DataView)....

What's In Your Database? Find Out with the Schema API in ADO.NET 2.0     
Total Hits: 197  |  Today: 0Author: Alex Homer      Rating:  
Read Reviews | Write Review |  Your Rating: 

Most data access technologies provide a way for you to query the schema of a database, and obtain information about the tables, stored procedures, data types, users, and other content of a database. However, the technique varies depending on the data provider or database driver you are using and is not always straightforward to implement. In ADO.NET 2.0, Microsoft has added a set of features to the standard managed code classes that you can use as an API to query database schemas. This article l...

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...

What's New in ADO.NET 2.0 for SQL Developers     
Total Hits: 154  |  Today: 0Author: Dino Esposito      Rating:  
Read Reviews | Write Review |  Your Rating: 

To write effective .NET data-driven applications, a deep understanding of the ADO.NET object model is essential. In version 2.0 of the .NET Framework, the set of classes that form the ADO.NET object model are nearly identical to those in version 1.1, but Microsoft has introduced a few key changes. This article examines what's new in the ADO.NET 2.0 classes for database developers. Most of the enhancements fall in two main areas: .NET provider model and SQL Server managed provider. Some of the ne...

Total Hits: 42  |  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: 78  |  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....

Reading Excel (.xls) Files with ADO.NET...     
Total Hits: 231  |  Today: 0Author: John Kilgo      Rating:  
Read Reviews | Write Review |  Your Rating: 

With a little preparation on the Excel side and very little work on the ADO.NET side you can connect to and read Excel workbooks just as though they were database tables.
Since Excel has an OleDB provider, we can use ADO.NET's OleDb functionality to connect to Excel. It does take a little preparation on the Excel side however. You might think that since Excel has rows and columns we might be able to use that and refer to A1 and B3, etc. We can't (as far as I know). We must resort to another ...

ADO.NET: Building a Distributed Component Server using C# and .NET     
Total Hits: 93  |  Today: 0Author: Gopalan Suresh Raj      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, we are going to build a Distributed Component to illustrate ADO.NET's disconnected operation facility - the DataSet.The DataSet facilitates the client to manipulate and update a local copy of any number of related tables while still disconnected from the data source and submit the modified data back for processing using a related data adapter at a later point in time. As a result, all our data is going to be maintained on the server in an XML datastore (or flat-file) until chang...

What .NET 2.0 Has in Store for ADO.NET     
Total Hits: 231  |  Today: 0Author: Mark Strawmyer      Rating:  
Read Reviews | Write Review |  Your Rating: 

The article basically demonstrates the use of the factory design pattern to decide at runtime which specific instances of database-related objects to create. It was a necessary evil for those of us unfortunate enough to have to move between different databases such as SQL Server and Oracle and not wanting to produce a bunch of provider-specific code in case the database changed . The factory determines the concrete connection, command, and other objects to create based on the database being acce...

DataSets in Microsoft .NET - 1     
Total Hits: 137  |  Today: 0Author: c-sharpcorner      Rating:  
Read Reviews | Write Review |  Your Rating: 

ADO.NET was designed to meet the needs of this new programming model: disconnected data architecture, tight integration with XML, common data representation with the ability to combine data from multiple and varied data sources, and optimized facilities for interacting with a database, all native to the .NET Framework....

Reading and Writing Bitmaps or BLOB Data in ADO.NET     
Total Hits: 161  |  Today: 0Author: vbdotnetheaven      Rating:  
Read Reviews | Write Review |  Your Rating: 

Often you may need to save user images in a database and then read back from a database when needed. For an example, we’ll save an author’s photo in a database so it can be read later to display in the author’s article....

ADO.NET Series - Executing SELECT commands     
Total Hits: 97  |  Today: 0Author: DotNetBips      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the previous article of the series we saw how to connect with a SQL server database. Connection with database is useful only if we can execute SQL statements against the database. This article is meant to show you how to execute SELECT statements against SQL server database and iterate through the returned results using DataReader....

Use DataReader Cleverly     
Total Hits: 60  |  Today: 0Author: dotnetbips      Rating:  
Read Reviews | Write Review |  Your Rating: 

ADO.NET DataReader is a read only and forward only cursor that allows you to iterate through the records very fast. In terms of performance DataReader is possibly the fastest way to fetch and iterate the rows. However, if used incorrectly it can cause some troubles. This article throws light on some of such things to watch for while you code and explains general dos and don'ts about DataReader....

Accessing SQL Server Data in C# with ADO.NET     
Total Hits: 249  |  Today: 0Author: devhood      Rating:  
Read Reviews | Write Review |  Your Rating: 

ADO.NET is the next iteration of ADO/OLEDB and refers to a set of .NET namespaces that control data manipulation and database connectivity. Note that everything below applies to ASP.NET programs that use a C# codebehind file just as well as a regular C# file....

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 ADO.NET with SQL Server     
Total Hits: 209  |  Today: 0Author: developerfusion      Rating:  
Read Reviews | Write Review |  Your Rating: 

An extensive examination of using ADO.NET to access SQL Server databases, from establishing connections and executing stored procedures, to connection pools, data readers and data sets....

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 ...

Multiple Result Sets in using SqlClient     
Total Hits: 217  |  Today: 0Author: Raghu Vangala      Rating:  
Read Reviews | Write Review |  Your Rating: 

. Net has many cool features for SQL server 2000 to improve the over all scalability of the applications. We will see one of the cool futures today; retrieve multiple result sets in a single SqlDataReader....

Disclaimer - Privacy
© 2002-2017