Change Connection String in app.config with code

Question

Guys,

This is a long shot, but can you change the connection string in the app.config on a windows form app with code?

I want to launch my app and give a choice of which database it loads, i.e. my application can load data from 2 different databases but i need to swap the connection string via a user control (like a button click) to do this.

Is it possible?

Answer 1

Use this code in selected index changed event of combobox

 

for(int i=0; i<dataGridView1.Rows.Count;i++)

{

   dataGridView1.Rows[i].Cells[6].Value=comboBox1.SelectedValue;

}

 

 

Answer 2

Hii Ranjit,

thank you for your reply. there is just one little change I have to do that is instead of 'combobox1.SelectedValue' I added 'SelectedItem'. it is because when I used SelectedValue, and changed the value from combobox, all the values went blank...

 

'combobox1.text' also works.

 

anyway, my problem is solved.

thank you once again.

 

Mayank Jani