two connection string using sql database in asp.net using C#

Question

Iam developing a web page in that iam using two database in a program.iam using dropdown list for selecting database.can any plz help me how to write a code for it.common file for entry project.and i need to save data when i go to next page.

Santhosh Kumar Jayaraman · Answer

sample code in dropdown selection changed event set your sqlconnection and call all sqlcommand using same sqlconnection protected void SelectedIndexChanged(object sender EventArgs e) { SqlConnection con = new SqlConnection(Data Source= localhost\sqlexpress; Initial Catalog= + ddl.SelectedValue + ;Integrated Security=SSPI;); con.Open(); SqlCommand cmd = new SqlCommand(select name from test con); string s=cmd.ExecuteScalar().ToString(); con.Close(); } i have attached sample one.