how to modify the connection dynamically

Question

Hi
How to modify the connection string in asp.net so that all dataset in my webapplication get refresh .Because my database is ms access and the refresh button inside dataset set designer is disabled.

Thanks
Fareeda

Ravishankar Singh · Answer

Hi You can try this: var conString = string.Format(Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}  Path.Combine(dir nik.mdb)); var conBuilder = new OleDbConnectionStringBuilder(conString); using (var con = new OleDbConnection(conBuilder.ConnectionString)) { // ... } Reference: http://stackoverflow.com/questions/14504769/create-connection-string-for-ms-access-dynamically

Pankaj Pandey · Answer

hiii here a property can use . define your connection like.. OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = abc; on the condition you can change connection string.