C# Data Providers
The ADO.NET classes are divided into two components, the Data Providers and the Dataset. A .NET data provider is used to connect to a database, execute commands, and retrieve results and the DataSet consists of a local buffer of tables and relations entirely independent of the original data source. From the following C# programs you can see some basic operations in ADO.NET Classes.
Related Topics
- C# ADO.NET Connection
- C# SQL Server Connection
- C# OLEDB Connection
- C# ODBC Connection
- C# ADO.NET Command
- C# ADO.NET SqlCommand - ExecuteNonQuery
- C# ADO.NET OleDbCommand - ExecuteNonQuery
- C# ADO.NET SqlCommand - ExecuteScalar
- C# ADO.NET OleDbCommand - ExecuteScalar
- C# ADO.NET SqlCommand - ExecuteReader
- C# ADO.NET OleDbCommand - ExecuteReader
- C# ADO.NET DataReader
- C# ADO.NET SqlDataReader
- C# ADO.NET OleDbDataReader
- C# Multiple Result Sets
- C# Table Schema from SqlDataReader
- C# Table Schema from OleDbDataReader
- C# ADO.NET DataAdapter
- C# ADO.NET SqlDataAdapter
- C# ADO.NET OleDbDataAdapter
- C# ExecuteReader and ExecuteNonQuery
- System.Data.SqlClient.SqlException: Login failed for user
Related Topics