DataSet
is the most versatile component of ADO.NET as it can load data from not only database objects but also XML, Excel worksheets, and so on. Its ability to load data from XML documents is really helpful if you want to keep configuration data such as Web Service host address and locale-based messages. In this recipe, we will make use of DataSet
to load the configuration details from the XML document, modify the data, and save it back into the XML document.
We will also use DataGridView
to display the loaded data and provide a UI to the user for modifying and saving the data. In this recipe you will also see how well DataGridView
plays with DataSet
.