How to get data from one server to another server?

Question

How to get data from one server to another server database particular table in asp.net c#.

Joginder Banger · Answer

First of all you need a access permission another server. ok if you have permission try this code public List GetDatabaseList() { List list = new List (); // Open connection to the database string conString = server=xeon;uid=sa;pwd=manager; database=northwind; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); // Set up a command with the given query and associate // this with the current connection. using (SqlCommand cmd = new SqlCommand(SELECT name from sys.databases con)) { using (IDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { DataTable t = con.GetSchema(dr[0].ToString()); } } } } return list; }