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
  1. C# ADO.NET Connection
  2. C# SQL Server Connection
  3. C# OLEDB Connection
  4. C# ODBC Connection
  5. C# ADO.NET Command
  6. C# ADO.NET SqlCommand - ExecuteNonQuery
  7. C# ADO.NET OleDbCommand - ExecuteNonQuery
  8. C# ADO.NET SqlCommand - ExecuteScalar
  9. C# ADO.NET OleDbCommand - ExecuteScalar
  10. C# ADO.NET SqlCommand - ExecuteReader
  11. C# ADO.NET OleDbCommand - ExecuteReader
  12. C# ADO.NET DataReader
  13. C# ADO.NET SqlDataReader
  14. C# ADO.NET OleDbDataReader
  15. C# Multiple Result Sets
  16. C# Table Schema from SqlDataReader
  17. C# Table Schema from OleDbDataReader
  18. C# ADO.NET DataAdapter
  19. C# ADO.NET SqlDataAdapter
  20. C# ADO.NET OleDbDataAdapter
  21. C# ExecuteReader and ExecuteNonQuery
  22. System.Data.SqlClient.SqlException: Login failed for user


Related Topics
  1. Stored Procedures in C#
  2. C# Stored Procedure with Parameter