Get the data from the second databse from the config file

Hi San,

Hi,

No need to get confused here. We needs to pass the required connection string to the SqlCommand constructor as like below.

string city = string.Empty;

//Here I'm using constr2 if you want from connstr1, you can pass connstr1 to the sqlcommand constructor if your string is first one.

using (SqlCommand cmd = new SqlCommand("SELECT City FROM Persons WHERE Name=@Name", connStr2 ))

{

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue("@Name", name);

con.Open();

object o = cmd.ExecuteScalar();

if (o != null)

{

city = o.ToString();

}

con.Close();

}

//Filling to textbax :

txtCity.Text = city;

Mark as answer, If it helps. Else come up with yourquery.

Thank you.