C # winform Development Series-ADO. net

ADO. net name originated from ADO (ActiveX Data Objects), which is a broad class group used to access data in the past Microsoft technology. ADO is used. net name, because Microsoft, you want to indicate that this is in.. NET programming environment.

It provides platform interoperability and Scalable Data Access. Ado. Net enhances the support for non-connection programming modes and supports rich XML. Since the transmitted data is in XML format, any application that can read the XML formatProgramCan process data. In fact, components that accept data are not necessarily ADO. NET components. They can be a Microsoft Visual Studio-based solution or any application running on other platforms.

ADO. NET is an object-oriented class library used to interact with data sources. Generally, the data source is a database, but it can also be a text file, an Excel table or an XML file.

Ado. Net allows interaction with different types of data sources and databases. However, there is not a series of classes related to this to complete such work. Because different data sources adopt different protocols, different data sources must adopt corresponding protocols. Some old-fashioned data sources use the ODBC protocol, and many new data sources use the oledb protocol. Now more data sources are available. net ADO.. Net class library.

ADO. NET provides public methods for interacting with data sources, but uses a set of different class libraries for different data sources. These class libraries are called data providers and are usually named based on the protocols used to interact with them and the data source type. Table 1 contains some common data providers, the API prefixes they use, and data source types that allow interaction.

Basic Concepts

ADO and ADO. net

Dataset and datatable In ADO. NET 2.0

Overview of Data Access Application Block

Datatable. compute powerful functions

C # -- details the computing function of datatable

 

New Features of ADO NET

Transaction in ado.net 2.0

Some personal opinions on ADO. net connection pool

Discuss ADO. Net Object Model

Comparison between ADO and ADO. net

Ado.net 2.0 Learning

 

Introduction to the next generation of ADO. net

Introduction to ADO. NET Entity Framework

Introduction to ADO. NET data services 1.5

Ado.net Entity Framework Series

ADO. NET data service will provide offline Functions

Overview of ADO. Net object framework

ADO. NET data service

Best practices and skills for ADO. net

Interesting understanding of ADO. Net Object Model

Let's talk about ADO. Net vs JDBC.

 

Gao Haidong-ADO. NET 2.0

Ado. NET 2.0 operating instance

New Features of ADO. NET 2.0 dataset and able

Ado. NET 2.0 asynchronous data processing improves user experience

Ado. NET 2.0 large volume data operations and multiple dynamic result sets

Imbob-ADO. net

Analysis of ADO. Net (1)

Analysis of ADO. Net (2)

Analysis of ADO. Net (III)

Analysis of ADO. Net (IV)

Ado. Net Analysis (5)-ADO object --- connection object

Ado. Net Analysis (6)-using parameters and stored procedures

 

Fire★Cold ice-Reading Notes: "C #2005 classic Database Programming Tutorial"

(1) Overview of ADO. NET and its important classes

(2) C # Data Binding

(3) database connection-access the database programmatically

(4) database commands (SQL Server) -- access the database programmatically

(5) data reader object-access the database through programming

(6) data adapter object-access the database programmatically

(8) view

(7) DataSet object-access the database programmatically

(9) Stored Procedure

(10) transactions and concurrency

(11) SQL Server CLR Integration

Practical Application

Introduction to data concurrency in ADO. Net [transfer]

How to create an SQL Server database through a command line in the code

Use MySQL and. net2.0 together

How to read EXCEL from ADO. Net (I)

How to read EXCEL from ADO. Net (below)

Use oledb to import EXCEL to Dataset

How does one import data into Excel by dataset?

Read data from an Excel table to the datagridview.

C # How can I read all the tables in the ACCESS database?

Using ADO. Net to read and write Database BLOB data in blocks

C # three typical database operations

Using sqlbulkcopy to copy a large number of text files C # program code

 

ASP. NET Problems

Use the pageddatasource class to implement paging display of datalist and repeater controls [go]

A new table is returned without refreshing the web service.

Asp.net database connection method

[Translation] use the sqlbulkcopy class in Asp.net 2.0 to copy data in batches

Use sqlbulkcopy to migrate data in Asp.net 2.0

 

Others

Li Tianping my encapsulated ADO. Net for database operations classic class database development personal summary (ADO. Net summary) ADO. Net best practices skills

Master 10 popular techniques of ADO. net

SQL Server. NET Framework data provider connection pool

Comparison of Two transaction methods

Please discuss the necessity of high-performance paging!

Some experience when accessing MySQL database in. net!

SQL Server paging-based stored procedures

[Experience sharing] new high-performance paging Method for massive data

 

Storage Process Writing experience and optimization measures ()

[Original] General paging stored procedures, source code sharing, and mutual improvement

An ideal method for storing tree structure data in relational databases

[Share] tens of millions of paging stored procedures (with effect demonstration)

Let's analyze several paging stored procedures and comment out the best ones to help me wait for cainiao to use them.

For more information, see sqlhelper, accesshelper, mysqlhelper, oraclehelper, xmlhelper, and filehelper.

 

author: peterzb (Personal Development History Knowledge Base-blog)
Source: http://peterzb.cnblogs.com/
Article copyright owned by me, please reprint, however, this statement must be retained without the author's consent and the original article connection should be given clearly on the article page; otherwise, the legal liability should be held accountable.