select ข้อมูลจากเซิฟเวอตัวที่ 1 insert หรือ upade ให้server ตัวที่ 2 database ชื่อเดี่ยวกัน

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WinAppConnMultiDB
{
    public partial class frmConnMulti : Form
    {
        String strConnDataBase1 = "Data Source=NB; Initial Catalog=DataBase1; User Id=sa; Password=nc4400";
        
        String strConnDataBase2 = "Data Source=NB; Initial Catalog=DataBase2; User Id=sa; Password=nc4400";

        SqlConnection objConn;
        SqlCommand objComm;
        SqlDataAdapter da;
        //DataSet ds;
        DataTable dt;
        //SqlDataReader rd;
        
        private BindingSource bindingSource1 = new BindingSource();
           
        public frmConnMulti()
        {
            InitializeComponent();
        }

        private void frmConnMulti_Load(object sender, EventArgs e)
        {    
            try
            {
                //*************************//
                //select data  form database 1
                bindingSource1.DataSource = GetData("SELECT * FROM Table_A");
                //*************************//
               
                //*************************//
                //Open connection Database 2
                objConn = new SqlConnection(strConnDataBase2);
                //*************************//
                objConn.Open();

                //จะเอาที่ได้ จาก(bindingSource1.DataSource = GetData("SELECT * FROM Table_A");) ไปยัดใส่ connection อีกตัว มันได้อย่างไร 

                //*************************//
                //Put the data to server 2  
                //*************************//
               
                //Well done :TRansaction.Commit
                
                //Close connection 1
                //Close connection 2
            }
            catch (Exception ex)
            {
                //Transaction  Rollback;               
                MessageBox.Show("Error:"+ex);
                return;
            }  
           
        }

        private object GetData(string p_strSQLComm)
        {
            objConn = new SqlConnection(strConnDataBase1);
            if (objConn.State == ConnectionState.Open)
            {
                objConn.Close();
            }
            objConn.Open();
            objComm= new SqlCommand(p_strSQLComm, objConn);
            da = new SqlDataAdapter();
            da.SelectCommand = objComm;
            dt = new DataTable();
            dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
            da.Fill(dt);

            return dt;
        }
    }
}

For Each dr as DataRow in dt.Rows
  dr.SetAdded()
Next

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WinAppConnMultiDB
{
    public partial class frmConnMulti : Form
    {
        String strConnDataBase1 = "Data Source=NB; Initial Catalog=DataBase1; User Id=sa; Password=nc4400";
        
        String strConnDataBase2 = "Data Source=NB; Initial Catalog=DataBase2; User Id=sa; Password=nc4400";

        SqlConnection objConn;
        SqlCommand objComm;
        SqlDataAdapter da;
        //DataSet ds;
        
        DataTable dt1;
        DataTable dt2;
        //SqlDataReader rd;

        DataRow dtr;
        
        private BindingSource bindingSource1 = new BindingSource();
           
        public frmConnMulti()
        {
            InitializeComponent();
        }

        private void frmConnMulti_Load(object sender, EventArgs e)
        {    
            try
            {
                //*************************//
                //select data  form database 1

                bindingSource1.DataSource = GetData("SELECT * FROM Table_A");
                //*************************//
               
                //*************************//
                //Open connection Database 2
                objConn = new SqlConnection(strConnDataBase2);
                //*************************//
                objConn.Open();

                //จะเอาที่ได้ จาก(bindingSource1.DataSource = GetData("SELECT * FROM Table_A");) ไปยัดใส่ connection อีกตัว มันได้อย่างไร 

                //*************************//
                //Put the data to server 2  
                //*************************//
               
                //Well done :TRansaction.Commit
                
                //Close connection 1
                //Close connection 2
            }
            catch (Exception ex)
            {
                //Transaction  Rollback;               
                MessageBox.Show("Error:"+ex);
                return;
            }  
           
        }

        private object GetData(string p_strSQLComm)
        {
            objConn = new SqlConnection(strConnDataBase1);
            if (objConn.State == ConnectionState.Open)
            {
                objConn.Close();
            }
            objConn.Open();
            objComm = new SqlCommand(p_strSQLComm, objConn);
            da = new SqlDataAdapter();
            da.SelectCommand = objComm;
            dt1 = new DataTable();
            dt1.Locale = System.Globalization.CultureInfo.InvariantCulture;
            da.Fill(dt1);


            foreach (DataRow dtr in dt1.Rows)
            {
               return dtr.SetAdded();
            }

             

      return dt1;
        }
    }
}

dtable = GetData(...)

' เขียนโค้ดเพื่อสร้าง DataAdapter2 (ถ้าเขียนเป็น ไม่น่าเกิน 10 บรรทัด)
' ....

' เรียก DataAdapter2.Update เพื่อเอาข้อมูลจาก dtable ไปเพิ่มในฐานข้อมูล 2
DataAdapter2.Update(dtable)