DataConvert，实现MDB到Oracle属性、空间数据的插入

最新推荐文章于 2022-01-14 18:17:39 发布
最新推荐文章于 2022-01-14 18:17:39 发布
阅读量1.3k 收藏
点赞数
文章标签： C# ArcGIS Engine 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kone0611/article/details/48730605
版权 
        public static class DataConvert
        {
        #region 将mdb中要素类转换追加到sde数据库已有的要素类中  
        /// <summary>
        /// 将mdb中要素类转换追加到sde数据库已有的要素类中  
        /// </summary>
        /// <param name="sourceWorkspace">源工作空间</param>
        /// <param name="targetWorkspace">目标工作空间</param>
        /// <param name="nameOfSourceFeatureClass">源FeatureClass名称</param>
        /// <param name="nameOfTargetFeatureClass">目标FeatureClass名称</param>
        public static void AddMDBFeatureClassToSDE(IWorkspace sourceWorkspace, IWorkspace targetWorkspace,string nameOfSourceAttributeTable, string nameOfSourceSpatialTable, string nameOfTargetSpatialTable)
        {
            try
            {
                IFeatureWorkspace pSourceFW = sourceWorkspace as IFeatureWorkspace;
                //源空间表
                IFeatureClass pSourceFc = pSourceFW.OpenFeatureClass(nameOfSourceSpatialTable);
                //源属性表
                ITable pSourceAttributeTable = pSourceFW.OpenTable(nameOfSourceAttributeTable);

                IFeatureWorkspace pTargetFW = targetWorkspace as IFeatureWorkspace;
                //目标空间表
                IFeatureClass pTargetFc = pTargetFW.OpenFeatureClass(nameOfTargetSpatialTable);


                if (pTargetFc.AliasName == "采伐小班")
                {
                    //空间数据从mdb导入到oracle数据库
                    mdb2fc(targetWorkspace, pSourceFc, pTargetFc);
                    //属性数据从mdb导入到oracle数据库
                    mdb2fcOfAttributeTable_Cf(targetWorkspace, pSourceAttributeTable, pTargetFc);
                }
                if (pTargetFc.AliasName == "征占小班")
                {
                    //空间数据从mdb导入到oracle数据库
                    mdb2fc(targetWorkspace, pSourceFc, pTargetFc);
                    mdb2fcOfAttributeTable_Zz(targetWorkspace, pSourceAttributeTable, pTargetFc);
                }
            }
            catch(Exception ex)
            {
                ForeStar.CoreUI.Message.MessageManager.Show(ForeStar.CoreUI.Message.MessageType.Error,ex.Message, "提示");
                return;
            }
        }

       
        #endregion

        #region 空间数据导入——追加要素到SDE的featureclass中
        /// <summary>
        /// 追加要素到SDE的featureclass中  
        /// </summary>
        /// <param name="targetWorkspace">源工作空间</param>
        /// <param name="pSourceFc"></param>
        /// <param name="pTargetFc"></param>
        private static void mdb2fc(IWorkspace targetWorkspace, IFeatureClass pSourceFc, IFeatureClass pTargetFc)
        {
            IFeatureCursor pFeaCursor = pSourceFc.Search(null, false);
            //目标工作空间开启编辑模式
            IWorkspaceEdit workSpaceEdit = targetWorkspace as IWorkspaceEdit;
            workSpaceEdit.StartEditing(false);
            workSpaceEdit.StartEditOperation();

            IFeature pFeature = pFeaCursor.NextFeature();

            IField pField = new FieldClass();
            int iIndex = 0;
            while (pFeature != null)
            {
                ESRI.ArcGIS.Geodatabase.IFeature tempFeature = pTargetFc.CreateFeature();
                tempFeature.Shape = pFeature.Shape;
                try
                {
                    //添加字段值  
                    for (int j = 0; j < pSourceFc.Fields.FieldCount; j++)
                    {
                        pField = pSourceFc.Fields.get_Field(j);
                        iIndex = tempFeature.Fields.FindField(pField.Name);
                        for (int i = 0; i < pTargetFc.Fields.FieldCount; i++)
                        {
                            IField pTargetField = new FieldClass();
                            pTargetField = pTargetFc.Fields.get_Field(i);
                            if (pTargetField.Name == pField.Name && iIndex != -1)
                            {
                                if (pTargetField.Name == "OBJECTID" || pTargetField.Name == "SHAPE")
                                {
                                    continue;
                                }
                                tempFeature.set_Value(iIndex, pFeature.get_Value(j));
                            }
                        }
                    }
                    tempFeature.Store();
                }
                catch (System.Exception ex)
                {
                    ForeStar.CoreUI.Message.MessageManager.Show(ForeStar.CoreUI.Message.MessageType.Error, "要素写入异常！" + ex.Message, "提示");
                    return;
                }
                pFeature = pFeaCursor.NextFeature();
            }
            //目标工作空间停止编辑模式并保存编辑结果
            workSpaceEdit.StopEditing(true);
            workSpaceEdit.StopEditOperation();
        }
        #endregion

        #region 属性数据导入——征占——根据对应条件（XIANGMU_BH）补充pTargetFc中信息
        /// <summary>
        /// 征占——根据对应条件（XIANGMU_BH）补充pTargetFc中信息
        /// </summary>
        /// <param name="targetWorkspace">目标工作空间</param>
        /// <param name="pSourceAttributeTable">源ITable</param>
        /// <param name="pTargetFc">目标IFeatureClass</param>
        private static void mdb2fcOfAttributeTable_Zz(IWorkspace targetWorkspace, ITable pSourceAttributeTable, IFeatureClass pTargetFc)
        {
            try
            {
                IFeatureCursor pTargetFeatureCursor = pTargetFc.Search(null, false);

                //目标工作空间开启编辑模式
                IWorkspaceEdit workSpaceEdit = targetWorkspace as IWorkspaceEdit;
                workSpaceEdit.StartEditing(false);
                workSpaceEdit.StartEditOperation();

                int j = 0;
                IFeature pTargetFeatureRow = pTargetFeatureCursor.NextFeature();

                while (j < pTargetFc.FeatureCount(null))
                {
                    string strTargetFcProductID = pTargetFeatureRow.get_Value(1).ToString();
                    int i = 0;
                    ICursor pSourceFeatureCursor = pSourceAttributeTable.Search(null, false);
                    IRow pSourceTableRow = pSourceFeatureCursor.NextRow();
                    while (i < pSourceAttributeTable.RowCount(null))
                    {
                        //源数据该行ProductID
                        string strSourceAttributeTableProductID = pSourceTableRow.get_Value(0).ToString();
                        if (!string.IsNullOrEmpty(strTargetFcProductID) && strTargetFcProductID == strSourceAttributeTableProductID)
                        {
                            pTargetFeatureRow.set_Value(48, pSourceTableRow.get_Value(1));
                            pTargetFeatureRow.set_Value(49, pSourceTableRow.get_Value(2));
                            pTargetFeatureRow.set_Value(50, pSourceTableRow.get_Value(3));
                            pTargetFeatureRow.set_Value(51, pSourceTableRow.get_Value(4));
                            pTargetFeatureRow.set_Value(52, pSourceTableRow.get_Value(5));
                            pTargetFeatureRow.set_Value(53, pSourceTableRow.get_Value(6));
                            pTargetFeatureRow.set_Value(54, pSourceTableRow.get_Value(7));
                            pTargetFeatureRow.set_Value(55, pSourceTableRow.get_Value(8));
                            pTargetFeatureRow.set_Value(56, pSourceTableRow.get_Value(9));
                            pTargetFeatureRow.set_Value(57, pSourceTableRow.get_Value(10));
                            pTargetFeatureRow.set_Value(58, pSourceTableRow.get_Value(11));
                            pTargetFeatureRow.set_Value(59, pSourceTableRow.get_Value(12));
                            pTargetFeatureRow.set_Value(60, pSourceTableRow.get_Value(13));
                            pTargetFeatureRow.set_Value(61, pSourceTableRow.get_Value(14));
                            pTargetFeatureRow.set_Value(62, pSourceTableRow.get_Value(15));
                            pTargetFeatureRow.set_Value(63, pSourceTableRow.get_Value(16));
                            pTargetFeatureRow.set_Value(64, pSourceTableRow.get_Value(17));
                            pTargetFeatureRow.set_Value(65, pSourceTableRow.get_Value(18));
                            pTargetFeatureRow.set_Value(66, pSourceTableRow.get_Value(19));
                            pTargetFeatureRow.set_Value(67, pSourceTableRow.get_Value(20));
                            pTargetFeatureRow.set_Value(68, pSourceTableRow.get_Value(21));
                            pTargetFeatureRow.set_Value(69, pSourceTableRow.get_Value(22));
                            pTargetFeatureRow.set_Value(70, pSourceTableRow.get_Value(23));
                            pTargetFeatureRow.set_Value(71, pSourceTableRow.get_Value(24));
                            pTargetFeatureRow.set_Value(72, pSourceTableRow.get_Value(25));
                            pTargetFeatureRow.set_Value(73, pSourceTableRow.get_Value(26));
                            pTargetFeatureRow.set_Value(74, pSourceTableRow.get_Value(27));
                            pTargetFeatureRow.set_Value(75, pSourceTableRow.get_Value(28));
                            pTargetFeatureRow.set_Value(76, pSourceTableRow.get_Value(29));
                            pTargetFeatureRow.set_Value(77, pSourceTableRow.get_Value(30));
                            pTargetFeatureRow.set_Value(78, pSourceTableRow.get_Value(31));
                            pTargetFeatureRow.set_Value(79, pSourceTableRow.get_Value(32));
                            pTargetFeatureRow.set_Value(80, pSourceTableRow.get_Value(33));
                            pTargetFeatureRow.set_Value(81, pSourceTableRow.get_Value(34));
                            pTargetFeatureRow.set_Value(82, pSourceTableRow.get_Value(35));
                            pTargetFeatureRow.set_Value(83, pSourceTableRow.get_Value(36));
                            pTargetFeatureRow.set_Value(84, pSourceTableRow.get_Value(37));
                            pTargetFeatureRow.set_Value(85, pSourceTableRow.get_Value(38));
                            pTargetFeatureRow.set_Value(86, pSourceTableRow.get_Value(39));
                            pTargetFeatureRow.set_Value(87, pSourceTableRow.get_Value(40));
                            pTargetFeatureRow.set_Value(88, pSourceTableRow.get_Value(41));
                            pTargetFeatureRow.set_Value(89, pSourceTableRow.get_Value(42));
                            pTargetFeatureRow.set_Value(90, pSourceTableRow.get_Value(43));
                            pTargetFeatureRow.set_Value(91, pSourceTableRow.get_Value(44));
                            pTargetFeatureRow.Store();
                        }
                        pSourceTableRow = pSourceFeatureCursor.NextRow();
                        i++;
                    }
                    pTargetFeatureRow = pTargetFeatureCursor.NextFeature();
                    j++;
                }
                //目标工作空间停止编辑模式并保存编辑结果
                workSpaceEdit.StopEditing(true);
                workSpaceEdit.StopEditOperation();
            }
            catch (System.Exception ex)
            {
                ForeStar.CoreUI.Message.MessageManager.Show(ForeStar.CoreUI.Message.MessageType.Error, "要素写入异常！" + ex.Message, "提示");
                return;
            }
        } 
        #endregion

        #region 属性数据导入——采伐——根据对应条件（ProductID）补充pTargetFc中信息
        /// <summary>
        /// 采伐——根据对应条件（ProductID）补充pTargetFc中信息
        /// </summary>
        /// <param name="targetWorkspace">目标工作空间</param>
        /// <param name="pSourceAttributeTable">源ITable</param>
        /// <param name="pTargetFc">目标IFeatureClass</param>
        private static void mdb2fcOfAttributeTable_Cf(IWorkspace targetWorkspace, ITable pSourceAttributeTable, IFeatureClass pTargetFc)
        {
            try
            {
                IFeatureCursor pTargetFeatureCursor = pTargetFc.Search(null, false);

                //目标工作空间开启编辑模式
                IWorkspaceEdit workSpaceEdit = targetWorkspace as IWorkspaceEdit;
                workSpaceEdit.StartEditing(false);
                workSpaceEdit.StartEditOperation();

                int j = 0;
                IFeature pTargetFeatureRow = pTargetFeatureCursor.NextFeature();

                while (j < pTargetFc.FeatureCount(null))
                {
                    string strTargetFcProductID = pTargetFeatureRow.get_Value(1).ToString();
                    int i = 0;
                    ICursor pSourceFeatureCursor = pSourceAttributeTable.Search(null, false);
                    IRow pSourceTableRow = pSourceFeatureCursor.NextRow();
                    while (i < pSourceAttributeTable.RowCount(null))
                    {
                        //源数据该行ProductID
                        string strSourceAttributeTableProductID = pSourceTableRow.get_Value(0).ToString();
                        if (!string.IsNullOrEmpty(strTargetFcProductID) && strTargetFcProductID == strSourceAttributeTableProductID)
                        {
                            pTargetFeatureRow.set_Value(88, pSourceTableRow.get_Value(1));
                            pTargetFeatureRow.set_Value(89, pSourceTableRow.get_Value(2));
                            pTargetFeatureRow.set_Value(90, pSourceTableRow.get_Value(3));
                            pTargetFeatureRow.set_Value(91, pSourceTableRow.get_Value(4));
                            pTargetFeatureRow.set_Value(92, pSourceTableRow.get_Value(5));
                            pTargetFeatureRow.set_Value(93, pSourceTableRow.get_Value(6));
                            pTargetFeatureRow.set_Value(94, pSourceTableRow.get_Value(7));
                            pTargetFeatureRow.set_Value(95, pSourceTableRow.get_Value(8));
                            pTargetFeatureRow.set_Value(96, pSourceTableRow.get_Value(9));
                            pTargetFeatureRow.set_Value(97, pSourceTableRow.get_Value(10));
                            pTargetFeatureRow.set_Value(98, pSourceTableRow.get_Value(11));
                            pTargetFeatureRow.set_Value(99, pSourceTableRow.get_Value(12));
                            pTargetFeatureRow.set_Value(100, pSourceTableRow.get_Value(13));
                            pTargetFeatureRow.set_Value(101, pSourceTableRow.get_Value(14));
                            pTargetFeatureRow.set_Value(102, pSourceTableRow.get_Value(15));
                            pTargetFeatureRow.set_Value(103, pSourceTableRow.get_Value(16));
                            pTargetFeatureRow.set_Value(104, pSourceTableRow.get_Value(17));
                            pTargetFeatureRow.set_Value(105, pSourceTableRow.get_Value(18));
                            pTargetFeatureRow.set_Value(106, pSourceTableRow.get_Value(19));
                            pTargetFeatureRow.set_Value(107, pSourceTableRow.get_Value(20));
                            pTargetFeatureRow.set_Value(108, pSourceTableRow.get_Value(21));
                            pTargetFeatureRow.set_Value(109, pSourceTableRow.get_Value(22));
                            pTargetFeatureRow.set_Value(110, pSourceTableRow.get_Value(23));
                            pTargetFeatureRow.set_Value(111, pSourceTableRow.get_Value(24));
                            pTargetFeatureRow.set_Value(112, pSourceTableRow.get_Value(25));
                            pTargetFeatureRow.Store();
                        }
                        pSourceTableRow = pSourceFeatureCursor.NextRow();
                        i++;
                    }
                    pTargetFeatureRow = pTargetFeatureCursor.NextFeature();
                    j++;
                }
                //目标工作空间停止编辑模式并保存编辑结果
                workSpaceEdit.StopEditing(true);
                workSpaceEdit.StopEditOperation();
            }
            catch (System.Exception ex)
            {
                ForeStar.CoreUI.Message.MessageManager.Show(ForeStar.CoreUI.Message.MessageType.Error, "要素写入异常！" + ex.Message, "提示");
                return;
            }
        }
        #endregion

     





        #region 将mdb中的要素数据集转换到sde数据库中 （数据库根目录）
        /// <summary>
        /// 将mdb中的要素数据集转换到sde数据库中 （数据库根目录）
        /// </summary>
        /// <param name="lName"></param>
        /// <param name="inWorkspace"></param>
        /// <param name="outWorkspace"></param>
        /// <returns></returns>
        public static bool impLayerByName(ESRI.ArcGIS.esriSystem.IName lName, ESRI.ArcGIS.Geodatabase.IWorkspace inWorkspace,
          ESRI.ArcGIS.Geodatabase.IWorkspace outWorkspace)
        {
            try
            {
                //输入要素         
                ESRI.ArcGIS.Geodatabase.IFeatureClass inFeatureClass = (ESRI.ArcGIS.Geodatabase.IFeatureClass)lName.Open();
                ESRI.ArcGIS.Geodatabase.IFeatureClassName inFeatureClassName = (ESRI.ArcGIS.Geodatabase.IFeatureClassName)lName;
                // 输出要素
                ESRI.ArcGIS.Geodatabase.IFeatureClassName outFeatureClassName = new ESRI.ArcGIS.Geodatabase.FeatureClassNameClass();
                ESRI.ArcGIS.Geodatabase.IDatasetName outDatasetName = (ESRI.ArcGIS.Geodatabase.IDatasetName)outFeatureClassName;
                ESRI.ArcGIS.Geodatabase.IDataset outWorkspaceDataset = (ESRI.ArcGIS.Geodatabase.IDataset)outWorkspace;
                ESRI.ArcGIS.Geodatabase.IWorkspaceName outWorkspaceName = (ESRI.ArcGIS.Geodatabase.IWorkspaceName)outWorkspaceDataset.FullName;
                outDatasetName.WorkspaceName = outWorkspaceName;
                //string outFullName = ((IDatasetName)lName).Name;
                //string outFileName = outFullName.Substring(outFullName.LastIndexOf(".") + 1);
                //outDatasetName.Name = "SDE." + ((ESRI.ArcGIS.Geodatabase.IDatasetName)lName).Name;
                outDatasetName.Name = "XYLYZY." + ((ESRI.ArcGIS.Geodatabase.IDatasetName)lName).Name;
                //验证字段
                ESRI.ArcGIS.Geodatabase.IFieldChecker fieldChecker = new ESRI.ArcGIS.Geodatabase.FieldCheckerClass();
                ESRI.ArcGIS.Geodatabase.IFields outFeatureClassFields;
                ESRI.ArcGIS.Geodatabase.IFields inFeatureClassFields = inFeatureClass.Fields;
                ESRI.ArcGIS.Geodatabase.IEnumFieldError enumFieldError;
                fieldChecker.InputWorkspace = inWorkspace;
                fieldChecker.ValidateWorkspace = outWorkspace;

                fieldChecker.Validate(inFeatureClassFields, out enumFieldError, out outFeatureClassFields);
                // Set up the geometry definition.
                ESRI.ArcGIS.Geodatabase.IField geometryField;
                geometryField = outFeatureClassFields.get_Field(outFeatureClassFields.FindField(inFeatureClass.ShapeFieldName));
                // Get the geometry field's geometry definition.
                ESRI.ArcGIS.Geodatabase.IGeometryDef geometryDef = geometryField.GeometryDef;

                ESRI.ArcGIS.Geodatabase.QueryFilter qf = new ESRI.ArcGIS.Geodatabase.QueryFilterClass();
                qf.WhereClause = "";

                ESRI.ArcGIS.Geodatabase.IFeatureDataConverter fctofc = new ESRI.ArcGIS.Geodatabase.FeatureDataConverterClass();
                ESRI.ArcGIS.Geodatabase.IEnumInvalidObject enumErrors = fctofc.ConvertFeatureClass(inFeatureClassName, qf, null, outFeatureClassName, geometryDef, outFeatureClassFields, "", 1000, 0);
                return true;
            }
            catch (Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
                return false;
            }
        }
        #endregion

        #region 将mdb中的要素数据集转换到sde数据库中  ConvertFeatureDataset
        /// <summary>  
        /// 将mdb中的要素数据集转换到sde数据库中  
        /// </summary>  
        /// <param name="sourceWorkspace"></param>  
        /// <param name="targetWorkspace"></param>  
        /// <param name="nameOfSourceFeatureDataset"></param>  
        /// <param name="nameOfTargetFeatureDataset"></param>  
        public static void ConvertMDBFeatureDatasetToSDE(IWorkspace sourceWorkspace, IWorkspace targetWorkspace,
            string nameOfSourceFeatureDataset, string nameOfTargetFeatureDataset)
        {
            if (sourceWorkspace == null || targetWorkspace == null)
            {
                return;
            }
            //创建源工作空间名        
            IDataset sourceWorkspaceDataset = (IDataset)sourceWorkspace;
            IWorkspaceName sourceWorkspaceName = (IWorkspaceName)sourceWorkspaceDataset.FullName;
            //创建源数据集名  
            IFeatureDatasetName sourceFeatureDatasetName = new FeatureDatasetNameClass();
            IDatasetName sourceDatasetName = (IDatasetName)sourceFeatureDatasetName;
            sourceDatasetName.WorkspaceName = sourceWorkspaceName;
            sourceDatasetName.Name = nameOfSourceFeatureDataset;
            //创建目标工作空间名  
            IDataset targetWorkspaceDataset = (IDataset)targetWorkspace;
            IWorkspaceName targetWorkspaceName = (IWorkspaceName)targetWorkspaceDataset.FullName;
            //创建目标数据集名  
            IFeatureDatasetName targetFeatureDatasetName = new FeatureDatasetNameClass();
            IDatasetName targetDatasetName = (IDatasetName)targetFeatureDatasetName;
            targetDatasetName.WorkspaceName = targetWorkspaceName;
            targetDatasetName.Name = nameOfTargetFeatureDataset;
            //转换（复制）源数据集到目标数据集  
            IFeatureDataConverter featureDataConverter = new FeatureDataConverter();
            featureDataConverter.ConvertFeatureDataset(sourceFeatureDatasetName, targetFeatureDatasetName, null, "", 1000, 0);

        } 
        #endregion

        #region  将mdb中的要素数据集转换到sde数据库中 （数据集中）
        /// <summary>
        /// 将mdb中的要素数据集转换到sde数据库中 （数据集中）
        /// </summary>
        /// <param name="lName"></param>
        /// <param name="inWorkspace"></param>
        /// <param name="featureDataset"></param>
        /// <returns></returns>
        public static bool impLayerByNameIntoDataset(ESRI.ArcGIS.esriSystem.IName lName, IWorkspace inWorkspace, IFeatureDataset featureDataset)
        {
            try
            {
                //IFeatureClassDescription fcDesc = new FeatureClassDescriptionClass();
                //IObjectClassDescription ocDesc = (IObjectClassDescription)fcDesc;
                //Open input Featureclass to get field definitions.            
                IFeatureClass inFeatureClass = (IFeatureClass)lName.Open();
                IFeatureClassName inFeatureClassName = (IFeatureClassName)lName;
                // Set out dataset and feature class names.
                IFeatureClassName outFeatureClassName = new FeatureClassNameClass();
                IDatasetName outDatasetName = (IDatasetName)outFeatureClassName;
                IDataset outWorkspaceDataset = (IDataset)featureDataset.Workspace;
                IWorkspaceName outWorkspaceName = (IWorkspaceName)outWorkspaceDataset.FullName;
                outDatasetName.WorkspaceName = outWorkspaceName;
                outDatasetName.Name = "SDE." + ((IDatasetName)lName).Name;
                //Validate the field names.
                IFieldChecker fieldChecker = new FieldCheckerClass();
                IFields outFeatureClassFields;
                IFields inFeatureClassFields = inFeatureClass.Fields;
                IEnumFieldError enumFieldError;
                fieldChecker.InputWorkspace = inWorkspace;
                fieldChecker.ValidateWorkspace = featureDataset.Workspace;

                // Validate the fields.
                fieldChecker.Validate(inFeatureClassFields, out enumFieldError, out outFeatureClassFields);
                //featureDataset.CreateFeatureClass("SDE." + ((IDatasetName)lName).Name,outFeatureClassFields,ocDesc.InstanceCLSID,ocDesc.ClassExtensionCLSID,esriFeatureType.esriFTSimple,fcDesc.ShapeFieldName,"");
                // Set up the geometry definition.
                IField geometryField;
                geometryField = outFeatureClassFields.get_Field(outFeatureClassFields.FindField(inFeatureClass.ShapeFieldName));
                // Get the geometry field's geometry definition.
                IGeometryDef geometryDef = geometryField.GeometryDef;
                //Set up the IQueryFilter to convert all the features by leaving a blank WhereClause
                IQueryFilter qf = new QueryFilterClass();
                qf.WhereClause = "";
                //Load the feature class
                IFeatureDataConverter fctofc = new FeatureDataConverterClass();
                IEnumInvalidObject enumErrors = fctofc.ConvertFeatureClass(inFeatureClassName, qf, (IFeatureDatasetName)featureDataset.FullName, outFeatureClassName, geometryDef, outFeatureClassFields, "", 1000, 0);

                return true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }

        } 
        #endregion

    }

