Hi Jocelyn,

    I am having a problem to replicate your issue. From what I see on you error attachment, probably, you had inputted an incorrect data type. Please ensure that the data type in storage is the same with what you had inputted. 

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

Best Regards,

Andi Santoso

I actually don't input anything for this value.  It is a DataKeyField on the WebGrid.  After I do the Insert with the Stored Procedure do need to set this value in the code behind? 

Hi Jocelyn,

     Thank you for adding more detail information and I understand now. Are you saying that you want to leave blank on "RecipNo" and it will have an auto-increment for it? Correct me if I wrong. However, if that is you scenario, after we use WebGrid_BatchUpdate on serverside, it should be automatically give us an auto-increment for DataKeyField. For more details, you can see our docs at ms-help://ISNet.WebUI.WebGrid.V7/ISNet.WebUI.WebGrid/Streamlined Editing Process.html and ms-help://ISNet.WebUI.WebGrid.V7/ISNet.WebUI.WebGrid/Configuring Updatable WebGrid in Batch Update mode (Using DataSet Binding).html. 

      As well, I attached you my simple sample using a two columns, Id and field columns. In here, the ID column will give us as "(Auto)" in the new row column, so we do not need to input any value on it. I hope it helps and please, do not hesitate to ask if you have any other questions. Thank you.

Best Regards,

Andi Santoso