copying data of table (.net)

[divaa]

:):rose:how to copy data from different servers(both sqlserver2000), same table names with same structure without using queryanalyser/enterprisemanager editors, through only aspx pages

[pjc 0]

First of all you have to write connection string for both sql server.Then write "insert into tablename" query for both connection string.But make sure,you have to open one sql server connection at a time.For example write ConnectionString for first server connection open insert query for first server connection close ConnectionString for Second server connection open insert query for second server connection close