i am facing a problem while updating a particular row in datatable by using loaddatarow.

i am giving the structure of the datatable

      DataTable temp= new DataTable();
      DataColumn pkCol = temp.Columns.Add("PCOD", typeof(String));
      temp.Columns.Add("PDES", typeof(String));
      temp.PrimaryKey = new DataColumn[] {pkCol};
      for( int i=0;i<5;i++)
       {
        DataRow myrow;
    myrow = temp.NewRow();
    myrow["PCOD"] = i
    myrow["PDES"] = "";
    temp.Rows.Add(myrow);
//now i am updating this datatable with loaddatarow for a test
        object[] newRow = new object[2];
        newRow[0] = i;
        newRow[1] = "abcgd"
        DataRow myRow;
        temp.BeginLoadData();
        myRow = temp.LoadDataRow(newRow, false);
        temp.EndLoadData();

       }

it is giving me an error on the line "temp.endloaddata",
"Unable to enable the constraint"
the only constraint here is primary key. i am unable to figure out why the method is unable to update the row.
any pointers to this will be of great help.

Note:--i tried even changing the 2nd parameter to "true " but of no use


regards
rahul pokharna

__________________
regards
rahul pokharna

A new row is created and each column in the new row is filled with "System.Data.Row" for each row in the array your adding to the table.

I believe this is a bug. I have not found a way to fix it, if you add more rows in the array than you have columns in the table.

Debug the "enddataload" line and look at your table. You will see the error row at the bottom of the table. So, if you try to call this more than once and you have a unique column, you get your error above.

It's interesting that it says it can't *ENABLE* the constraint.

Do you suppose that's only because the type of the column is string but the data you are trying to use is an integer???

Did you try simply changing
   DataColumn pkCol = temp.Columns.Add("PCOD", typeof(String));
to
   DataColumn pkCol = temp.Columns.Add("PCOD", typeof(Integer));
???

Or try using a string for the column value instead of just an int??

SHAME ON ME!!!

Sheesh, I made the foolish mistake of replying to a post made more than TWO YEARS AGO just because somebody else had (also foolishly) replied!

Sorry, folks!!