How to fetch data from different database located in Remote

Add connection string section in your web config

<connectionStrings>
    <add name="ConnectionString" connectionString="Data Source=Public ip of the server;Initial Catalog=Db name;Pooling=False;User ID=id;Password=password;" providerName="System.Data.SqlClient" />
</connectionStrings>

Now in your c# code

string ConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

using (SqlConnection SqlConn = new SqlConnection(ConnString))
                {
                    SqlCommand sqlCmd = new SqlCommand("Select * From table", SqlConn);
                    DataTable dtSource = new DataTable();
                    using (SqlDataAdapter da = new SqlDataAdapter(sqlCmd))
                    {
                        da.Fill(dtSource);
                    }
}

The above code gets data from a table from the data server mentioned in the connection string.

You can provide multiple connection string in your web config file and use the above code again to get the data from different databases(servers)

Happy Coding!! :)

Thanks,
Vj

First of all you have to know the IP for the server or you can also use the server name as well, then prepare the connection string like below :-

Server=192.168.10.20;Database=myDataBase;User Id=myUsername;
Password=myPassword;

Then to fetch data from this remote database server using this connection string is as follows :-

public DataSet GetData()
{
	DataSet myDataSetset=new DataSet();
	string strConnectionString = "write your connection string here";
	string strQuery = "Select * From Person";
	using (SqlConnection connection = new SqlConnection(strConnectionString))
	{
  	SqlDataAdapter dAdapter=new SqlDataAdapter();
  	dAdapter.SelectCommand=new SqlCommand(strQuery, connection);
  
  	dadapter.Fill(myDataSetset);
	}

	return myDataSetset;
}

This above method will fetch data from the remote server and return you the data in DataSet.

Hope this will be helpful and fulfils what you want.
Please let me know if any further help you need on this.

go through the below link I hope this will help you

http://stackoverflow.com/questions/15236961/sql-merge-to-remote-linked-server-table[^]


Thanks,
-RG