Get Data From one SQL Server to Other SQL server (using C#)

Question

I want the code for copy data from one sql to another sql (Using C#)

When I click the Button

Copy my db2_connect Database data like:

select * from importdb where bhand = 3 and store = 14

To my another database which is: abdConnection

in abdConnection Table is importabd and filed is same (bhand)

Can someone write the complete code.

Thanking You