ASP.NET - Data Connection Key Terms

Here are some key terms and concepts to know for database connection, data source, and data binding in ASP.NET:

  • Connection string: A string that specifies the information required to connect to a database, including the database provider, server name, database name, and credentials.
  • SqlConnection: A class that represents a connection to a SQL Server database.
  • SqlCommand: A class that represents a SQL statement or stored procedure to be executed against a database.
  • SqlDataReader: A class that reads a forward-only stream of rows from a SQL Server database.
  • SqlDataAdapter: A class that retrieves data from a database and populates a dataset, or updates a database with changes made to a dataset.
  • DataSet: A collection of tables, relations, and constraints that make up an in-memory representation of data retrieved from a database.
  • Data Source: A control that provides a connection to a data source and enables data binding to other controls on a web page.
  • Data Source Control: A control that provides access to a data source and exposes a set of methods and properties for performing database operations.
  • Data-bound control: A control that is bound to a data source and displays data from the data source, such as GridView or DropDownList.
  • Data Binding: A technique used to display data from a database in controls on a web page, using data source controls and data-bound controls.
  • Data Source View: A structured representation of a data source that defines the capabilities of the data source and enables data source controls to interact with it.