Intersoft Community - WebGrid Enterprise - WebGrid Inserting Error

WebGrid Inserting Error

andi@intersoftpt.com — Wed, 20 Jan 2010 22:38:07 GMT

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

WebGrid Inserting Error

jcrendulic — Wed, 20 Jan 2010 11:21:03 GMT

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?

WebGrid Inserting Error

andi@intersoftpt.com — Wed, 20 Jan 2010 02:06:00 GMT

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

WebGrid Inserting Error

jcrendulic — Tue, 19 Jan 2010 16:53:22 GMT

I get an error when I insert a new record and save changes to the grid. The code actually inserts the new record into the table sucessfully by using a stored procedure which is called in the code behind method called protected void WebGrid1_BatchUpdate(object sender, BatchUpdateEventArgs e) . When I refresh the page the record shows up with no errors. I am attaching the screenshot of the error.