1.Join到SQL中的表

IFeatureLayerpFeatureLayer=axMapControl1.Map.get_Layer(0)asIFeatureLayer; IFeatureClasspFeatureClass=pFeatureLayer.FeatureClass; IWorkspaceFactorypWsFact; IWorkspacepWorkspace; pWsFact=newOLEDBWorkspaceFactoryClass(); IPropertySetpPropertySet=newPropertySetClass(); pPropertySet.SetProperty("CONNECTSTRING","Provider=SQLOLEDB;server=.;database=test;UserId=sa;Password=123"); pWorkspace=pWsFact.Open(pPropertySet,0); IFeatureWorkspacepFeatWS=(IFeatureWorkspace)pWorkspace; ITablepOleTable=pFeatWS.OpenTable(inTable); IMemoryRelationshipClassFactorypMemRelFact=newMemoryRelationshipClassFactoryClass(); IRelationshipClasspRelClass=pMemRelFact.Open("",pFeatureClass,"村",(IObjectClass)pOleTable,"cunWei","forward","backward",esriRelCardinality.esriRelCardinalityOneToOne); IDisplayRelationshipClasspDispRC=pFeatureLayerasIDisplayRelationshipClass; pDispRC.DisplayRelationshipClass(pRelClass,esriJoinType.esriLeftOuterJoin);