I have a SQL GeoDB in my server. I want to write some data in one of feature dataset and for that i use below method.
public string insertdata(string tablename, List fields, string primerykey) { IEnumDataset datasets = ws.get_Datasets(esriDatasetType.esriDTAny); IDataset dataset = null; ITable table = null; IFeatureWorkspace fws = ws as IFeatureWorkspace; IFeatureDataset fdataset = fws.OpenFeatureDataset("Electrical"); datasets = fdataset.Subsets; do { dataset = datasets.Next(); table = dataset as ITable; if (dataset == null) return "Table not exist"; } while (dataset.Name != tablename); IWorkspaceEdit ews = ws as IWorkspaceEdit; ews.StartEditing(false); ews.StartEditOperation(); IRow row = null; table.Fields.FindField(primerykey); string value = "123"; } } ICursor cursor = null; IQueryFilter2 queryFilter = new QueryFilterClass(); queryFilter.WhereClause = primerykey + "='" + value + "'"; cursor = table.Search(queryFilter, false); row = cursor.NextRow(); foreach (tableRow field in fields) { Type type = field.type; int ind = row.Fields.FindField(field.name); if (ind == -1) return "Field not exist"; row.Value[ind] = Convert.ChangeType(field.value, type); } row.Store(); ews.StopEditOperation(); ews.StopEditing(true); return "Row inserted succesfull"; } This method worked on all dataset but in one of them an error returned that say :"Objects in this class cannot be updated outside an edit session"
أكثر...
public string insertdata(string tablename, List fields, string primerykey) { IEnumDataset datasets = ws.get_Datasets(esriDatasetType.esriDTAny); IDataset dataset = null; ITable table = null; IFeatureWorkspace fws = ws as IFeatureWorkspace; IFeatureDataset fdataset = fws.OpenFeatureDataset("Electrical"); datasets = fdataset.Subsets; do { dataset = datasets.Next(); table = dataset as ITable; if (dataset == null) return "Table not exist"; } while (dataset.Name != tablename); IWorkspaceEdit ews = ws as IWorkspaceEdit; ews.StartEditing(false); ews.StartEditOperation(); IRow row = null; table.Fields.FindField(primerykey); string value = "123"; } } ICursor cursor = null; IQueryFilter2 queryFilter = new QueryFilterClass(); queryFilter.WhereClause = primerykey + "='" + value + "'"; cursor = table.Search(queryFilter, false); row = cursor.NextRow(); foreach (tableRow field in fields) { Type type = field.type; int ind = row.Fields.FindField(field.name); if (ind == -1) return "Field not exist"; row.Value[ind] = Convert.ChangeType(field.value, type); } row.Store(); ews.StopEditOperation(); ews.StopEditing(true); return "Row inserted succesfull"; } This method worked on all dataset but in one of them an error returned that say :"Objects in this class cannot be updated outside an edit session"
أكثر...