ASP.NET

ASP.NET - ADO.net

ASP.NET - ADO.net

ADO.NET connects both front end and backend. It interacts with both displaying of data and hiding details of the movement of data.

DataSet class- The dataset class represents a subset of the database. The dataset contains a data table and data relation object.


 

Properties of DataSet Class

  • CaseSensitive – Indicates string comparison tables are case sensitive or not
  • Container – Gets container for the component
  • Dataset Name – Gets or sets the name of the current data set
  • Design Mode - Indicates whether the component is in design mode
  • Events – Gets the list of event handler
  • Extended Properties – Gets the collection of customized user information
  • Initialized – Indicates if the dataset is initialized
  • Locale – Get or sets the locale information used to compare strings
  • Namespace – Get or sets the namespace
  • Tables – Returns collection of DataTableObject
  • Relations – Returns the collection of DataRelationObject

 

Methods of Data Class

  • AcceptChanges
  • Clear
  • BeginInit
  • Clone
  • Copy
  • CreateDataReader
  • EndInit
  • Equals
  • Finalize
  • Get Change
  • GetType
  • GetXML

DataRow Class- This represents a row in a table.

DataAdapterObject – This acts as a bridge between Dataset object and database.

DataReaderObject- This acts as an alternative to DataSet and DataAdapter combination. This provides connection access to data records.

DbCommand and Db Connection - This object represents a connection to the data source. The connection can be shared among different commands.