topic Re: Change attribute table values of shape file. in ArcObjects SDK Questions

Change attribute table values of shape file.

AysberqTundra — Fri, 29 Apr 2011 04:48:05 GMT

Hello everyone!
I want to change attribute table values of shape file using C#.
I tried with code below. The code works, but values are not change.

            IWorkspaceFactory workspaceFactory = new ShapefileWorkspaceFactoryClass();
            IWorkspace wrksp = workspaceFactory.OpenFromFile(@"D:\Shape\", 0);
            IFeatureWorkspace pFeatWorkspace = wrksp as IFeatureWorkspace;
            ITable myTable = pFeatWorkspace.OpenTable("Shape1");
            IWorkspaceEdit wrkspcedit = pFeatWorkspace as IWorkspaceEdit;
            if (wrkspcedit.IsBeingEdited())
            {
                wrkspcedit.StartEditing(false);
                wrkspcedit.StartEditOperation();
            }
            myTable.GetRow(5).set_Value(8,"anyvalue");
            wrkspcedit.StopEditOperation();
            wrkspcedit.StopEditing(true);

Can someone help me?
Thanks!

Re: Change attribute table values of shape file.

Anonymous User — Sun, 01 May 2011 19:42:25 GMT

It looks like you are not starting the edit session. Your conditional only executes if the workspace is being edited...

Re: Change attribute table values of shape file.

AysberqTundra — Mon, 02 May 2011 04:20:05 GMT

Thanks for your reply.
I tried the code without if(). But, the attribute table value did not change.
I have 2 shapes in directory "D:\Shape\" . Shape1 and Shape2.
I need change values of Shape1.
IWorkspaceEdit wrkspcedit = pFeatWorkspace as IWorkspaceEdit;
But here wrkspcedit don't show Shape1.
I tried the code below, but have an error.(NullReferenceException was unhandled)

WorkspaceEdit wrkspcedit = myTable as IWorkspaceEdit;
wrkspcedit.StartEditing(false); // NullReferenceException was unhandled
wrkspcedit.StartEditOperation();
myTable.GetRow(5).set_Value(8,"anyvalue");
wrkspcedit.StopEditOperation();
wrkspcedit.StopEditing(true);

What can I do?

Re: Change attribute table values of shape file.

SimonOlsberg — Wed, 20 Jun 2012 17:55:58 GMT

I am experiencing the same problem with shapefiles - if I try to update any attribute values inside an edit session then the changes seem not to be persisted.
The same code works fine if the feature class/table is in a file geodatabase.
And if I make the update to the shapefile directly without enclosing it in an IWorkspaceEdit Start/Stop session then it also seems to work OK.

SO should we not use IWorkspaceEdit with shapefiles?

Re: Change attribute table values of shape file.

EzequiasRodrigues_da_Rocha — Thu, 26 Sep 2013 18:26:44 GMT

Any other suggestion for shapefiles?

Maybe any SP?

Sincerely
Ezequias Rocha

Re: Change attribute table values of shape file.

sameerpuppal — Fri, 27 Sep 2013 09:31:23 GMT

Hi,

I have suggestions 🙂 !

try doing this one by one.

1. For shapefile first try without doing startediting and stopediting.
2. trying using same code without starteditoperation and stopeditoperation coz this is used for SDE.
3. try using IEditor instead of workspaceedit.
4. trying using Ifeatureclass.search instead of update.

something outta this should work!

Regards,
Sameer

Re: Change attribute table values of shape file.

sameerpuppal — Fri, 27 Sep 2013 09:36:39 GMT

Thanks for your reply.
I tried the code without if(). But, the attribute table value did not change.
I have 2 shapes in directory "D:\Shape\" . Shape1 and Shape2.
I need change values of Shape1.
IWorkspaceEdit wrkspcedit = pFeatWorkspace as IWorkspaceEdit;
But here wrkspcedit don't show Shape1.
I tried the code below, but have an error.(NullReferenceException was unhandled)

WorkspaceEdit wrkspcedit = myTable as IWorkspaceEdit;
wrkspcedit.StartEditing(false); // NullReferenceException was unhandled
wrkspcedit.StartEditOperation();
myTable.GetRow(5).set_Value(8,"anyvalue");
wrkspcedit.StopEditOperation();
wrkspcedit.StopEditing(true);

What can I do?

Hi,

Found out!
Please read this
http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#//00250000089m000000

you havent called store() on to this row to commit changes to the shapefile.

do it this way replace myTable.GetRow(5).set_Value(8,"anyvalue"); with

IRow pRow = myTable.GetRow(5);
pRow.set_Value(8,"anyvalue");
pRow.store();

and this will work!

Regards,
Sameer Puppal

Re: Change attribute table values of shape file.

EzequiasRodrigues_da_Rocha — Fri, 27 Sep 2013 10:46:00 GMT

Hi,

I have suggestions 🙂 !

try doing this one by one.

1. For shapefile first try without doing startediting and stopediting.
2. trying using same code without starteditoperation and stopeditoperation coz this is used for SDE.
3. try using IEditor instead of workspaceedit.
4. trying using Ifeatureclass.search instead of update.

something outta this should work!

Regards,
Sameer

Sammer

I am trying to make an insert. I am outside the ArcMap environment and this alternatives where tryed,but 3 and 4 (thanks). I also tryed a RowBuffer. Just in case. I am trying to update a dbf file, not a shapefile.

Any other suggestion? What such strange error message.

Regards
Ezequias

Re: Change attribute table values of shape file.

EzequiasRodrigues_da_Rocha — Fri, 27 Sep 2013 11:28:00 GMT

Sammer

I am trying to make an insert. I am outside the ArcMap environment and this alternatives where tryed,but 3 and 4 (thanks). I also tryed a RowBuffer. Just in case. I am trying to update a dbf file, not a shapefile.

Any other suggestion? What such strange error message.

Regards
Ezequias

I found the problem. I simply set the "value" of set_value method to a variable and BINGO.

Quite strange. I think it is a bug.

Regards
Ezequias