Data Classes - DataView DataGridView Control

Data Classes - DataView DataGridView Control's Objectives is Data Class (DataAdapter, DataReader, DataSet, DataTable); DataView; DataGridView Control. It includes DataAdapter Properties, SqlDataAdapter; OleDbDataAdapter; SqlDataReader class; DataSet;. | Data Classes- DataView DataGridView Control Objectives Data Class DataAdapter DataReader DataSet DataTable DataView DataGridView Control Summary DataAdapter Properties Demo SqlDataAdapter is the best way to load data from server to DataSet SqlDataAdapter : properties - Events SqlDataAdapter dataAdapt = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(“Select * from authors” , con); = cmd ; DataSet ds = new DataSet(); (ds); DeleteCommand InsertCommand SelectCommand UpdateCommand RowUpdate RowUpdating OleDbDataAdapter Used to connect to multiple databses such as : SQLServer , Access , Oracle Exists in the namespace : Have the same properties and events as SqlDataAdapter SqlDataReader class Used to read data from SQL Server in a sequential manner and have some properties : Forward-only - Read Only Get it by call the ExecuteReader() method of SqlCommand object Read data by Read() method FieldCount HasRow IsClosed Item RecordsAffected SqlDataReader : Method DataSet A representation of a database in cached-memory Included datatable and relation and contrains Ex : DataSet ds = new DataSet() Method – Kind of DataSet TypeDataSet : Have a schema : .xsd UntypeDataSet : Create by a code : DataSet A = new DataSet() Navigate Record : Using Binding source class and use some methods of this class as : MoveFirst MoveLast MoveNext MovePrevious DataSet and XML DataSet can fetch data from a XML file ReadXML(string path) : read XML file to DataSet WriteXML(string path) : save the content DataSet to a XML file DataTable class Represent a table in DataSet Have a constraint objects that ensure data integrity Properties Method DataTable: Event DataTableCollection The DataTableCollection class is a collection of the tables in DataSet Collection of the DataTable class DataRelation Maintains referential integrity by enforcing foreign-key constraint Unique constraint . | Data Classes- DataView DataGridView Control Objectives Data Class DataAdapter DataReader DataSet DataTable DataView DataGridView Control Summary DataAdapter Properties Demo SqlDataAdapter is the best way to load data from server to DataSet SqlDataAdapter : properties - Events SqlDataAdapter dataAdapt = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(“Select * from authors” , con); = cmd ; DataSet ds = new DataSet(); (ds); DeleteCommand InsertCommand SelectCommand UpdateCommand RowUpdate RowUpdating OleDbDataAdapter Used to connect to multiple databses such as : SQLServer , Access , Oracle Exists in the namespace : Have the same properties and events as SqlDataAdapter SqlDataReader class Used to read data from SQL Server in a sequential manner and have some properties : Forward-only - Read Only Get it by call the ExecuteReader() method of SqlCommand object Read data by Read() method FieldCount .