Loading

change tableadapter connection string at runtime

honar abubakr

hello, in my c# project i have DataSet abs_ds inside a DataSet i have a TableAdapter ta1 ta get a data from a stored procedure in an sql server 2014 database, as you know when create a TableAdapter we muts create a connection for it, Know i want to change this connection to another connection programically i want to set a connection to it at runTime. is there any way to do that?

1 Reply

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

Tapan Patel10y ago
You can always use the config file for storing the connection string but it would be great if you can set Integrated security on. In that case you won't be storing the username and password in config file and using Connectionstringbuilder class, you should be able to change the connection string at runtime.