Hi Conrad,

     Sorry, but I am not able to repro your issue. I have tried to create a WebGrid using your setting and Northwind SQL database, and the update row works just fine. Here, I attached you my sample file. There might be a workaround for this, but I am not quite sure if it is working or not since I can not repro your issue. Try to add the RootTable DataKeyFiled within your WebGrid. Here the snippet:

<RootTable DataKeyField="HARDWARE_SCHED_CODE" ColumnHeaders="Yes" AllowEdit="Yes" AllowDelete="Yes">

      I hope it helps and let me know if it solves your issue. Thank you.

Best Regards,

Andi Santoso

Andi,

I added the DataKeyField to the RootTable element and it caused problems with the Insert and I still get the same message on Update.  Oracle is the database I'm updating.  Will that make a difference?

Also, I couldn't find the attachment.

Thanks,

Conrad

Hi Conrad,

     Sorry, but I must be forgot to attach the file, apologize for that. In my sample, everything works just fine and I added the DataKeyField to the RootTable element as well. However, it cause no problem at all. 

     I believe that our WebGrid supports Oracle database as well, so it will not make any different. Thank you.

Best Regards,

Andi Santoso

Hi Andi,

In reference to the code above, in the WebGrid1_UpdateRow code, I'm trying to reference the second column in the grid.  I can reference the first with the code:

 e.Rows.Cells(0).value

however when I try to reference the second column with:

 e.Rows.Cells(1).Value

I get the dreaded object reference error message.

What am I doing wrong?

Thanks,

Conrad

Hi Conrad,

     The code that you have provided is almost correct, however, you are missing a little thing. Here is the snippet to reference the n-index column in the grid. In here, I am going to display it on TextBox that is why I have to convert the value into a string by .ToString().

              TextBox1.Text = e.Row.Cells[1].Value.ToString();

      I hope it helps and please, do not heistate to ask if you have any other questions. Thank you.

Best Regards,

Andi Santoso