I am sharing this because I see a lot of questions on the forums on how to get the value from the Grid View object, and I know how.
Data Sets only hold data and do not interact with the underlying database table.
You now have data in the Data Set and there is no active connection to the database.
At this point you can make any changes(insert, update, delete) to the data in the Data Set.
IIS7 has introduced new add element of IPSecurity collection that allows to block IP addresses directly from the web.config without changing the metadatabase.
This, combined with config Source feature allows us to dump all IPs into a single xml file making it easy to manipulate and maintain.
This article shows how to block IP addresses programmatically using the IPSecurity element and splitting the config file with config Source.Specifies the subnet mask with which to evaluate the IP address for this restriction rule.Only the data in the Data Set is changed, the underlying database table data is not changed.4.To update the underlying database table, invoke Sql Data Adapter. Make sure there is an UPDATE, DELETE and INSERT command are associated with Sql Data Adapter object when Update() method is called, otherwise there would be a runtime exception.The Data Set object has no knowledge of the underlying Data Source. Fill() method is invoked, Sql Data Adapter opens the connection to the database, executes the select command, and the Data Set is populated with the data that is retrieved.It is the Sql Data Adapter object that retrieves data from the datasource. The Sql Data Adapter automatically closes the connection.3.