Assalamualaykum Wr Br…Today we understand few thing about ADO.NET architectures then we explore the theory and practical tour. ADO.NET Disconnected architecture is a method of retrieving a record set from the database and storing it giving you the ability to do many CRUD (Create, Read, Update, Delete) operations on the data in memory, then it can be re-synchronized with the database when reconnecting. A method of using disconnected artitecture is using a DataSet.
Connected architecture is when you constaintly make trips to the database for any CRUD operation you wish to do. this creates more traffic to the database but is normally much faster as you should be doing smaller transactions.
Now we start our tour of practice with the following design view as shown:
When you click the Button then in new line Gridview is populated with data in which Disconnected ADO.NET class named SqlDataAdapter is used which executes the command, fills data in DataSet and this DataSet is assigned to GridView as Data Source and finally Binded to Grid. Button_Click Code is demonstrated as below: