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();
}
}
}
}