Which method do you invoke on the DataAdapter control to load your generated dataset with data?
dataAdapter.Fill(ds). The beauty of this method is it automatically implicitly opens the connection to database and closes it once done.We dont need to worry about opening and closing the connection to the database.