kone666
关注
【Python001】python批量下载、插入与读取Oracle中图片数据（已更新）
kngines
05-21 942
1.熟悉、梳理、总结数据分析实战中的`python、oracle`研发知识体系 2.欢迎点赞、关注、批评、指正，互三走起来，小手动起来！
用plsql将mdb文件导入到oracle数据库中
12-26
用plsql将mdb文件导入到oracle数据库中
DataConvertor
Blue Dream
05-24 84
/* * 转换表数据 */ public void convertTables() throws Exception { DBtoDB dbToDb = null; DataFilter filter = null; if (this.originDB.getDbType().equalsIgnoreCase("oracle") && this.targ...
DataConverter
01-16
此工具是十年工作经验的嵌入式工程师，工程经验总结而设计。 （重要提醒，下载后，请点击更新，把软件更新的最新版本）。 特点有： 1.功能强大，支持String To Hex/Hex To String, ANSI 和 Unicode UTF8/UTF16. 2.支持C/C++ 数组，加0x，去0x，加空格，去空格，对齐等操作。 3.支持主流算法 DES、AES、SM2、SM3、SM4 、ECDSA 等算法。 4.支持 各种MAC算法，填充方式等 5.支持Base64 加解密操作。 6.支持URL ANSI/UTF8/UTF16 转换。 7.支持x.509 RSA 标准格式的PEM/DER 解析，拖入即解析。 8.bin文件导入，提取，转换，数据结果也可以保存成bin文件。 8.任意长度的大小端数据转换。 https://blog.csdn.net/yinggegege/article/details/87895893
dataconvert
08-09
AscToBcd，AscToBin， BcdToBin，BinToAsc
DataConvert:数据转换
06-20
描述 从 Excel 中获取 CSV 或制表符分隔的数据，并将其转换为多种 Web 友好格式，包括 JSON 和 XML。 在此处查看操作： :
access数据库MDB数据文件导入oracle数据库操作步骤.pdf
10-11
将 Access 数据库 MDB 文件导入 Oracle 数据库可以实现数据的迁移和整合。以下是将 Access 数据库 MDB 文件导入 Oracle 数据库的操作步骤： Step 1: 打开 PL/SQL 工具 要将 Access 数据库 MDB 文件导入 Oracle ...
FeatureClassLoad_导入数据到mdb_C#arcengine数据映射导入_worriedkk8_MDB-478_字
10-03
本话题聚焦于如何使用C#和ArcEngine来实现从shapefile到mdb的高效、安全的数据导入，并进行字段映射。以下是对这一主题的详细阐述： 1. **数据导入**： - Shapefile是一种常见的矢量地理数据格式，包含几何、属性...
asp实现批量插入表单中的数据到数据库的方法
10-30
本文将详细介绍如何利用ASP技术实现从表单批量插入数据到数据库的过程。这种方法在处理大量用户输入数据时非常有用，尤其是在需要快速高效地将多条记录一次性存入数据库的情况下。 #### 一、准备工作 在开始编写...
DataConverter 工具介绍
02-23 5984
Dataconverter 是一款强大的数据处理和算法工具 - 满足C、Java ，Python程序员的编程中常见的数据处理需求，有效提升Coding效率。 - 基于可靠算法套件，支持金融，网络安全，信息安全等常见密码学算法，特别支持中国国密算法SM2，SM3，SM4. - 精心调整过界面布局，支持多种主题和字体，支持多种分辨率显示，视觉体验佳。 ----- Dataconvert...
Oracle建库及导入mdb
11-28
经过整理及实践，按此步骤执行即可成功构建数据库。如有不足或待完美之处，请留言。
本地数据库转换为SDE数据库
01-21
使用Python编写的将本地数据库导入为SDE数据库，目的是用作SDE数据库的还原。可参考：http://blog.csdn.net/wl05031/article/details/18603667
mdb 导入 oracle,AE将mdb空间数据导入SDE
weixin_32558567的博客
04-04 324
基于AE的个人地理数据库(mdb格式)导入到企业级数据库(sde数据库中，采用Oracle数据库)中(C#).个人地理数据库有数据集，导入到企业级数据库后没有数据集，只有要素类。privatevoid btnPGD2EGD_Click(object sender, EventArgse){try{string pWorkspaceName =strName;string sdeUser =pSDE...
convert_data
yongquanfengjie的博客
06-18 684
# -- encoding:utf-8 -- import os import tensorflow as tf from utils.data_utils import convert_sentence_to_words from utils.data_utils import build_dictionary from utils.data_utils import convert_words_to_record tf.app.flags.DEFINE_string("opt", "split",
oracle导入mdb文件
java coder https://github.com/pmsyn/ https://gitee.com/pmsyn
01-14 1839
1、新建odbc数据源：控制面板\所有控制面板项\Windows 工具-ODBC数据源 注意数据源版本和操作系统的版本要一致 2、plsql:tools-odbc importer-user/system dsn填入新建ODBC数据源名称 3、新建表结构点击上方create table 注意： plsql连接不上时注意检查odbc数据源版本是否和操作系统版本一致 如果添加数据源中无对应数据源类型则需要安装相应驱动 如：acess引擎 ......
数据管理_MDB空间数据库再探
wujianyouhun的专栏
04-07 1787
在百度中输入 ArcGIS Access，发现其中有一条记录为“Arcgis地图杭州 Access数据库 - 下载频道 - CSDN.NET” 点开下载数据（其中经历了如何让如何的痛苦，如何如的困难都以略过），小宝喜欢收集数据，目前手头有大量的数据，但是这部分数据并没有公开，原因怕会不会涉及泄密。 下载杭州数据MDB文件
DataConvertJson
weixin_30596023的博客
01-22 124
public class DataConvertJson { #region dataTable转换成Json格式 /// <summary> /// dataTable转换成Json格式 /// </summary> /// <para...
DataConvert-scenjoy
fallingcarter的博客
12-04 219
DataConverter ConverterFactory --> DefaultConverterFactory DataConverterHelper
SuperMap Deskpro教程：导入MDB和DBF属性表数据及空间数据操作详解
特别提到了Access的mdb格式和FoxPro的dbf格式的属性表数据，这些都是GIS项目中常见的数据源。 栅格数据方面，教程指导用户如何直接导入常见格式的图像文件，如.bmp、jpg、tif等，以及处理压缩影像数据，如ECW和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值