A服务器数据库数据插入B服务器数据库(C#控制台应用程序)

1.无参数简单类型.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace CRMToSPData
{
    class Program
    {
        static void Main(string[] args)
        {
            //CRM数据库服务器中读取数据
            SqlConnection Sqlcon_CRM = new SqlConnection("Server=10.0.10.105;Uid=sa;pwd=123abc..;DataBase=SP_Chart_86");
            Sqlcon_CRM.Open();
            string SelectSql_CRM = @"SELECT [Mtype],[Amonth],[Bmonth]
      ,[Cmonth],[Dmonth],[Emonth],[Fmonth],[Gmonth],[Hmonth],[Imonth]
      ,[Jmonth],[Kmonth],[Lmonth],[M_Year],[Mdate]
  FROM [SP_Chart_86].[dbo].[Marry_nrep_month]";
            SqlDataAdapter da = new SqlDataAdapter(SelectSql_CRM, Sqlcon_CRM);
            DataSet ds = new DataSet();
            da.Fill(ds, "Marry_nrep_month");
            DataTable dt = new DataTable();
            dt = ds.Tables[0];

            //循环插入Sharepoint数据库服务器数据库中
            SqlConnection Sqlcon_SP = new SqlConnection("Server=10.0.10.158;Uid=sa;pwd=123abc..;DataBase=SP_Chart_86");
            Sqlcon_SP.Open();
            for (int i=0; i< dt.Rows.Count; i++)
            {
                string InsertSql_SP = "insert into Divorce_reg_month(Mtype,Amonth,Bmonth,Cmonth,Dmonth,Emonth,Fmonth,Gmonth,Hmonth,Imonth,Jmonth,Kmonth,Lmonth,M_Year,Mdate) values('" + dt.Rows[i]["Mtype"].ToString() + "','" + dt.Rows[i]["Amonth"].ToString() + "','" + dt.Rows[i]["Bmonth"].ToString() + "','" + dt.Rows[i]["Cmonth"].ToString() + "','" + dt.Rows[i]["Dmonth"].ToString() + "','" + dt.Rows[i]["Emonth"].ToString() + "','" + dt.Rows[i]["Fmonth"].ToString() + "','" + dt.Rows[i]["Gmonth"].ToString() + "','" + dt.Rows[i]["Hmonth"].ToString() + "','" + dt.Rows[i]["Imonth"].ToString() + "','" + dt.Rows[i]["Jmonth"].ToString() + "','" + dt.Rows[i]["Kmonth"].ToString() + "','" + dt.Rows[i]["Lmonth"].ToString() + "','" + dt.Rows[i]["M_Year"].ToString() + "','" + dt.Rows[i]["Mdate"].ToString() + "')";
                SqlCommand com = new SqlCommand(InsertSql_SP, Sqlcon_SP);
                com.ExecuteNonQuery();
            }
        }
    }
}