Import layers to SDE

There are two ways to import layers to SDE: one is to directly import them to the root directory of SDE, and the other is to create a dataset in SDE ), then, import data to a specific element set.

 

First case: directly import layers to the SDE root directory:

Bool implayerbyname (INAME lname, iworkspace inworkspace, iworkspace outworkspace) <br/>{< br/> try <br/> {<br/> // open input featureclass to get field definitions. <br/> ifeatureclass infeatureclass = (ifeatureclass) lname. open (); <br/> ifeatureclassname infeatureclassname = (ifeatureclassname) lname; <br/> // set out dataset and feature class names. <br/> response outfeatureclassname = new response (); <br/> idatasetname outdatasetname = (idatasetname) outfeatureclassname; <br/> idataset outworkspacedataset = (idataset) outworkspace; <br/> iworkspacename outworkspacename = (iworkspacename) outworkspacedataset. fullname; <br/> outdatasetname. workspacename = outworkspacename; <br/> // string outfullname = (idatasetname) lname ). name; <br/> // string outfilename = outfullname. substring (outfullname. lastindexof (". ") + 1); <br/> outdatasetname. name = "SDE. "+ (idatasetname) lname ). name; <br/> // validate the field names. <br/> ifieldchecker fieldchecker = new fieldcheckerclass (); <br/> ifields outfeatureclassfields; <br/> ifields infeatureclassfields = infeatureclass. fields; <br/> ienumfielderror enumfielderror; <br/> fieldchecker. inputworkspace = inworkspace; <br/> fieldchecker. validateworkspace = outworkspace; <br/> // validate the fields. <br/> fieldchecker. validate (infeatureclassfields, out enumfielderror, out outfeatureclassfields); <br/> // set up the geometry definition. <br/> ifield geometryfield; <br/> geometryfield = outfeatureclassfields. get_field (outfeatureclassfields. findfield (infeatureclass. shapefieldname); <br/> // get the geometry field's geometry definition. <br/> igeometrydef geometrydef = geometryfield. geometrydef; <br/> // set up the iqueryfilter to convert all the features by leaving a blank whereclause <br/> queryfilter QF = new queryfilterclass (); <br/> QF. whereclause = ""; <br/> // load the feature class <br/> ifeaturedataconverter fctofc = new featuredataconverterclass (); <br/> ienuminvalidobject enumerrors = fctofc. convertfeatureclass (infeatureclassname, QF, null, outfeatureclassname, geometrydef, outfeatureclassfields, "", 1000,0); <br/> return true; <br/>}< br/> catch (exception ex) <br/>{< br/> MessageBox. show (ex. message); <br/> return false; <br/>}< br/>

Here, lname is the iname of the source layer, inworkspace is the workspace of the source layer, and outworkspace is the workspace to export, by default, the exported layer is named the same as the source layer.

 

 

Case 2: Import layers to a feature set in SDE

Bool implayerbynameincludataset (INAME lname, iworkspace inworkspace, ifeaturedataset featuredataset) <br/>{< br/> try <br/> {<br/> // ifeatureclassdescription fcdesc = new featureclassdescriptionclass (); <br/> // iobjectclassdescription ocdesc = (iobjectclassdescription) fcdesc; <br/> // open input featureclass to get field definitions. <br/> ifeatureclass infeatureclass = (ifeatureclass) lname. open (); <br/> ifeatureclassname infeatureclassname = (ifeatureclassname) lname; <br/> // set out dataset and feature class names. <br/> response outfeatureclassname = new response (); <br/> idatasetname outdatasetname = (idatasetname) outfeatureclassname; <br/> idataset outworkspacedataset = (idataset) featuredataset. workspace; <br/> iworkspacename outworkspacename = (iworkspacename) outworkspacedataset. fullname; <br/> outdatasetname. workspacename = outworkspacename; <br/> outdatasetname. name = "SDE. "+ (idatasetname) lname ). name; <br/> // validate the field names. <br/> ifieldchecker fieldchecker = new fieldcheckerclass (); <br/> ifields outfeatureclassfields; <br/> ifields infeatureclassfields = infeatureclass. fields; <br/> ienumfielderror enumfielderror; <br/> fieldchecker. inputworkspace = inworkspace; <br/> fieldchecker. validateworkspace = featuredataset. workspace; </P> <p> // validate the fields. <br/> fieldchecker. validate (infeatureclassfields, out enumfielderror, out outfeatureclassfields); <br/> // featuredataset. createfeatureclass ("SDE. "+ (idatasetname) lname ). name, outfeatureclassfields, ocdesc. instanceclsid, ocdesc. classextensionclsid, esrifeaturetype. esriftsimple, fcdesc. shapefieldname, ""); <br/> // set up the geometry definition. <br/> ifield geometryfield; <br/> geometryfield = outfeatureclassfields. get_field (outfeatureclassfields. findfield (infeatureclass. shapefieldname); <br/> // get the geometry field's geometry definition. <br/> igeometrydef geometrydef = geometryfield. geometrydef; <br/> // set up the iqueryfilter to convert all the features by leaving a blank whereclause <br/> iqueryfilter QF = new queryfilterclass (); <br/> QF. whereclause = ""; <br/> // load the feature class <br/> ifeaturedataconverter fctofc = new featuredataconverterclass (); <br/> ienuminvalidobject enumerrors = fctofc. convertfeatureclass (infeatureclassname, QF, (ifeaturedatasetname) featuredataset. fullname, outfeatureclassname, geometrydef, outfeatureclassfields, "", 1000,0); </P> <p> return true; <br/>}< br/> catch (exception ex) <br/>{< br/> MessageBox. show (ex. message); <br/> return false; <br/>}</P> <p >}< br/>

Here, lname is the iname of the source layer, inworkspace is the workspace of the source layer, and featuredataset is the target dataset. By default, this code name the exported layer as the source layer.

 

Appendix: how to obtain a dataset (Dataset) in SDE:

// Search for dataset named datasetname in SDE <br/> ifeaturedataset outset = NULL; <br/> ienumdatasetname idnames = outspace. get_datasetnames (esridatasettype. esridtfeaturedataset); <br/> idatasetname idnames. reset (); <br/> fnamebase = idnames. next (); <br/> while (fnamebase! = NULL) <br/>{< br/> If (fnamebase. name = datasetname) outset = (ifeaturedataset) (INAME) fnamebase ). open (); <br/> fnamebase = idnames. next (); <br/>}

Outspace is an opened SDE workspace.