>I've been using VS2005 and its designers to set up a DataGridView. The DataGridView is being filled by a TableAdapter. The TableAdapter uses a connection object whose connection string is set from
>
>global::GetDatabaseIDsDlg.Properties.Settings.Default.ConnectionStringWoundDB;
>
>This was all set up by the VS2005 designer. This works fine for developing the application. However, I want to be able to change the connection string at runtime. But, I have found that the designer creates Properties.Settings.Default.ConnectionStringWoundDB as ReadOnly. So, I can't change that at runtime.
>
>Surely, there must be some simple way to change the ConnectionString that my TableAdapters are using at runtime. But I haven't been able to figure it out yet. (Still new at .NET development)
>
>Kind of a corrollary: The designers are just implementing in code what I set up on properties pages, etc. But, I can't see where ConnectionStringWoundDB is made read-only.
>
>Thanks for the help.
>
>Jim
When you create the connection string from the designer you can save it to the application's configuration file app.config. To change the connection string then all you have to do is modify it in the configuration file.
Michael McLain