利用DataTable快速批量導資料

標籤：des   os   io   資料   2014   cti   log   new   

 DataSet ds = new DataSet();
            using (SqlConnection conn = new SqlConnection(@"data source=.\sqlxu;initial catalog=NationalUnion20140717;persist security info=True;user id=sa;password=101;MultipleActiveResultSets=True"))
            {
                SqlDataAdapter da = new SqlDataAdapter("select * from [dbo].[ProductType]", conn);
                da.Fill(ds);
            }

            string connTest = @"data source=10.57.40.184;initial catalog=NationalUnion;persist security info=True;user id=NationalUsers;[email protected];MultipleActiveResultSets=True";
            //using (SqlConnection connTest = new SqlConnection())
            //{
            SqlBulkCopy sbc = new SqlBulkCopy(connTest, SqlBulkCopyOptions.UseInternalTransaction);
            sbc.DestinationTableName = "[dbo].[ProductType]";
            sbc.BulkCopyTimeout = 0;
            sbc.WriteToServer(ds.Tables[0]);