Loading

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

sireesha

13y2.4k.NET

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.

1 Reply

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

Santhosh Kumar Jayaraman13y ago
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.