how to retrieve the data from the another server

Apr 8 2014 4:17 AM

how to retrieve the data from the another server (LAN ) through coding normally we give connection in web config file as

<add key="RM" value="Data Source=VALUED-HO1E64NO\SQLEXPRESS; Initial Catalog=Agri;user id=sa;password=watt"/>

i need to retrieve the data from another server