方法一:
DataTable table = new DataTable();
//TODO: init table...
string connStr = "user id=" + dbInfo.UserName + ";data source=" + dbInfo.DBServerIP + ";persist security info=False;initial catalog=" + dbInfo.DatabaseName + ";password=" + dbInfo.Password;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(conn);
sqlBulkCopy.DestinationTableName = dbInfo.TableName;
sqlBulkCopy.WriteToServer(table);
sqlBulkCopy.Close();
方法二:
DataTable table = new DataTable();
//TODO: init table...