You can get at connection strings in the config file using the ConfigurationManager class and its ConnectionStrings property.

DataSets were created specifically to be disconnected from the data source so, no, using one will not lock any database records or tables. The drawback is that if multiple users are accessing the data you have to allow for concurrency issues.