ADO.NET :: Classes for holding data

Classes for holding data The following are the main classes used to hold data in Ado.NET: DataSet DataTable DataRow A DataSet is an in-memory representation of the database. DataSet contains DataTables (and more...) DataTable represents a database table DataTable contains DataRows (and more...) A DataRow represents a record in a database table. DataRow is a collection of all fields in a record. We can use the DataAdapter or DataReader to populate data in DataSet. Once...

Read More »

ADO.NET :: Classes for communicating with database

Classes for communicating with database The Connection, Command, DataReader, and DataAdapter objects are the core elements of the ADO.NET provider model. Object Description SqlClient Objects OleDb Objects Connection Establishes a connection to a specific data source. SqlConnection OleDbConnection Command Executes a command against a data source. SqlCommand ...

Read More »

ADO.NET :: ADO.NET and DataAccess Providers in .NET

ADO.NET ADO.NET is the data access model that comes with the .NET Framework. ADO.NET provides the classes required to communicate with any database source (including Oracle, Sybase, Microsoft Access, Xml, and even text files). DataAccess Providers in .NET ADO.NET comes with few providers, including: OleDb SqlClient There are other providers available, but we are not including them here as this tutorial is meant for beginners! When you want them, search for ADO.NET...

Read More »

ADO.NET :: Database Concepts

Database Concepts Database is the media to store data. If you have an application that has to store and retrieve data, your application must be using a database. A File is the simplest form of saving the data in the disk, but is not the most efficient way of managing application data. A database is basically a collection of one or more files, but in a custom format, and data is organized in a specific format such a way that it can be retrieved and stored very efficiently. Some...

Read More »

ADO.NET for Beginners

ADO.NET for Beginners Accessing Database Accessing database using ADO.NET in C# or VB.NET This tutorial will teach you Database concepts and ADO.NET in a very simple and easy-to-understand manner with many code snippets and samples. This is primarily meant for beginners and if you are looking for any advanced ADO.NET topics, this may not be the right page for you. Topic Covered...

Read More »