Loading

how to modify the connection dynamically

Fareeda Hussain

13y1.9k.NET

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravishankar Singh13y ago
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
0
Pankaj Pandey13y ago
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.
0