How Dataadapter.fill works?
Data Adapter act as a middleman between the dataset and data Base. The fill method automatically opens the connection and when the dataset is filled properly then the connection is closed. This method fetch the data from the database