Mike,


>When I run the following code against a table with a primary key that is an identity column in SQL Server, I get the error "Column 'pri_key' is Read Only"

>DataSet DS = oMyBizObj.GetByID(1);
>
>// Add a DataRow to a table.
>DataRow myRow = DS.Tables["MyTable"].NewRow();
>myRow["MyColumn1"] = 1;
>myRow["MyColumn2"] = "ABC";
>
>// Add the row.
>DS.Tables["MyTable"].Rows.Add( myRow );
>DS.AcceptChanges();
>
>oMyBizObj.UpdateFromDataSet(DS);

Even though you are not programmatically setting the value of the primary key, is it bound to a user interface control? If so, you should set the control to ReadOnly.

Regards,